Save Function and Macro Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Some of my worksheets will ask me if I want to save upon exit even when I make no changes, and some don't. I believe it has something to do with a prior link that has been deleted.

Also, a similar situation, upon opening a worksheet, the "macro warning" window comes up even though I have no macro. I started to write a macro and then deleted it. I still get the warning.

These are just annoying.
 
Some functions in excel are "volatile", they will re-calculate every time
excel is opened, this will make the worksheet change even if you don't make
any changes. Here are some of the functions that will cause this to happen,
there are probable many more, but they don't come to mind right now
NOW
TODAY
RAND
INDEX
INDIRECT
OFFSET


You also have to remove the modules on which the macros were stored have a
look here for details http://www.contextures.com/xlfaqMac.html#NoMacros

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

Excel Semi-Pro said:
Some of my worksheets will ask me if I want to save upon exit even when I
Click to expand...
make no changes, and some don't. I believe it has something to do with a
prior link that has been deleted.
Also, a similar situation, upon opening a worksheet, the "macro warning"
Click to expand...
window comes up even though I have no macro. I started to write a macro and
then deleted it. I still get the warning.
 
1. There are some functions that are volatile and if they are present you
will
be prompted to save regardless if you did anything

AREAS,CELL,COLUMNS,INDEX,INDIRECT,NOW,OFFSET,RAND,ROWS,TODAY



2. You have to delete the module the macro was in, open the workbook, press
alt + F11,
in the left hand side project pane look for your workbook, you will probably
see something
like Module1 looking like a regular windows folder. Right click it, select
remove module1 (or
whatever name it has), select no when prompted to export.

--

Regards,

Peo Sjoblom


Excel Semi-Pro said:
Some of my worksheets will ask me if I want to save upon exit even when I
Click to expand...
make no changes, and some don't. I believe it has something to do with a
prior link that has been deleted.
Also, a similar situation, upon opening a worksheet, the "macro warning"
Click to expand...
window comes up even though I have no macro. I started to write a macro and
then deleted it. I still get the warning.
 
Back
Top