Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Bloat
We have a workbook containing 30 worksheets each with 15 columns and 60 rows
of data. I am not sure where it was originally created but its size is approximately 5 mg. Recently, working on similarly formatted workbook, users reported it was extremely slow to load. The workbook size is about 25 mg. I don't know which version was used or is used at the moment but I think they are still using Excel 2000. We tried eliminating borders, shading, and WordArt, to no avail. It is still about 5 times the size of the original. Any idea what can be causing the bloating? TIA Guy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Bloat
Excel automatically expands when it needs more space and doesn't contract in
size. making additional changes like you tried will never returns the workbook to its original size. Usually I can get the workbooks to shrink by copying the worksheets to a new workbook. Try slecting all the worksheets. Select first worksheet tab. Then goes to last worksheet and while holding the shift key press the last worksheet. All the worksheets should be highlighted. Then right click one of the tabs and select Move or Copy. On the dialog box select Copy and in the pulldown select New Workbook. Then save new workbook to a new filename. Close workbook and check size of new workbook. The copy dialog se "Guy Lydig" wrote: We have a workbook containing 30 worksheets each with 15 columns and 60 rows of data. I am not sure where it was originally created but its size is approximately 5 mg. Recently, working on similarly formatted workbook, users reported it was extremely slow to load. The workbook size is about 25 mg. I don't know which version was used or is used at the moment but I think they are still using Excel 2000. We tried eliminating borders, shading, and WordArt, to no avail. It is still about 5 times the size of the original. Any idea what can be causing the bloating? TIA Guy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Bloat | Excel Discussion (Misc queries) | |||
How do you remove file bloat in Excel? | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
excel file size bloat | Excel Discussion (Misc queries) | |||
i received a file that reads powerpoint document file file exten. | Excel Discussion (Misc queries) |