Link to home
Start Free TrialLog in
Avatar of dm25
dm25

asked on

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

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?
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dm25
dm25

ASKER

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?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dm25

ASKER

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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dm25

ASKER

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.