| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reducing the size.
I am using a file contains about 10 sheets, each sheet contain 5,000 cell,
each cell contain a function or a formula. Whenever I open the file it takes long time, also when I close it. Is there any way I can use to reduce this time, like removing column and rows that I do not need, or anything else?? -- MFS22 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reducing the size.
As a guess you file ahs been bloated with unused cells. Follow the directions
here to clean the file up... http://www.contextures.com/gluten.html -- HTH... Jim Thomlinson "MFS" wrote: I am using a file contains about 10 sheets, each sheet contain 5,000 cell, each cell contain a function or a formula. Whenever I open the file it takes long time, also when I close it. Is there any way I can use to reduce this time, like removing column and rows that I do not need, or anything else?? -- MFS22 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reducing the size.
Sorry wrong link... However if you are Gluten intollerant it is handy...
Try this one... http://www.contextures.com/xlfaqApp.html#Unused -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: As a guess you file ahs been bloated with unused cells. Follow the directions here to clean the file up... http://www.contextures.com/gluten.html -- HTH... Jim Thomlinson "MFS" wrote: I am using a file contains about 10 sheets, each sheet contain 5,000 cell, each cell contain a function or a formula. Whenever I open the file it takes long time, also when I close it. Is there any way I can use to reduce this time, like removing column and rows that I do not need, or anything else?? -- MFS22 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reducing the size.
Or
http://contextures.com/xlfaqApp.html#Unused (Unless glutens do cause bloating <vbg.) Jim Thomlinson wrote: As a guess you file ahs been bloated with unused cells. Follow the directions here to clean the file up... http://www.contextures.com/gluten.html -- HTH... Jim Thomlinson "MFS" wrote: I am using a file contains about 10 sheets, each sheet contain 5,000 cell, each cell contain a function or a formula. Whenever I open the file it takes long time, also when I close it. Is there any way I can use to reduce this time, like removing column and rows that I do not need, or anything else?? -- MFS22 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reducing the size.
Oops. I should have scrolled down a bit. I didn't see your correction post.
Jim Thomlinson wrote: Sorry wrong link... However if you are Gluten intollerant it is handy... Try this one... http://www.contextures.com/xlfaqApp.html#Unused -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: As a guess you file ahs been bloated with unused cells. Follow the directions here to clean the file up... http://www.contextures.com/gluten.html -- HTH... Jim Thomlinson "MFS" wrote: I am using a file contains about 10 sheets, each sheet contain 5,000 cell, each cell contain a function or a formula. Whenever I open the file it takes long time, also when I close it. Is there any way I can use to reduce this time, like removing column and rows that I do not need, or anything else?? -- MFS22 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reducing the size.
Thanks Jim! You never know how that gluten information might help,
although I haven't tested it with Excel files. <g Jim Thomlinson wrote: Sorry wrong link... However if you are Gluten intollerant it is handy... Try this one... http://www.contextures.com/xlfaqApp.html#Unused -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calendar keeps reducing size | Excel Discussion (Misc queries) | |||
| reducing file size | Excel Discussion (Misc queries) | |||
| REDUCING COLUMN SIZE | Excel Discussion (Misc queries) | |||
| Reducing file size | Excel Discussion (Misc queries) | |||
| Reducing the size of a woorsheet | New Users to Excel | |||
Linear Mode
