Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Prompted to save
Hi All, I have a sheet that promts me to save even if I have not made changes. Any way to disable the waring? Is this some setting that I cannot track down? Thanks, Hetherjw -- hetherjw ------------------------------------------------------------------------ hetherjw's Profile: http://www.excelforum.com/member.php...o&userid=28195 View this thread: http://www.excelforum.com/showthread...hreadid=477283 |
#2
|
|||
|
|||
Prompted to save
Do you have =TODAY() or =NOW() in the sheet?
If so the sheet will consider itself changed when you open and trigger the message, Regards, Alan. "hetherjw" wrote in message ... Hi All, I have a sheet that promts me to save even if I have not made changes. Any way to disable the waring? Is this some setting that I cannot track down? Thanks, Hetherjw -- hetherjw ------------------------------------------------------------------------ hetherjw's Profile: http://www.excelforum.com/member.php...o&userid=28195 View this thread: http://www.excelforum.com/showthread...hreadid=477283 |
#3
|
|||
|
|||
Prompted to save
Alan, I think that is the cause of my proble I just can't find the cell that has the formula. I am trying to use the Go To command to track it down. Thanks for your help, hetherjw -- hetherjw ------------------------------------------------------------------------ hetherjw's Profile: http://www.excelforum.com/member.php...o&userid=28195 View this thread: http://www.excelforum.com/showthread...hreadid=477283 |
#4
|
|||
|
|||
Prompted to save
Try clicking 'Tools' 'Options' , on the 'View' tab check 'Formulas' OK
This will display all the formulas as they are written in the cells as opposed to the results of them and should make it easier to find what you're looking for, Regards, Alan. "hetherjw" wrote in message ... Alan, I think that is the cause of my proble I just can't find the cell that has the formula. I am trying to use the Go To command to track it down. Thanks for your help, hetherjw -- hetherjw ------------------------------------------------------------------------ hetherjw's Profile: http://www.excelforum.com/member.php...o&userid=28195 View this thread: http://www.excelforum.com/showthread...hreadid=477283 |
#5
|
|||
|
|||
Prompted to save
Alan, Found it! There was a =NOW() tucked in there. Thanks! -- hetherjw ------------------------------------------------------------------------ hetherjw's Profile: http://www.excelforum.com/member.php...o&userid=28195 View this thread: http://www.excelforum.com/showthread...hreadid=477283 |
#6
|
|||
|
|||
Prompted to save
Thats Good!
Regards, Alan. "hetherjw" wrote in message ... Alan, Found it! There was a =NOW() tucked in there. Thanks! -- hetherjw ------------------------------------------------------------------------ hetherjw's Profile: http://www.excelforum.com/member.php...o&userid=28195 View this thread: http://www.excelforum.com/showthread...hreadid=477283 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
Save as Msg box | 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) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |