.XLB file corrupted often

[Andrew Murray]

The excel.xlb file is getting currupted every week or
so. Once replaced w. a good version things work fine for
a while. Any suggestions on premenent fixes or what is
possibly corrupting it. Thanks for any suggestions

 

[Charles Williams]

Hi Andrew,

One possibility is some rogue VBA code which is customising menus/toolbars
and not undoing its work properly. If this is the case then yoour XLB file
can get larger and larger until it falls over.

If you are running any VBA code or using addins check that they have a
workbook_close routine that removes any changes to menus/toolbars they have
made.


hth
Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com