Error Message

[elaine.schedler]

When closing a file I get this error message: can't find
analyst.xlaAnalystsheetclose!

This only happens on this file, how can I rectifiy this error.


Regards
Elaine

 

[Kevin B]

Click TOOLS on the menu, select ADD INS and check the ANALYSIS TOOLPAK and
click OK.

 

[elaine.schedler]

Thank Kevin unfortunately that does not work. When I close the excel sheet
the following message appears "Cannot find C:\Program Files\microsoft
Office\Office11\Library\analysis.xla!Analysisheetclose which has been
assigned to run each tim the document is opened."
This is an old document and has been around sometime, how can I break this
link?

 

[Gord Dibben]

Analysis.xla is not an Excel default add-in

i.e. it is not the Analysis Toolpak addin

Try Tools>Add-ins and look for something other than the ATP to disable.

Also right-click on the Excel Icon left of "File" on the menubar and select
"View Code".

Anything there that points to analysis.xla that should be deleted?

Or in VBE on the menubar try "Add-ins" and see what the add-in manager has
listed.


Gord Dibben MS Excel MVP

 

[elaine.schedler]

Hello Gordon

Thank you very much for your help. Unfortunately your suggestions did not
solve the problem but I discovered that it was a name range "AutoClose" which
was causing this error. I am none the wiser why but at least it is not
happening any more.

 

[Gord Dibben]

Thanks for the update Elaine.

The "AutoClose" named range was in Insert>Name>Define?


Gord