Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add In Error?

Status
Not open for further replies.

Loomah

Technical User
Mar 4, 2002
1,911
IE
Hi All
A Strange occurance...

I'm getting an error message as follows
"Cannot Open MS Excel 97 Add-In for editing. Please edit the source doc instead"

The background:- I have a file which requires that the Analysis Toolpak is installed but I have (stangely) come up against some resistance to this. To get around the resistance I install the addin (where it isn't already installed) when the file is opened.

The addin is then removed/installed when the workbook is activated/deactivated then removed (if appropriate) when the file is closed.

The error ONLY occurs when the file is activated by changing windows using the CTRL+SHIFT+TAB combination. All other methods of activating/deactivating the file pass without a problem. The add-in still installs ok.

Has anybody come accross this before?

;-)
If a man says something and there are no women there to hear him, is he still wrong? [ponder]
How do I get the best answers?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top