Disable call for Addin

[Marc]

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

 

[Jim Rech]

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.

 

[Guest]

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