| 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) | |||
Hybrid Mode
