ExcelBanter - how do i get the option to save changes when i exit

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i get the option to save changes when i exit (https://www.excelbanter.com/excel-discussion-misc-queries/243141-how-do-i-get-option-save-changes-when-i-exit.html)

ceedee

how do i get the option to save changes when i exit

Everytime I close out of excel it does not give me the option to save my
work. Please help.

Pete_UK

how do i get the option to save changes when i exit

You might have volatile functions in your files, like NOW() and TODAY
() and INDIRECT. These will cause the files to be recalculated when
opened, so that Excel thinks the data has changed.

Hope this helps.

Pete

On Sep 18, 8:33*pm, ceedee wrote:
Everytime I close out of excel it does not give me the option to save my
work. Please help.

Gord Dibben

how do i get the option to save changes when i exit

Does this happen with every workbook you open and close?

A particular workbook?

Maybe you have beforeclose event code that saves the workbook?

Have you made any changes that should cause Excel to prompt you to save?

Gord Dibben MS Excel MVP

On Fri, 18 Sep 2009 12:33:01 -0700, ceedee
wrote:

Everytime I close out of excel it does not give me the option to save my
work. Please help.

All times are GMT +1. The time now is 05:04 AM.