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?
;-)
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] [ponder] [ponder]](/data/assets/smilies/ponder.gif)
How do I get the best answers?
![[ponder] [ponder] [ponder]](/data/assets/smilies/ponder.gif)
How do I get the best answers?