How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, BS Degree in Engineering.
Category: Computer
Satisfied Customers: 9658
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Computer Question Here...
John D is online now
A new question is answered every 9 seconds

When exiting excel closes without asking me to save my ...

Customer Question

When exiting excel closes without asking me to save my document.   How do I fix that?
Submitted: 6 years ago.
Category: Computer
Expert:  John D replied 6 years ago.

Hi,

The way it works is that the Save prompt only comes up when you have made changes in the document. This is a standard feature in most windows applications.

Try opening an excel sheet, then enter anything in a cell, and then try to close it. You will be prompted to save.

There is however a 'Save Auto Recover info' option under Tools > Options > Save tab, When checked it will automatically save a temp copy of the file at certain intervals in case of a crash. But this has nothing to do with the regular Save prompt.

Hope this helps.

 

 

John D, BS Degree in Engineering.
Category: Computer
Satisfied Customers: 9658
Experience: Bachelor of Science - Engineering Consultant
John D and 7 other Computer Specialists are ready to help you
Customer: replied 6 years ago.
Reply to John D's Post: That is not how this is working. Changes are made and saved on exit even if they are not wanted. What I need is for excel to ask whether to save on exit.
Expert:  John D replied 6 years ago.

Not sure what you mean by 'saved if they are not wanted'.

Again unless you have some corruption in program files or the registry, after saving a file, if no subsequent changes are made and you try to exit the program you will not be prompted to save.

This feature cannot be changed.

Hope this helps.

 

 

 

Customer: replied 6 years ago.
Reply to John D's Post: I feel I am not being clear. What we want is to be asked on exit if we wish to save the worksheet. There are times when it is decided not to keep changes made to the worksheet. At those times we would not accept the changes.

Right now all changes are forced upon the user, whether she wants them or not. Sometimes she does not want them.
Expert:  John D replied 6 years ago.

Okay, follow these steps and tell me what happens?

1- Start Excel from Start > All Programs > Microsoft Excel
2- Type 'abc' in cell A1
3- Click File > Exit

What happens?

Now
4- Click File > Save As , give it a name and a location, then click the Save button.
5- Click File > Exit

What happens now?

 

 

Customer: replied 6 years ago.
The first time excel forces a save to give the file a name before exiting.

The second time, after the file is already named, the file is saved without saying, the file has not been saved and giving the option to save.

We want excel to always ask whether to save or not as we exit.

Thank again.
Expert:  John D replied 6 years ago.

This is the way it is supposed to work by design.

You see if there are no changes made to the document, there is no reason to ask, or to save it again. It is already saved in that same form. So IT WILL NOT ASK YOU to save it.

But if changes have been made since you last saved it or since you opened the file, IT WILL ASK you if you want to save the file.

That's the way the program works and that cannot be changed.

Hope this helps.

 

 

Customer: replied 6 years ago.
I understand that. I want it to ask, after changes, before saving the file, in case we do not want the changes.

I want excel to ask, "do you want to save the changes you made to file_name.xls" When I choose to exit and have not saved yet.
Expert:  John D replied 6 years ago.
Customer if excel does not ask you to save after you have made changes to the document, then you must have some corrupted program files or registry entries related to this program.

Does this same problem happen in 1) Word, and 2) Notepad?

 

Customer: replied 6 years ago.
No, just excel. I will attempt a repair of excel via add/remove programs.
Expert:  John D replied 6 years ago.

Okay in that case try first to use the excel's repair option. Open Excel then click on Help > Detect and Repair.

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you! RP Austin, TX
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
  • The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
 
 
 

Meet The Experts:

 
 
 
  • Andy

    Computer Consultant

    Satisfied Customers:

    5311
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
< Last | Next >
  • http://ww2.justanswer.com/uploads/EN/Engineer1010/2012-6-9_132423_jaj12a.64x64.jpg Andy's Avatar

    Andy

    Computer Consultant

    Satisfied Customers:

    5311
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
  • http://ww2.justanswer.com/uploads/BA/barrenrock/2011-10-19_215925_JamesJAFinal.64x64.jpg James's Avatar

    James

    Sr. Computer Support Expert

    Satisfied Customers:

    8376
    20 years of experience building, fixing and servicing PCs and operating systems.
  • http://ww2.justanswer.com/uploads/zeyank/2009-09-26_154244_P8110079.png Ryan H.'s Avatar

    Ryan H.

    Computer Support Specialist

    Satisfied Customers:

    1741
    A+ Certified Technician - 10 Years experience working with all types of computer systems.
  • http://ww2.justanswer.com/uploads/JA/jadedangel57/2011-11-8_193134_janenewsm.64x64.jpg Jane Lefler's Avatar

    Jane Lefler

    Sr Prog Analyst / Technician

    Satisfied Customers:

    0
    Computer Programmer / Technician/ Consultant 16+ years
  • http://ww2.justanswer.com/uploads/RO/robmpreston/2013-9-23_233814_mijiFZm.64x64.jpg RPI Solutions's Avatar

    RPI Solutions

    Support Specialist

    Satisfied Customers:

    3476
    5+ Years in IT, BS in Computer Science
  • http://ww2.justanswer.com/uploads/BA/barunrath/2012-7-5_201954_Profilepic2.64x64.jpg B. Rath's Avatar

    B. Rath

    Computer Support Specialist

    Satisfied Customers:

    8671
    Certified Computer/Networking Support Specialist.
  • http://ww2.justanswer.com/uploads/FS/fszcze/2012-6-18_181848_500test.64x64.jpg Frederick S.'s Avatar

    Frederick S.

    Computer Specialist

    Satisfied Customers:

    7240
    Computer technician and founder of a home PC repair company.
 
 
 

Related Computer Questions