View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RichardSchollar RichardSchollar is offline
external usenet poster
 
Posts: 196
Default File size increase

Excel then interprets that your file size has just increased from 230
lines to 65,536 (ie the max number of rows) as you have 'done'
something to the remaining rows (ie hidden them). It therefore needs
to record these rows which thus uses storage increasing the file size
(it doesn't record them if they are empty).

Hope this helps!

Richard


Don4908 wrote:
I have an excel file that is 153kb in size. When I place my cursor one row
below the last row of data (230) and use the Ctrl+Shift+DownArrow and select
Hide Row to hide all the rows higher than 230 the size of the file increases
to 1.55mb. What causes this to happen
--
Don