ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2002 (https://www.excelbanter.com/excel-discussion-misc-queries/238107-excel-2002-a.html)

CFCALDWELL

Excel 2002
 
Why should a spread sheet expand (explode) to 7MB or 14MB when it should be
no greater than 350KB?

Jim Thomlinson

Excel 2002
 
Your used range got messed up. If you look at some of your sheets the scroll
bars will allow you to scroll well past the end of the data. All of the cells
you can scroll to are being stored as if they had stuff in them. To fix that
check out this site...

http://www.contextures.com/xlfaqApp.html#Unused
--
HTH...

Jim Thomlinson


"CFCALDWELL" wrote:

Why should a spread sheet expand (explode) to 7MB or 14MB when it should be
no greater than 350KB?



All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com