Extra Baggage in Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Brandt (Brandt_at_discussions.microsoft.com)
Date: 01/26/05 

Date: Wed, 26 Jan 2005 13:21:04 -0800

I had a problem with an excel file which had become very slow to save and
close which I posted previously on this site. See:

http://www.microsoft.com/office/community/en-us/default.mspx?&query=brandt&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.excel.misc&p=1&tid=a03f287f-43a5-4daf-bf3d-23df00dd4956&mid=a03f287f-43a5-4daf-bf3d-23df00dd4956

After reading some responses to my question and other posts in the group I
decided to recreate the workbook. I changed all the equal signs to "p=" so
all the formulas would be text, then I moved them to a new file and changed
the "p=" back to "=" so I had formulas again. I then copied all the macros
and any misc. formatting. This has done a lot to solve the problem (though
I'm not sure yet exactly how much) but also had the added benefit of reducing
the file size from about 2.4 megs to 1.7 megs (about 30% reduction). This is
the size the file was about 4 months ago. It had grown slowly so I thought
it was from changes I had made. The file is a cost estimating spreadsheet
which I use as a master file. I update this master file as needed and I also
save it out to different job names frequently, but I don't add large amounts
of new data that would cause file size increases.

My question is: Does anyone know what could cause such buildup in file size
and how to avoid it in the future?

Relevant Pages

  • Re: Importing "Actual Labor Hrs" into MS Project
    ... Thanks Jack for your suggestion. ... I am currently trying to manage all our jobs/projects in one master file ... Job/Task structure example: ... running the macro using the identified/specified Excel file containing the ...
    (microsoft.public.project)
  • Re: Windows XP & Office 2000
    ... > is in your temp internet files and the xls file is still located on the ... > offer you the chance to access the excel file. ...
    (microsoft.public.windowsxp.general)
  • Re: Windows XP & Office 2000
    ... > is in your temp internet files and the xls file is still located on the ... > offer you the chance to access the excel file. ...
    (microsoft.public.excel)
  • Special Snapshot View
    ... Then we have a master file to view them all ... What I am trying to do is create a way to see a quick snapshot of work loads ... Due Date (total hours for this engineer on this project) ... But this requires me to update that excel file ...
    (microsoft.public.project)
  • Re: Importing "Actual Labor Hrs" into MS Project
    ... I am currently trying to manage all our jobs/projects in one master file ... Job/Task structure example: ... We record our weekly actual labor hours in an Excel sheet using the ... running the macro using the identified/specified Excel file containing the ...
    (microsoft.public.project)