CELL("FILENAME")
 

Ive used CELL(€˜FILENAME) on two different workbooks which are now used as
templates. Both files are open. Each time I use SAVE AS to create a new file,
I know I have to SAVE or hit F9 to update the filename on that specific
sheet.

Question: Why would both open sheets show the most recently saved filename
when I only saved one? Once I save (or F9) the other sheet - the one that
should not have the new name..it updates..but is that how it's supposed to
work?

Thanks for the insight.

=CELL("Filename",A1)

JEV wrote:
Ive used CELL(€˜FILENAME) on two different workbooks which are now used as
templates. Both files are open. Each time I use SAVE AS to create a new file,
I know I have to SAVE or hit F9 to update the filename on that specific
sheet.

Question: Why would both open sheets show the most recently saved filename
when I only saved one? Once I save (or F9) the other sheet - the one that
should not have the new name..it updates..but is that how it's supposed to
work?

Thanks for the insight.

You need to include a cell reference in the call to CELL. E.g.,

=CELL("filename",A1)

The actual cell reference doesn't matter, just so long as it is
on the same sheet as the CELL function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"JEV" wrote in message
...
I've used CELL('FILENAME') on two different workbooks which are
now used as
templates. Both files are open. Each time I use SAVE AS to
create a new file,
I know I have to SAVE or hit F9 to update the filename on that
specific
sheet.

Question: Why would both open sheets show the most recently
saved filename
when I only saved one? Once I save (or F9) the other sheet -
the one that
should not have the new name..it updates..but is that how it's
supposed to
work?

Thanks for the insight.

see http://www.xldynamic.com/source/xld.xlFAQ0002.html for an explanation.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JEV" wrote in message
...
I've used CELL('FILENAME') on two different workbooks which are now used
as
templates. Both files are open. Each time I use SAVE AS to create a new
file,
I know I have to SAVE or hit F9 to update the filename on that specific
sheet.

Question: Why would both open sheets show the most recently saved filename
when I only saved one? Once I save (or F9) the other sheet - the one that
should not have the new name..it updates..but is that how it's supposed to
work?

Thanks for the insight.

Very good. Thanks for the explanation.

"Bob Phillips" wrote:

see http://www.xldynamic.com/source/xld.xlFAQ0002.html for an explanation.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JEV" wrote in message
...
I've used CELL('FILENAME') on two different workbooks which are now used
as
templates. Both files are open. Each time I use SAVE AS to create a new
file,
I know I have to SAVE or hit F9 to update the filename on that specific
sheet.

Question: Why would both open sheets show the most recently saved filename
when I only saved one? Once I save (or F9) the other sheet - the one that
should not have the new name..it updates..but is that how it's supposed to
work?

Thanks for the insight.