Exiting Worksheet
Some worksheets when exiting ask you if you want to save the file even if no
changes were made to the file some don't. Does anyone know what causes this and how to shut that feature off? |
Evan
Newer versions of Excel like to re-calculate everything when opening a file created in a previous version. Does it ask every time even after you complied and saved? You also could have one or more Volatile Functions that calculate. There are more Volatile Functions than the average user thinks there are. AREAS() INDEX() OFFSET() CELL() INDIRECT() ROWS() COLUMNS() NOW() TODAY() RAND() Also, do you have "Iteration" checked? Uncheck if so. Gord Dibben Excel MVP On Fri, 11 Feb 2005 09:31:17 -0800, "Evan" wrote: Some worksheets when exiting ask you if you want to save the file even if no changes were made to the file some don't. Does anyone know what causes this and how to shut that feature off? |
All times are GMT +1. The time now is 10:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com