.XLB file corrupted often

  • Thread starter Thread starter Andrew Murray
  • Start date Start date
A

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
 
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
 
Back
Top