Is there any way to set Excel to automatically do that?
G Gary''s Student Mar 22, 2007 #2 If you done a SaveAs, the formula will update as soon as any calculation occurs on the worksheet. Otherwise, touch F9.
If you done a SaveAs, the formula will update as soon as any calculation occurs on the worksheet. Otherwise, touch F9.
D Dave Peterson Mar 22, 2007 #3 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.
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.
