Prompt for to save changes

[Bill Chatfield]

I am running Excel 2002 XP SP2 in Windows XP

When I go to close a workbook called 'money' a message box pops up and ask
if I want to save the changes in money.xls - three options = yes - no -
cancel

I have about 10 other workbooks and none of them prompt for this changes
save. I am having problems with this workbook - posted under 'File In Use'
at 3:11 PM today - and am wondering if there is a relationship here.

Is there a way to stop this 'save changes' message box? I do not remember
any settings for this message box.


TIA

Bill Chatfield

 

[Dave Peterson]

And you're confident that you didn't change anything and that you don't have a
macro that changed anything???

Do you have any of these volatile functions in your workbook?

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()

These are volatile functions and excel sees them as causing a change.

And xl2002 will recalc workbooks saved in a previous version when you open them.

 

[Bill Chatfield]

Dave,

As far as I know I didn't change anything - BUT - I cannot be 100% sure. I
don't have any of those functions in any workbooks - I don't even know what
they are for. I am totally confused with this situation. I did create 3
macros in another workbook but have no idea if they affected the 'money'
work book - I have since deleted all 3 macros.


Thanks for responding

Bill Chatfield


And you're confident that you didn't change anything and that you don't have
a
macro that changed anything???

Do you have any of these volatile functions in your workbook?

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()

These are volatile functions and excel sees them as causing a change.

And xl2002 will recalc workbooks saved in a previous version when you open
them.

 

[Dave Peterson]

I saw the three sort macros in your other thread. I don't think that just
having them in the workbook would cause a problem. (If you ran any one of them,
then that would cause excel to think something changed.)

The common ones (=today() and =now()) return the current date and the current
date/time. I'd bet you know if you used them.

If you look inside the VBE, do you see an Auto_open macro in a General module or
any code under the ThisWorkbook (as in workbook_open) module.

Even stuff under the worksheet modules could do something that would cause excel
to think that the workbook needed changing.

If you really don't want any macros in your workbook, Debra Dalgleish has
instructions on how to get rid of them:

http://www.contextures.com/xlfaqMac.html#NoMacros

And if your workbook was created in an earlier version:
I've never had this problem, but I've seen posts where people said that the only
way they could get rid of this problem was to create a new workbook and copy the
info from the older workbook to the new one.

 

[Bill Chatfield]

Dave,

I have deleted all macros in all workbooks. At one point I ran one of the
macros while the 'money' book was open - it sorted some stuff and I manually
re-sorted it and let it go at that. The only thing I know for sure was these
problems began with the macro creation and my playing with them. I have
never learned to 'just leaves things alone'<G>.

For now, I have no macros - and things seem to be ok. I will not be doing
any work in the 'races' workbook until they start racing at Daytona in
February - plenty of time to play around.

I will follow your advice and check out Debra's site. Also, I am not sure
what version of Excel these workbooks were created, I started using Excel
with the one before Excel 97 - SO - that may be part of the solution - copy
data to new workbooks.

Thanks again for your time - you know a lot more stuff than I know<G>

Bill Chatfield



I saw the three sort macros in your other thread. I don't think that just
having them in the workbook would cause a problem. (If you ran any one of
them,
then that would cause excel to think something changed.)

The common ones (=today() and =now()) return the current date and the
current
date/time. I'd bet you know if you used them.

If you look inside the VBE, do you see an Auto_open macro in a General
module or
any code under the ThisWorkbook (as in workbook_open) module.

Even stuff under the worksheet modules could do something that would cause
excel
to think that the workbook needed changing.

If you really don't want any macros in your workbook, Debra Dalgleish has
instructions on how to get rid of them:

http://www.contextures.com/xlfaqMac.html#NoMacros

And if your workbook was created in an earlier version:
I've never had this problem, but I've seen posts where people said that the
only
way they could get rid of this problem was to create a new workbook and copy
the
info from the older workbook to the new one.