Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel calls for Save
I open my xls file, make NO change, and it gives me: Save... etc? How can I
avoid this trouble? Thanks... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel calls for Save
Your sheet may contain some data that automatically updates, like a date.
Since the date changes daily, Excel is asking whether you want to keep the update. "~Bolesław Cienki" wrote in message ... I open my xls file, make NO change, and it gives me: Save... etc? How can I avoid this trouble? Thanks... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel calls for Save
Not sure what "etc." means but perhaps you have one or more volatile functions
in your workbook. There are several Volatile Functions. AREAS() OFFSET() CELL() INDIRECT() NOW() TODAY() RAND() Any one or more of these could be the culprit that is updating and causing the change(s) to be made. You can do a Find for these or hit CTRL + `(backquote above Tab key) to toggle View Formulas on and do a look search by eyeball. Also, if the workbook you are opening was created in an older version of Excel, you will be prompted to save...........maybe that's what "etc." was? If you do save, you won't be prompted again. Gord Dibben MS Excel MVP On Fri, 25 Aug 2006 14:25:37 +0200, "~Bolesław Cienki" wrote: I open my xls file, make NO change, and it gives me: Save... etc? How can I avoid this trouble? Thanks... Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |