Workbook Size Increases dramatically
in [General]
|
From: Barb Reinhardt on 1 Dec 2009 13:42 I have a workbook that starts out at 701.6 KB. After changing about 20 cells and adding some comments, it increases to 84Meg. Does anyone have any idea what might be causing this? Thanks, Barb Reinhardt
From: Jim Thomlinson on 1 Dec 2009 15:13 Generally speaking the issue normally revolves around cells being initialized without actually having anything in them. Take a look at the scroll bars on each sheet. If you can drag them well past the end of the data then all of those blank cells you see are actually taking up memory... Check out this link to clear them by reseting the used range. http://www.contextures.com/xlfaqApp.html#Unused -- HTH... Jim Thomlinson "Barb Reinhardt" wrote: > I have a workbook that starts out at 701.6 KB. After changing about 20 cells > and adding some comments, it increases to 84Meg. Does anyone have any idea > what might be causing this? > > Thanks, > > Barb Reinhardt >
From: Barb Reinhardt on 1 Dec 2009 16:45 Thanks Jim. That was the problem. I'm surprised I've never seen it happen before. Barb "Jim Thomlinson" wrote: > Generally speaking the issue normally revolves around cells being initialized > without actually having anything in them. Take a look at the scroll bars on > each sheet. If you can drag them well past the end of the data then all of > those blank cells you see are actually taking up memory... Check out this > link to clear them by reseting the used range. > > http://www.contextures.com/xlfaqApp.html#Unused > > > -- > HTH... > > Jim Thomlinson > > > "Barb Reinhardt" wrote: > > > I have a workbook that starts out at 701.6 KB. After changing about 20 cells > > and adding some comments, it increases to 84Meg. Does anyone have any idea > > what might be causing this? > > > > Thanks, > > > > Barb Reinhardt > >
|
Pages: 1 Prev: pivottable formula Next: Problem with 'AutoCorrect File' in Excel |