Excel file size too large

[vestax22]

Hi, this may be a stupid question but here it goes anyway.

I have a fairly large Excel 2k application (10 mb) that is comprised of 13 worksheets. Three of these worksheets take up a lot of space 90% +. These three worksheets are filled with formulas. I want to know if it was possible to make my file smaller in some way. I want it to load up faster on startup and I want it to use less ressources. Are there any tips to improve the general performance of my application???

Thx in advance for the help

 

[xlbo]

take a look here:

http://www.decisionmodels.com/optspeedb.htm

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[Jooky68]

In many cases, you can significantly reduce the size of a workbook, especially a workbook with modules you have heavily edited, becasue Excel does not do a good job of cleaning up its symbol table. This will work to reduce the size of your file only if you have any macros, modules and forms. This is what you do

Open up your project window in the vba editor and export all the forms and modules, make sure you keep track of the modules and forms. Save it..than go back into the file and import all the modules and forms you deleted out of the workbook(or removed i should say)
..save the workbook again. Usually the new workbook is much smaller that it was.

But again this is only if you have used vba within your file which you havent specified.

Also if you are using vba and you want to speed up your macros turn screenupdating=false

application.screenupdating=false

make sure you turn it back to true once you want to actually update the screen. This works well when you ahve a lot of moving around that you dont need to show, and you want to speed up the macro. If you are going to set it to false make sure you set it back to true before you display any dialog box's, otherwise moveing the dialog box will leave a trail.

 

[DaleWatson123321]

One possibility...

If you currently have reports that are "resident" reports - i.e. they have fixed formulas for different reports - examples: By Month, By Quarter, By Year, By Employee, etc...

...Then you could potentially set up one common Report sheet, whereby the different data for each report is extracted via VBA code from your database. The code and/or formulas would also change the report headings to reflect the required different heading for each separate report.

If this scenario roughly describes your application and you'd like assistance, providing more specifics via email is an option. I'll then be in a much better position to provide further help - specific to your application.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[vestax22]

Hey guys thanks for the replys.

Heres the problem. I accumulate data inside a sort of Excel database on two worksheets. This database holds data for the current year so there are 360 colums and 1000 rows of formulas. This really takes up a lot of space. Is there a way to optimise the formulas so they dont take as much place? Thx


P.S. I know this is probablt impossible but any help would be greatly appreciated. Thx

 

[Bowers74]

What is/are the formulas that you are using, where are they located and what are they for?





Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[vestax22]

Well there is a section of the two worksheets (Line 8 to Line 245) that serve as inputs gathered from other worksheets inside the workbook. These cells contain no formulas. Lines 253 to Line 1108 contain formulas. Most of the formulas are simple. They perform calculations on the inputs above. As you can see there are lots of formulas. Just one of the two database worksheets takes arrounf 4 mb of space.

Hope this is clear and thx for the reply