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

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