Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell("filename") doesn't update to new filename when do save as.
Is there any way to set Excel to automatically do that?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell("filename") doesn't update to new filename when do save as.
If you done a SaveAs, the formula will update as soon as any calculation
occurs on the worksheet. Otherwise, touch F9. -- Gary''s Student gsnu200711 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell("filename") doesn't update to new filename when do save as.
And you'll want to add a range reference to that formula:
=cell("Filename",a1) Unless you want to show the name of the workbook/worksheet that was active when excel recalculated. Louis wrote: Is there any way to set Excel to automatically do that? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELL("filename") acting Volatile? (in assoc. with PULL) | Excel Worksheet Functions | |||
Can I Select an "Import" Template Based on a Doc's Filename? | Excel Discussion (Misc queries) | |||
=CELL("filename") VOLATILE? | Excel Worksheet Functions | |||
=cell("filename") in multiple places | Excel Worksheet Functions | |||
Excel assigns "1" after the filename | Excel Discussion (Misc queries) |