Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn off the "do you want to save" alert in excel?
I use Excel extensively and would like to turn off the alert that asks me to
save every time I attempt to close a workbook. 99% of the time, I am not making changes to the data, simply viewing. Any hints? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn off the "do you want to save" alert in excel?
SLB
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. If you do save, you won't be prompted again. Gord Dibben MS Excel MVP On Tue, 29 Aug 2006 14:17:01 -0700, SLB, accounting <SLB, wrote: I use Excel extensively and would like to turn off the alert that asks me to save every time I attempt to close a workbook. 99% of the time, I am not making changes to the data, simply viewing. Any hints? 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 | |||
Is there a way to permanently turn off hyperlinks in Excel 2002 | Excel Discussion (Misc queries) | |||
How do I turn off virus scan on opening an Excel file? | Excel Discussion (Misc queries) | |||
Excel 2003 - turn off option in autofilter | Excel Discussion (Misc queries) | |||
Turn off Assistance pane in Excel | Excel Discussion (Misc queries) |