View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default save changes when no changes made

If the workbook was created in an earlier version of excel, then xl2002 will
recalculate it when it opens.

And then when you close the workbook, excel thinks that you should be prompted.

I just saved as the newer version and the problem would go away.

But I've seen posts that this hasn't worked for a few people. They actually
ended up just copying the data from the old workbook and pasting it into a new
workbook. (Or they copied the worksheets into a new workbook--I don't recall.)



Elaine wrote:

When I go to close an Excel document, I am asked about saving changes even
though none have been made. I have already searched this question here and
every suggestion has not helped. I do not have any macros in the workbook,
no links to any other workbooks and it does not have any functions that may
cause this (I know that TODAY(), NOW(), etc.) can cause this.

Any suggestions to find what I have stuck in the file or a setting wrong? I
have Excel 2002


--

Dave Peterson