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. |