View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Umlas
 
Posts: n/a
Default Turn Off save prompt, reminder when closing modified WORD...

imagine you have a cell with the formula =NOW()

just opening the file DOES change the worksheet, hence the prompt.

"S. Nyman" <S. wrote in message
...
Some EXCEL files display a prompt when closing the file that asks if you

want
to save changes even when the file was merely opened and viewed, no cells

or
formatting changes were made.

This creates an extra step, "no" must be clicked before the file can be
closed.

If the setting that causes the reminder or dialog box to open could be
switched off, in both WORD and Excel it would eliminate this annoyance.