ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Upon exiting Excel I am not prompted to SAVE the file (https://www.excelbanter.com/excel-discussion-misc-queries/203715-upon-exiting-excel-i-am-not-prompted-save-file.html)

ebbs

Upon exiting Excel I am not prompted to SAVE the file
 
When I exit a workbook I am not asked if I want too save the changes. How do
I fix that?

Dave Peterson

Upon exiting Excel I am not prompted to SAVE the file
 
Don't make changes to the workbook when it's open.
Don't have macros run that make changes to the workbook.
Don't use volatile functions that recalc (and tell excel that the workbook has
been changed). Some of these functions are =now(), =rand(), =date(),

ebbs wrote:

When I exit a workbook I am not asked if I want too save the changes. How do
I fix that?


--

Dave Peterson

Bruce Sinclair

Upon exiting Excel I am not prompted to SAVE the file
 
In article , wrote:
Don't make changes to the workbook when it's open.
Don't have macros run that make changes to the workbook.
Don't use volatile functions that recalc (and tell excel that the workbook has
been changed). Some of these functions are =now(), =rand(), =date(),

ebbs wrote:

When I exit a workbook I am not asked if I want too save the changes. How do
I fix that?


Dave, I suspect you answered the question that the OP meant to ask ... but
the question as asked says how can they make sure that they *are* asked if
they want to save changes. :)


Dave Peterson

Upon exiting Excel I am not prompted to SAVE the file
 
Actually, I think I misread the original post.

I've seen a couple of posts that complain that they aren't prompted to save
their changes when they should have been asked.

I don't recall ever seeing a good reason why this should happen--but it must
happen for some.

To the original poster...

Sorry about my response. I don't have a guess why you're having trouble.

Bruce Sinclair wrote:

In article , wrote:
Don't make changes to the workbook when it's open.
Don't have macros run that make changes to the workbook.
Don't use volatile functions that recalc (and tell excel that the workbook has
been changed). Some of these functions are =now(), =rand(), =date(),

ebbs wrote:

When I exit a workbook I am not asked if I want too save the changes. How do
I fix that?


Dave, I suspect you answered the question that the OP meant to ask ... but
the question as asked says how can they make sure that they *are* asked if
they want to save changes. :)


--

Dave Peterson

Bruce Sinclair

Upon exiting Excel I am not prompted to SAVE the file
 
In article , wrote:
Actually, I think I misread the original post.

I've seen a couple of posts that complain that they aren't prompted to save
their changes when they should have been asked.

I don't recall ever seeing a good reason why this should happen--but it must
happen for some.

To the original poster...

Sorry about my response. I don't have a guess why you're having trouble.


I hasten to add that neither do I, as I have never seen that in any
version of XL from 5 to 2003 SP3. :)


Bruce Sinclair wrote:

In article ,

wrote:
Don't make changes to the workbook when it's open.
Don't have macros run that make changes to the workbook.
Don't use volatile functions that recalc (and tell excel that the workbook

has
been changed). Some of these functions are =now(), =rand(), =date(),

ebbs wrote:

When I exit a workbook I am not asked if I want too save the changes. How

do
I fix that?


Dave, I suspect you answered the question that the OP meant to ask ... but
the question as asked says how can they make sure that they *are* asked if
they want to save changes. :)




All times are GMT +1. The time now is 12:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com