unchanged file (excel)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

With an unchanged file (excel) I am prompted to save the "changed" file upon
closing. Only seems to happen on excel files.
 
If you have a volatile function, the automatic calc on opening will
cause a change that prompts the Save.

Volatile functions include NOW(), TODAY(), RAND(), AREAS(), CELL(),
COLUMNS(), INDEX(), INDIRECT(), OFFSET(), ROWS().
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Excel does not update my recently used files. 8
Excell 2021 0
Link question 1
How to modify specific lines in a .ini file? 2
excel print formatting issues 1
"Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Pleas 0
Copying and renaming a file 1
How to paste Word table into Excel 2003 intact? 1

Back
Top