Linking a cell from another file

  • Thread starter Thread starter JC
  • Start date Start date
J

JC

In my version of excel 2003 when I link a cell from another file to my
current work file, I cannot copy that cell in sync. Ex.
When I copy the cell =file name A1 into the new spreadsheet, then I try to
drag and copy, the cell remains =file name A1 and not =File name A2.

I've done this many times and does not work - any ideas
 
Just click inside the formula bar for the top left linked cell, manually
edit/change the cell refs to relative (remove all $ signs), then it'll fill
properly from there.

Excel's "unfortunate" default when you click to link across books seems to
be absolute, eg: =[isna.xls]Sheet2!$A$1
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
 
Hi,

When you need to remove $ sighs, the fast way is to highlight the portion of
the formula with them and press F4 until they are removed completely.
F4 cycles through the four possible reference types:
$A$1, A$1, $A1 and A1.
 
Back
Top