Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|