Autosave function

[djprescott]

I am finding that on my excel speadsheets, I am being asked to save the changes to the document on exit, even if I have made no changes to the spreadsheet. It appears this is on larger files. Is there any way I can stop this occurring? I have looked through the settings but can't see anything.

Dave

[Aquariel]

Dave, if your spreadsheet has a lot of auto-calculated formulas, then they will be updated when you load the spreadsheet; therefore it will have changed and you will be asked to save it every time you close it.

[jordi2k]

This doesnt sound like an 'Autosave' function, but instead is occuring because in some way, shape or form the spreadsheet has been changed..

Autosave can be enabled/disabled from the 'Tools' menu (but has to be added in initially to appear).. Tools > Add-Ins > AutoSave will do this for you.

Excel considers change as anything from closing on a different sheet tab to even just recalculating a formula even though the end result may still be the same, re-calculating is 'change' as far as it can see.

If this is causing you major problems then open the sheets as Read-Only so that you know nothing has been changed by mistake and saved over the top of something important.

Also bearing in mind that any 'Links' to other workbooks that are updated will also result in Excel asking you to save the spreadsheet, again even if nothing value wise has actually changed...

[djprescott]

Ah - that could be the answer. Thanks.