Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable call for Addin
Hello,
Problem: I have an Excel sheet (3Mb), data in the sheet only justifies very little space. I'd say it should be 250 Kb. The message on opening or closing the sheet is 'Cannot find ....xla!... which should start on opening/ closing'. Where can I find this link and how can I break it? Any suggestions? Marc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable call for Addin
Check to see if the names "Auto_Open" and "Auto_Close" are defined
(Ctrl-F3). They may be pointing to the add-in. Delete them to eliminate the problem. For the size problem you might check each worksheet to see if its active area is larger than the data. Press Ctrl-End to go to the last active cell. If this is well beyond data try selecting and then deleting the unused rows and columns. Then save. -- Jim Rech Excel MVP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable call for Addin
JIM,
That's it. Thanks! There were a lot of names defined linked to the intranet, removing them shrinked the file from 3714 Kb to a tiny 36 Kb. Thanks, Marc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS VB addin err | Excel Worksheet Functions | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming | |||
Addin | Excel Programming | |||
COM addin call missing | Excel Programming |