save changes when no changes made
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 |
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 |
save changes when no changes made
Elaine
There are a few other volatile functions that would cause this. AREAS() INDEX() OFFSET() CELL() INDIRECT() ROWS() COLUMNS() NOW() TODAY() RAND() Dave is probably correct with the older version.newer version guess. Gord Dibben MS Excel MVP On Wed, 18 Jan 2006 10:17:02 -0800, 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 |
All times are GMT +1. The time now is 04:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com