Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Size Jump
I have a person I work with who had an Excel sheet that has about 40 tabs
with roughly 200 rows in each tab. There are some cell that get information from other tabs using =tab name, cell. The file size was 3,278 KB. She made some changes to this file where she added about 800-900 rows to each tab and also added an IF statement in the cells in some columns in all of the tabs. The file size is now 30,673 KB. Could the file size increase that much by adding these rows and these IF statememts? Seems like a pretty big jump. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Size Jump
Usually a significant size jump for no apparent reason is caused by unused
cells that are not being cleaned up by XL. Check out the scroll bars on each sheet. Do they allow you to scroll well past the end of the data. If so then you need to clean up the unused cells by deleting all rows below and to the right of the last used cell. Once you have done that on all sheets you need to save the workbook. When this is done the size fo the workbook should be much more reasonable and the scroll basr shoul only take you to the end of the populated cells. -- HTH... Jim Thomlinson "Supe" wrote: I have a person I work with who had an Excel sheet that has about 40 tabs with roughly 200 rows in each tab. There are some cell that get information from other tabs using =tab name, cell. The file size was 3,278 KB. She made some changes to this file where she added about 800-900 rows to each tab and also added an IF statement in the cells in some columns in all of the tabs. The file size is now 30,673 KB. Could the file size increase that much by adding these rows and these IF statememts? Seems like a pretty big jump. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Size Jump
Did that, but only broght down to just under 30,000 KB.
"Jim Thomlinson" wrote: Usually a significant size jump for no apparent reason is caused by unused cells that are not being cleaned up by XL. Check out the scroll bars on each sheet. Do they allow you to scroll well past the end of the data. If so then you need to clean up the unused cells by deleting all rows below and to the right of the last used cell. Once you have done that on all sheets you need to save the workbook. When this is done the size fo the workbook should be much more reasonable and the scroll basr shoul only take you to the end of the populated cells. -- HTH... Jim Thomlinson "Supe" wrote: I have a person I work with who had an Excel sheet that has about 40 tabs with roughly 200 rows in each tab. There are some cell that get information from other tabs using =tab name, cell. The file size was 3,278 KB. She made some changes to this file where she added about 800-900 rows to each tab and also added an IF statement in the cells in some columns in all of the tabs. The file size is now 30,673 KB. Could the file size increase that much by adding these rows and these IF statememts? Seems like a pretty big jump. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my row numbers jump from 93 to 279. Why? | Setting up and Configuration of Excel | |||
Jump certain columns with tab | Excel Discussion (Misc queries) | |||
How to jump to end of text only? | Excel Discussion (Misc queries) | |||
I want to jump to different cells with tab | Excel Discussion (Misc queries) | |||
How to jump date? | Excel Discussion (Misc queries) |