| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
always prompted to save opened workbooks
Any time I open a workbook, even if just to print it from windows explorer,
I'm prompted to save (Do you want to save the changes you made to "filename.xls") However, no changes are made...Is there something I can do to keep from being asked after opening every file? I found the "Remove Hidden Data" on this machine and removed it via Add/Remove Programs, then restarted the computer. However, I'm still receiving the same prompts. Thanks for any help you can provide. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
always prompted to save opened workbooks
kjbrr wrote: Any time I open a workbook, even if just to print it from windows explorer, I'm prompted to save (Do you want to save the changes you made to "filename.xls") However, no changes are made...Is there something I can do to keep from being asked after opening every file? I found the "Remove Hidden Data" on this machine and removed it via Add/Remove Programs, then restarted the computer. However, I'm still receiving the same prompts. Thanks for any help you can provide. Hi kjbrr I suspect a worksheet has a volatile function in it, for example =TODAY(), which re-calculates when the workbook is opened, so, having changed itself, it will always request a save confirmation. Regards Steve |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
always prompted to save opened workbooks
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. Gord Dibben MS Excel MVP On Mon, 31 Jul 2006 08:13:01 -0700, kjbrr wrote: Any time I open a workbook, even if just to print it from windows explorer, I'm prompted to save (Do you want to save the changes you made to "filename.xls") However, no changes are made...Is there something I can do to keep from being asked after opening every file? I found the "Remove Hidden Data" on this machine and removed it via Add/Remove Programs, then restarted the computer. However, I'm still receiving the same prompts. Thanks for any help you can provide. Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save As from chart sheet | Charts and Charting in Excel | |||
| I need an excel plug in to save workbooks in adobe acrobat format | Excel Discussion (Misc queries) | |||
| Can't save Excel using Save button, | Excel Discussion (Misc queries) | |||
| Why am I prompted to save a file when nothing has changed? | Excel Discussion (Misc queries) | |||
| cannot edit and save | Excel Discussion (Misc queries) | |||
Hybrid Mode
