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
Avoid "boot with safe mode" message after energy loss
Hello @all! Sorry for my English... I'll try to explain it as simple as possible. We have a computer where only remote access is done. We do not use keyboard or screen on it because we don't need to access it locally. We had a problem to which I am looking for a solution. After a short...
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 avoid the "Other people are logged on to this computer ..." ?
Hello, I have Windows 7 Pro with 4 users, a user for each member in my family. When I try to shutdown the system while other users are logged on, I'm getting this message. How can I force shutdown & avoid this message ? The reason that I need to force shutdown is that recently, I have...
General Discussion
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
How to avoid "invalid IP configuration" connection error?
Hi all, I have a problem with my internet connection on my PC. The internet connection works fine, until I let my PC idle for about an hour or so. The connection then dies, but can be repaired by the Windows Troubleshooter which fixes the error message about the invalid IP configuration....
Network & Sharing

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 05:46.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App