Cell("filename") doesn't update to new filename when do save as.
 

Is there any way to set Excel to automatically do that?

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

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