Saving no changes

  • Thread starter Thread starter **{Steven}**
  • Start date Start date
S

**{Steven}**

When I open excel, even if I make no changes, it will ask if I want to save
the changes when I close it. Why does this happen and how do I correct it?

Thanks In Advance

Steven Connor
 
You likely have some volatile functions within your workbook, eg =NOW(),
=TODAY(), =RAND() etc. These update every time you open the workbook and so
cause Excel to view change as having been made, hence the message.

Longer list from Norman:-

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()
 
I have none of those. Any other suggestions?

Ken Wright said:
You likely have some volatile functions within your workbook, eg =NOW(),
=TODAY(), =RAND() etc. These update every time you open the workbook and so
cause Excel to view change as having been made, hence the message.

Longer list from Norman:-

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission :-)
-------------------------------------------------------------------------- --
Click to expand...
 
Hi Ken!

This list is now modified:

Extract from Charles Williams' website:
Quote >>
Some of Excel's functions are obviously volatile: RAND(), NOW(), TODAY()

Others are less obviously volatile: OFFSET(), CELL(), INDIRECT(), INFO()
(although the CELL("Filename") function is not volatile)

Some are volatile in some versions of Excel but not in others: INDEX()
became non-volatile in Excel 97.

A number of functions that are documented by Microsoft as volatile do not
actually seem to be volatile when tested:

INDEX(), ROWS(), COLUMNS(), AREAS()

<< End Quote

Me thinks that Microsoft speaks with forked tongue!
--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Steven!

You'll find that the Analysis ToolPak RANDBETWEEN is a function that will
cause the do you want to save message.

Also see:

Charles Williams:
http://www.decisionmodels.com/calcsecretsi.htm


--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Do you have any macros that run on open that make a change?

Have you recently upgraded versions of excel? I know that xl2002 likes to
recalculate the workbook if it was saved in a previous version.
 
I am using office XP. I have none of the formulas mentioned by the others. I
guess I am just doomed to saying no each time I close it, huh?

Sometimes, I would love to address the ms dev teams and tell them that
people are not as stupid as they think we are. We know how to save and how
to make any of the multitude of other choices that ms feels like it has to
do for us, without giving us the choice.

Steven Connor
 
Steven, by all means fire me down a copy of the book and I can take a better
look for you. You'd need to take the NOSPAM bit out of my email address though.
:-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



**{Steven}** said:
I am using office XP. I have none of the formulas mentioned by the others. I
guess I am just doomed to saying no each time I close it, huh?

Sometimes, I would love to address the ms dev teams and tell them that
people are not as stupid as they think we are. We know how to save and how
to make any of the multitude of other choices that ms feels like it has to
do for us, without giving us the choice.

Steven Connor
Click to expand...
 
Have you recently upgraded versions of excel?

Am pretty sure it was that Dave - Opened it and closed and was prompted. Opened
and saved once and closed again. Opened half a dozen times again and closed and
didn't get prompted once. Tried in both XP and 2003 and same.
 
Back
Top