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.