Saving Question

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

Why does Excel sometimes ask me if I want to save my spreadhseet even
though I haven't made any changes?

For example, I just brought it up, made no changes, did nothing, and
when I close it out I'm asked if I want to save.

Never understood that.
 
Some functions are "volatile" and force a recalculation upon opening the
workbook. These commands include TODAY(), NOW(), AREAS() and some others I
can't think of right now. Once the workbook is recalced, Excel assumes that
it has changed, even if you didn't really change anything.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top