Solved

Excel doesn't prompt me to save when closing a file / excel?

Posted on 2007-03-20
9
825 Views
Last Modified: 2007-04-29
When I close out of excel, excel doesn't prompt me if I want to save or not (when I did not save my changes prior to closing). Why is this happening and how can I fix this?
0
Comment
Question by:dm25
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 251 total points
ID: 18757013
Is this with all workbooks or one particular one? Do you have any add-ins loaded, and if so, which ones?
Regards,
Rory
0
 
LVL 4

Assisted Solution

by:psychakias2
psychakias2 earned 166 total points
ID: 18757061
This can be due to the following reasons:

1) The file has already been saved automatically.

If you have Office 2002 or greater, you will find this setting here: Tools > Options > Save > Save autorecover every XX minutes
If you have Office 2000 or less, you will find this setting here: Tools > Autosave

2)The file has hides VB code that saves it automatically.

To look if there is such code, Press ALT-F11 and look, and when the VBA window pops up, double click on the workgroup name (on the left side of your screen) to see the code that is behind this workbook.

You would be looking for something like this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Me.Save
End Sub
0
 
LVL 16

Assisted Solution

by:AdamRobinson
AdamRobinson earned 83 total points
ID: 18757083
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:dm25
ID: 18757096
phychakias,

The > Options > Save > Save autorecover every XX minutes option is for autorecovery, not for autosafe.....I don't think its the same thing. I tried setting the autorecovery to 1 minute, and after 1 minute I close excel and open it back up again and it doesn't automatically save the file.

As for the VB code, shouldn't it still apply even if it is hidden?
0
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 251 total points
ID: 18757132
You might have code that does something like:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
me.saved = true
End Sub
in which case Excel wouldn't bother saving the file.

Regards,
Rory
0
 

Author Comment

by:dm25
ID: 18757154
Rorya,

I have excel version 2002. The add ins that I have loaded are 1) Analysis Toolpack 2) Eurocurrency tools 3) Lookup wizard 4) Conditional sum wizard 5) Solver.
0
 
LVL 85

Assisted Solution

by:Rory Archibald
Rory Archibald earned 251 total points
ID: 18757215
And is it just one workbook you have this problem with or all of them? (or somewhere in between)
Do you have any code in the workbook(s) in question?
Regards,
Rory
0
 
LVL 4

Assisted Solution

by:psychakias2
psychakias2 earned 166 total points
ID: 18757376
dm25, if you find the code that I mentioned in my first post, then all you have to do is to hit delete. :-)
0
 

Author Comment

by:dm25
ID: 18998678
Not sure which solution is right (I didn't have to resolve this problem), so I thought I would give everyone points.  Thank you all.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question