Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2005

Tip: Looking for answers? Try searching our database.

XLB file size growing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rob - 28 Dec 2005 19:26 GMT
Hi,

Using Excel 2000 on Win XP pro and the file excel.xlb is growing each time I
start and close Excel.  The size started at 27kb but is now over 2mb.  I'm
not making any changes when loading and have several add-ins which I think
is normal.

The same happens if I delete the excel.xlb file and let Excel create another
when closing down.

Any ideas?

Thanks, Rob
Dave Peterson - 28 Dec 2005 20:24 GMT
I think you'd have to know the inner workings of excel to know why it's
growing.  And even if you had that knowledge, I'm not sure if you could stop it
from happening.  (But I've never seen the .xlb file grow that big or that fast!)

I'd suggest that you delete the *.xlb file, then recreate it so that you like
it.

Then close excel and back up that new pristine *.xlb file.  When you notice that
the file is growing, just copy the backup to the correct location (overwriting
the one that's out of control).

In fact, you may want to set up a small bat file to do this.  Then put a
shortcut on the desktop.  Click it every so often (with excel closed).

===

Do you add/delete things from your toolbar--either manually or via code?  That
could be why it's growing.

> Hi,
>
[quoted text clipped - 9 lines]
>
> Thanks, Rob

Signature

Dave Peterson

Rob - 28 Dec 2005 21:30 GMT
Dave,

Thanks, like the bat file idea.  Usually I amend toolbar as and when
required manually but don't do it every time I load Excel.  Perhaps a bat
file could overwrite the excel.xla file and start Excel in one go?  I'll
look for some code.

Thanks, Rob

>I think you'd have to know the inner workings of excel to know why it's
> growing.  And even if you had that knowledge, I'm not sure if you could
[quoted text clipped - 38 lines]
>>
>> Thanks, Rob
Dave Peterson - 28 Dec 2005 22:12 GMT
excel.xla = excel.xlb????

This worked ok for me (saved as a .bat file):

REM ==============
copy "C:\myBackups\excel11.xlb" "C:\Documents and Settings\David
Peterson\Application Data\Microsoft\Excel\XLSTART"

start excel

REM =================

That Copy command was all one line (no line breaks).

> Dave,
>
[quoted text clipped - 51 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Rob - 29 Dec 2005 16:12 GMT
Thanks Dave, worked a treat.  Rob

> excel.xla = excel.xlb????
>
[quoted text clipped - 69 lines]
>> >
>> > Dave Peterson
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.