Cannot find source of external workbook links
 

When opening a workbook that we save under a new name each month we always
get a message " Cannot find _______________ which has been assigned to run
each time (the current workbook) is opened. Cancel Opening_________?"

I have searched for links under edit and used the find function to search
for cells containing the character [ to find formulas etc per the microsoft
help information but am still getting the error.
How else can i find out where this is in the workbook and remove it?

Cannot find source of external workbook links
 

I'd look for a subroutine in a General module that's named Auto_Open.

Then I'd look under the ThisWorkbook module for a subroutine that's named:
Workbook_Open.

You could have a macro in either of these locations that try to run something
helpful.

Nette wrote:

When opening a workbook that we save under a new name each month we always
get a message " Cannot find _______________ which has been assigned to run
each time (the current workbook) is opened. Cancel Opening_________?"

I have searched for links under edit and used the find function to search
for cells containing the character [ to find formulas etc per the microsoft
help information but am still getting the error.
How else can i find out where this is in the workbook and remove it?

--

Dave Peterson