Software

Ask something
Discussion Locked

Save on Exit - Excel

0 helpful
9 replies

by jobrika

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Some users when exiting are asked if they want to save their work, others are not asked, Excell automatically does the save.

This is not good as somesheets are used as calculation only and should not be saved on exit.

I tried all the menues orat least thought I had coved all of them.

9 replies

by dklippert

Check for macros, either with the particular spreadsheet, in Personal.xls, or included with an add-in. Look in the XLStart folder to see if anything has been added.
You can have a macro the will ?Quit? Excel with or without saving or questioning the user.

This article is a bit obscure, but it may fit your situation:
(Type the Q number into the ?For solutions containing...? box at support.microsoft.com)

Not Prompted to Save Changed Workbook When You Quit

Q176700

by cnlson

to make a spreadsheet not retain changes ou may want to try changing its attributes to read-only. that way no one should be able to save anychanges to it. all users will be prompted to save as a different name if they wish to save.

by chris hirst

Check for the Autosave Add-in, Tools\Autosave... if loaded.

This has a checkbox on it for prompting on\off.

by jobrika

I have no Personal.xlt or .xls files. There are no files in XLstart. Program still asks for save to a changed spreadsheet on exit.

This discussion is closed to new replies.