Excel asks to save an unchanged document. Why?

[Guest]

Whenever I try to close an Excel documnet that I havent made any changes to,
Excels asks me if I would like to save the document? Why? Can I stop this?

 

[Don Guillett]

You probably have a formula like =today() or something that DOES change the
workbook.

 

[Guest]

have seen that posting here before, do a keyword search. An MVP/ site.. said
if you have made/saved a macro the save feature may prevail. They had a
script for disregard (file date?) changes during opening of file.

else maybe copy sheet to a new workbook, if not too much column width/
formatting going on... search this board to find more

 

[Gord Dibben]

Perhaps you have one or more "Volatile" functions that calculate when the
workbook is opened.

These could include

Volatile Functions.....................

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

If such is the case, you can stop the warning only if you find these functions
and change them to fixed values by copy>paste special>values


Gord Dibben MS Excel MVP

Whenever I try to close an Excel documnet that I havent made any changes to,
Excels asks me if I would like to save the document? Why? Can I stop this?

Gord Dibben MS Excel MVP

 

[Peo Sjoblom]

Not INDEX, it became non volatile with excel 97


Peo

 

[Gord Dibben]

Another one bites the dust<g>

My list if getting shorter every time I post it.

Thanks Peo

Not INDEX, it became non volatile with excel 97


Peo

Gord Dibben MS Excel MVP

 

[L. Howard Kittle]

Hi Gord and Peo,

Where or how would you use AREAS()? I checked help and understand what it
returns but cannot think of an application where I would use the first to
return 1 and the second to return 3.

=AREAS(B24)
=AREAS((B24,E5,F6:I9))

Regards,
Howard

 

[Peo Sjoblom]

I don't know, I have never used it

Peo

Hi Gord and Peo,

Where or how would you use AREAS()? I checked help and understand what it
returns but cannot think of an application where I would use the first to
return 1 and the second to return 3.

=AREAS(B24)
=AREAS((B24,E5,F6:I9))

Regards,
Howard

 

[Gord Dibben]

Howard

Same answer as Peo.

Never used the Function but Norman Harker's Function Dictionary has this brief
description.

What Does It Do?
This function tests a range to determine whether it is a single block of
data, or whether
it is a multiple selection.
If it is a single block the result will be 1.
If it is a multiple block the result will be the number of ranges
selected.
The function is designed to be used in macros.

Syntax
=AREAS(RangeToTest)

Formatting
The result will be shown as a number.

Example
The example at the top of this page shows two ranges coloured pink and
green.
These ranges have been given the name PeopleLists.
The =AREAS(PeopleLists) gives a result of 2 indicating that there are
two separate
selections which form the PeopleLists range.

Note
To name multiple ranges the CTRL key must be used.
In the above example the pink range was selected as normal, then the
Ctrl key
was held down before selecting the green range.
When a Range Name is created it will consider both Pink and Green as
being one range.



Gord

Hi Gord and Peo,

Where or how would you use AREAS()? I checked help and understand what it
returns but cannot think of an application where I would use the first to
return 1 and the second to return 3.

=AREAS(B24)
=AREAS((B24,E5,F6:I9))

Regards,
Howard

Gord Dibben MS Excel MVP

 

[Peo Sjoblom]

I guess if you have a defined name that uses non continuous ranges it would
tell you that

Peo