Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Avoid popup "Save changes?" when nothing was changed in Excel doc?

19 Oct 2010   #1

win7pro 64bit
Avoid popup "Save changes?" when nothing was changed in Excel doc?

Whenever I open some Excel docs to have a look at the content table and want to close it afterwards WITHOUT CHANGING ANYTHING then Excel (2003/2007) asks me
if I want to save the changes.

I think Excel automatically re-calculates embedded formulas even if I did not type in manually stuff.

So Excel thinks I made some changes.

How can I tell Excel to NOT prompt me any more to save changes if the changes are only based on formula re-calculations ?

If this is not possible: How can I tell Excel to automatically save all changes without prompting me?

Is it possible to setup this preference for ALL excel docs at once rather than for each Excel doc individually ?


My System SpecsSystem Spec
19 Oct 2010   #2

Windows 7 Ultimate x64 RTM + SP1

I don't believe this is possible.

And plus, yes its annoying but without it, there will almost certainly be a time when you will close a document and you will lose everything if you forgot to hit the 'save' button.

Best thing i would say is live with it, it only gives you three option anyway and it only takes two seconds too choose 'yes' or 'no'

My System SpecsSystem Spec
21 Oct 2010   #3


Happens all the time in practically any MS Office app. Like I open a Word doc to print, then try to close it. "Save (Y/N)?" even though I didn't edit anything. Ditto Excel. Ditto PowerPoint.

I fully expect that on one fine day I'll hit N out of sheer reflex - and then realize a split second later I just nailed my ass to the wall.
My System SpecsSystem Spec


 Avoid popup "Save changes?" when nothing was changed in Excel doc?

Thread Tools

Similar help and support threads
Thread Forum
Save/Open Dialog-boxes, remembering "SIZE" & "POSITION"
I have some programs I would like to have there save/open dialog boxes remember - SIZE - POSITION Namely: Firefox, because I download program updates and export/HTML my FF bookmarks for a use in Firefox as a single scrolling list for quick update checks... frequently... it seems to...
General Discussion
"search box" disabled on "save" or "save as" file dialog
So, the search box found on Wordpad, Windows Explorer or the Start Menu are unaffected. Now, from any other document-orientated desktop application (Word 2013, LibreOffice, Abbyy Reader, iMindMap, Firefox browser), if I click on "save" or "save as" buttons, the file save dialog box appears and is...
Microsoft Office
Appearance of "close", "minimize" ecc buttons changed
Hi, After reinstalling my Windows I've noticed it looks different. everything looks brighter and the windows buttons are different, instead of the normal left one I have the annoying appearance on the right. (images attached) I know it has something to do with the color setting but I can...
General Discussion
Disable popup "Do you want to scan and fix remov.device""? 2 methods?
When I plugin an external USB hard disc or USB stick it appears that Windows 7 pops up a dialog window asking me: "Do you want to scan and fix removable disc?" After reading a while in Internet I saw two methods for disabling these popups: 1.) Disabling service "Shell Hardware...
Hardware & Devices
How to default to "Browse Folders" on "Save as.."
Whenever I perform a "Save As..." or a "Save File" (e.g. with an email attachment), the pop-up save menu always defaults to NOT displaying the navigation pane(s) showing the existing folders/files in the target folder - see thumbnail below left. To view the folder tree and folder/file list (see...
General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 06:07.
Twitter Facebook Google+