Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Save Changes?
Sometimes, but not always, Excel asks if I want to save the current file,
even though I've made no changes. Does anyone know why this occurs, and if there is a setting I can change to avoid the prompt unless actual changes are made? Thank you. Sprinks |
#2
|
|||
|
|||
There are a number of functions that will update themselves when
the workbook is opened, and this causes Excel to act as though the workbook has been changed. These functions include NOW() , TODAY(), ROW(), etc. See Volatile Functions in help for more info. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Sprinks" wrote in message ... Sometimes, but not always, Excel asks if I want to save the current file, even though I've made no changes. Does anyone know why this occurs, and if there is a setting I can change to avoid the prompt unless actual changes are made? Thank you. Sprinks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot edit and save | New Users to Excel | |||
cannot edit and save | Excel Worksheet Functions | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Missing "Save" and "Save As" functions | Excel Discussion (Misc queries) |