Home |
Search |
Today's Posts |
#1
|
|||
|
|||
File Size - Calculation
I have a workbook on manual calc so I can finish some minor changes to
a model that was at 100MB but I was able to bring down to 60MB. With the few changes I made it should be around 40MB but it isn't saving. I've shut down the computer a few times and tried saving it with only a couple minor changes but everything I try gets 'non-responsive' for at least 20+ minutes. This model only has 2 sheets and the data tab has 28,000 rows with 78 columns. The summary tab is made up of 'SUMIF' statements and has 3 small tables. Has anyone run across a way to overcome this situation? |
#2
|
|||
|
|||
You might try to force an absolute recalculation of the spreadsheet by
simultaneously pressing CTRL-ALT-F9. In the latest version of Excel you can rebuild the entire recalculation tree press CTRL-ALT-SHIFT-F9. This should be necessary only once (if you save the rebuilt sheet). That might get you past the non-responsive issue. Good luck with it! |
#4
|
|||
|
|||
I take it your SUMIF is on each of your 28K rows, what does it look like.
When you save your workbook, it is recalculated. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm wrote in message oups.com... I have a workbook on manual calc so I can finish some minor changes to a model that was at 100MB but I was able to bring down to 60MB. With the few changes I made it should be around 40MB but it isn't saving. I've shut down the computer a few times and tried saving it with only a couple minor changes but everything I try gets 'non-responsive' for at least 20+ minutes. This model only has 2 sheets and the data tab has 28,000 rows with 78 columns. The summary tab is made up of 'SUMIF' statements and has 3 small tables. Has anyone run across a way to overcome this situation? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Any tips for reducing Exce file size with charts | Excel Discussion (Misc queries) | |||
File size too big after converting Lotus 1-2-3 to Excel | Excel Discussion (Misc queries) | |||
Empty Workseek: File still too large (>300k) | Excel Discussion (Misc queries) | |||
Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
excel file size bloat | Excel Discussion (Misc queries) |