View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Alerts - how to cancel

There are certain functions =now(), =today(), =indirect() (and others) that are
volatile. The update whether you make a change or not.

There could be worksheet/workbook/application events that could be firing that
change the workbook.

This is one of those warnings I'd try not to ignore.

TT wrote:

Everytime I open an excel file, flip through the different worksheets, didn't
make any change, and then exit, it always ask if I want to save changes.

Is there a way to cancel the alert? I want it so that if I close the file
without saving, that means I don't want to save anything I've done. I don't
need the alert. How do I take it out? Please help


--

Dave Peterson