Excel always asks to save even without making changes

Jegacats

Board Regular
Joined
Jul 30, 2002
Messages
136
My client is tired of excel always asking if he wants to save his files.
I checked on my stn and if I make no changes, excel closes the files without asking the question.
I asked the client to send me one of his files.
I opened the file and closed it immediately without making any modifications. I was asked if I wanted to save the doucument. I checked the version and this file wanted to save in 95. I then saved it to 97. My station is by default 97. So I thought this would resolve the problem. No.

I then opened the file (saved in 97 format, with my workstation configured for 97) I closed it immediately without making any changes and was again faced with the prompt asking if I wanted to save. .....

How can I get rid of this msg if I make no changes. I also checked for a macro and there aren’t any.

Any suggestions?
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Is there anything in the workbook that changes when the workbook is opened? e.g. if I use the "NOW" function, when I open up the workbook Excel changes the value in that cell. When I close that workbook, without making any manual changes, Excel still asks me if I want to save.
 
Upvote 0
Tell the guy to quit snooping around in all the files; most people DO SOMETHING when they open a file.
 
Upvote 0
Thank you. I did find ()NOW and took them all out, but it still asks the question.
Is there anything I should be looking for and is there a quick way to find it. the workbook has 5 sheets and many lines.
Could links have anything to do with. I had thought of this but eliminated is because I didn't get the question to update links when I opened the file.
 
Upvote 0
Hi
Look for why excel decdes to save or not is POINTLESS if she say so DO IT!!!

Any calculation or in most cases cell change will be classed as CHANGE even if no data is entered

Excel will re cal oftn and like you have been told NOW will re cal often so is a change even if dats is not edited.

Thats how excel is programmed to work, i suggest working with excel to get her best.

HTH

Jack
 
Upvote 0
Hi Jaga

Jega
Help Desk Analyste (HDA)
Microsoft Office 97 User Specialiste (MOUS)
Global Services Centre (GSC)

With this list of excellence in preplex at why you asked this, i would have in view i just saw this expect the understanding and competence to be there, and would have expected a rquest for a fix, is this what you want??

If so we need to work out why documents are opened and no edits take place -

If this is reference only in a general capacity - why not code out scripts to make close to false re the save changes

Does that sound like waht you really want..

HTH

Jack
 
Upvote 0
Jega,

Try this, go to Tools/Options/Edit tab and uncheck Enable auto complete for cell values
 
Upvote 0
Yes Jack
This is exactly what I wanted. A solution
My client has to open several files at once
to look at info and he finds it tedious to
always have to respond to this question asking if he wants to save. I mentionned the solutions that have been supplied and also suggested he find someone in programming to do a vba code to cancel this pop up. He is hoping for Microsoft to supply a check box allowing one to decide if one wants the pop up box. For now, however,he has finally accepted my explanation. Thanks for all the help

Jega
 
Upvote 0
He is hoping for Microsoft to supply a check box allowing one to decide if one wants the pop up box.

I feel sorry for you. Clients are great. Especially clients for engineering companies. :biggrin:
 
Upvote 0
Excel always asks to save any workbook (even empty one)

When I open Excel and then close it imedatelly, Excel asks to save the empty file...

It was working fine an hour ago and now this is happening.

If I log on the same computer using another user, the problem does not happen...

Thanks.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top