Simple question?

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
 
P

Paul B

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 **
 
K

Ken Wright

Previously posted by Norman Harker:-

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

Bill D

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?
 
D

Dave Peterson

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).
 
B

Bill D

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!
 
M

marston_gould

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
 
M

marston_gould

Another possibility is that you have iterations turned on or perhaps
something is triggering the Recalc before save . check in tools options
calculation
 
J

JulieD

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
 
J

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...
 
Top