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 ?

Peter


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'

Lucky
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
.


Reply

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




Thread Tools




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 01:31 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33