Simple question?

  • Thread starter Thread starter Bill D
  • Start date Start date
B

Bill D

Hi,

A worksheet I use regularly has recently started to ask if I wish to save
changes made to it upon closing it even though I have only viewed it and not
modified it in any way.

Is there any way I can establish why it id soing this and how to stop it/
(It always concerns me in case I have accidentally made any changes to such
an important document)

Many thnaks
 
Bill,
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.

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 2000 & 2003
** remove news from my email address to reply by email **
 
Previously posted by Norman Harker:-

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()
 
Do you have any macro's on in the workbook?
Click to expand...

..................

Thanks for all of the replies....

Strange one this one as this has only recently started to do this without
any functionality/formulae changes having been made to the worksheet!!

The only functions used are SUM, SUMIF and COUNTIF ???

Any more ideas please?
 
Any chance you just started using a newer version of excel. xl2002+ likes to
recalculate the workbook when it opens (if it was created in an earlier
version).
 
No I haven't - just the same old 2002 Excel version. As I say, it's only
very recently started doing this, and it's a file I've been using for many
months now!
 
Do you have Autosave turned on? There was a bug in one version of this
add-in at one time that caused this kind of problem
 
Another possibility is that you have iterations turned on or perhaps
something is triggering the Recalc before save . check in tools options
calculation
 
Hi Ken

a while back i was lead to believe by another poster in this forum that
INDEX wasn't volatile .. any way of checking?

Cheers
JulieD
 
Hi Debra

thanks for this - very useful website.

Cheers
JulieD

Debra Dalgleish said:
Charles Williams has information on volatile functions on his web site:

http://www.decisionmodels.com/calcsecretsi.htm
Hi Ken

a while back i was lead to believe by another poster in this forum that
INDEX wasn't volatile .. any way of checking?

Cheers
JulieD

Previously posted by Norman Harker:-

AREAS()
INDEX()
OFFSET()
CELL()
INDIRECT()
ROWS()
COLUMNS()
NOW()
TODAY()
RAND()
Click to expand...
--------------------------------------------------------------------------

--




Bill,
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.

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 2000 & 2003
** remove news from my email address to reply by email **



Hi,

A worksheet I use regularly has recently started to ask if I wish to
save

changes made to it upon closing it even though I have only viewed it
Click to expand...
and not
modified it in any way.

Is there any way I can establish why it id soing this and how to stop
it/

(It always concerns me in case I have accidentally made any changes to
such

an important document)

Many thnaks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top