• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Template Size

Ashhu

Ashhu

Active Member
Hello All
I am currently dealing with one of the template which weighs whooping 11.5 MBs , When I checked the sheet, It has got 12 Tabs, 9 tabs has got raw data in A;N col and 256 rows, most contains formulas and with lot of colors and other variable properties
I understand these contributed to the file size.
My question is If not excel what will be alternative software/way to build this template so it can open and save in seconds.
Will MS Access help here?


-Ashwin Sowdi
 
If you cleared your formatting (ie lots of colors), you might be able to reduce the size of the file - similar to converting your data to Access.

However, there are several things you can to to reduce the size of the workbook and are worth the time/trouble to do. You will gain useful knowledge about better setups in the future.

You might want to evaluate each sheet in your workbook to find the LAST CELL (tap the END key then tap the HOME key to be taken to the last cell of each worksheet). If the LAST CELL is not the last cell of your data, you can delete the extra rows and columns to reduce the size of the file. Be sure to SAVE your file after each time you delete the blank (formatted) rows/columns before your file size will change.

Here is a page that discusses which formulas are considered VOLATILE. These formulas greatly increase the size of your workbook and slow it down:
www.decisionmodels.com/calcsecretsi.htm

Hope this helps!
 
Yes Marc, Indeed its lot of formatting...i instructed template creator to rework on above guidelines for size reduction.
 
Hi ,

One more option is to build the template , at least what ever can be built in this fashion , using VBA , when ever it is opened.

The resulting file size will be huge each time , but the template itself will be reduced in size.

Narayan
 
You must log in or register to reply here.
Back
Top