Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Slow Workbook
I have a workbook with 52 sheets. Each sheet has the same or similar
formula's. The formula are simple as I am a beginer. The file ended up at 50,200KB, way larger than it should be and takes 15 to 20 mins. to open. I broke it apart into 4 separate files and ended up with this (1-13 = 2,200KB; 13-26 =2,600KB; 26-39 = 10,500KB and 39-52 = 38,600KB) Everything being the same from sheet to sheet I can't explain this. Any Help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Slow Workbook
Chances are you have a used range issue... check out this link...
http://www.contextures.com/xlfaqApp.html#Unused -- HTH... Jim Thomlinson "Bearwolf" wrote: I have a workbook with 52 sheets. Each sheet has the same or similar formula's. The formula are simple as I am a beginer. The file ended up at 50,200KB, way larger than it should be and takes 15 to 20 mins. to open. I broke it apart into 4 separate files and ended up with this (1-13 = 2,200KB; 13-26 =2,600KB; 26-39 = 10,500KB and 39-52 = 38,600KB) Everything being the same from sheet to sheet I can't explain this. Any Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving a shared workbook is too slow on other 2 computers | Excel Worksheet Functions | |||
Excel Workbook slow to open | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
My workbook is slow. | Excel Worksheet Functions | |||
Slow opening Excel Workbook with over 50 Worksheets | Excel Discussion (Misc queries) |