why only few data but filesize is 13Mbytes ?

  • Thread starter Thread starter William Poh Ben
  • Start date Start date
W

William Poh Ben

Any help or advise here is very much appreciated.

My Excel spreadsheet has only 2 simple workbooks with report data (15
columns and 5552 rows raw data).
There is no pivot tables, no charts, no hidden worksheets, no cells
filled with colors, no background colors, no embedded images, no
hyperlinks, but the filesize is about 13MBytes.

Do you know what is the problem and how to resolve this ?
 
William,

On each of the sheets, try pressing Ctrl + End to see where
Excel thinks the last row and column are. If it's way off what
you think it should be, you'll need to delete the extra rows
and columns and then save, close and reopen the workbook.
For more on this, take a look here:

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

John
 
It could also be a borders problem on one or more worksheets. Many people
add borders by selecting the entire row/column and add the border. This
causes Excel to store the information for all those cells.

Select all of the rows/columns outside the used area and do an
Edit-->Clear-->All. Then delete those rows/columns and save the workbook.
Depending on your version of Excel, you may also have to close and re-opne
the workbook.

Two other possibilities:

1. You have hidden graphics. By hidden, I mean rows/columns were hidden
while a graphic image sat within that row/column. Try using
Edit-->GoTo-->Special-->Objects to see if anything gets selected. Even if
you see nothing, press Delete and save the workbook under a new name to see
if the size shrinks.

2. The workbook was developed using a prior version of Excel, then saved
under the newer version. Try copying and pasting the contents of each
worksheet into a new workbook by:

a. Using Paste-->Special-->Formulas
b. Then Paste-->Special-->Formatting

Save the workbook and note the size.
 
Have you considered that it might be a virus.

try running the anti-virus on these files and lets see what comes up.

hasen
 
Hasen said:
Have you considered that it might be a virus.

try running the anti-virus on these files and lets see what comes up.
Click to expand...

Sadly excessive file size is far more likely to arise from standard Excel
functionality misused than from viruses.
 
Back
Top