Save prompt when no changes made
 

I have a spreadsheet which always asks whether I want to save the changes
I've made. But I haven't made any. I can open the file, immediately close
it, and still get the save prompt.

How do I track down what's causing the save prompt? The workbook has about
10 sheets and a few macros, if that makes any difference. I'm using Excel XP
on Windows XP.

--
Regards,
Fred
Please reply to newsgroup, not e-mail

Fred,
Some functions in excel are "volatile", they will re-calculate every time
excel is opened, this will make the worksheet change even if you don't make
any changes.
Here are some of the functions that will cause this to happen, there are
probable many more, but they don't come to mind right now
NOW
TODAY
RAND
INDEX
INDIRECT
OFFSET


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Fred Smith" wrote in message
...
I have a spreadsheet which always asks whether I want to save the changes
I've made. But I haven't made any. I can open the file, immediately close
it, and still get the save prompt.

How do I track down what's causing the save prompt? The workbook has about
10 sheets and a few macros, if that makes any difference. I'm using Excel
XP
on Windows XP.

--
Regards,
Fred
Please reply to newsgroup, not e-mail

Paul

A few more......

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


Gord Dibben Excel MVP

On Wed, 26 Jan 2005 22:12:17 -0500, "Paul B"
wrote:

Fred,
Some functions in excel are "volatile", they will re-calculate every time
excel is opened, this will make the worksheet change even if you don't make
any changes.
Here are some of the functions that will cause this to happen, there are
probable many more, but they don't come to mind right now
NOW
TODAY
RAND
INDEX
INDIRECT
OFFSET

Thanks guys, that helps a lot. Is there any way to get Excel to show me
which ones are volatile? Is there an audit function, for example, which
would identify the volatile functions in my workbook?

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Paul

A few more......

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


Gord Dibben Excel MVP

On Wed, 26 Jan 2005 22:12:17 -0500, "Paul B"

wrote:

Fred,
Some functions in excel are "volatile", they will re-calculate every time
excel is opened, this will make the worksheet change even if you don't
make
any changes.
Here are some of the functions that will cause this to happen, there are
probable many more, but they don't come to mind right now
NOW
TODAY
RAND
INDEX
INDIRECT
OFFSET