Range Labels

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have 2 files. In the first file, I have a formula that
reads c:\filetwo.xls'!rangeone and this formula reads
cell C6 in filetwo. However, when I open filetwo the
formula in fileone changes to c:\[filetwo]A'!c6 That
causes a problem because if I then add a row to filetwo
when fileone is not opened, when I re-open fileone, it
will read cell d6 instead of c6.

My question is how can I make the formula stay as
rangeone? In LOTUS, you just put a $ before the range
name, but EXCEL does not seem to accept this. Help!
 
I use xl2002 and couldn't duplicate your problem.

I created two workbooks.

With the file open, the formula looked like:
=book2a.xls!rangeA1

and with the workbook closed, it looked like:
='C:\My Documents\excel\book2a.xls'!rangeA1

(I used a slightly different range name.)

Two questions:

What version of excel are you using--maybe someone can try to duplicate it.

And is there a typo in your formulas--the drive/folder should have been dropped
when the workbook was opened (if that formula referred to the workbook that was
opened?)

I created a third workbook of the same name. When I opened that workbook, excel
was smart enough not to see it as the linked workbook and kept the formula like:
='C:\My Documents\excel\book2a.xls'!rangeA1


I have 2 files. In the first file, I have a formula that
reads c:\filetwo.xls'!rangeone and this formula reads
cell C6 in filetwo. However, when I open filetwo the
formula in fileone changes to c:\[filetwo]A'!c6 That
causes a problem because if I then add a row to filetwo
when fileone is not opened, when I re-open fileone, it
will read cell d6 instead of c6.

My question is how can I make the formula stay as
rangeone? In LOTUS, you just put a $ before the range
name, but EXCEL does not seem to accept this. Help!
Click to expand...
 
Back
Top