LARGE File Size
 

Hi,

I have been given a file that 7.7 meg.

The content is approximately 30 cells x 30 cells. There is some border
formatting but the majority of the cells are empty as it is a timesheet
template.

There is three lines and a small picture in the file.

If I copy all cells over to a new work by pasting values and then pasting
formats & copying over the lines and image, the new file is 66.5K !!!

Any ideas why the same content can have such varying file sizes ???

Thanks
John

LARGE File Size
 

Hi John

Excel can think that the usedrange is bigger then it is.

You can see how big your usedrange is on every sheet with CTRL-END
If the row/column is not the last row/column with data then:

1 Select the first row below your last row with data
2 CTRL-SHIFT-DOWN ARROW
3 Right click on the selection and choose delete

And then for the columns

1 Select the first column next to your last column with data
2 CTRL-SHIFT-RIGHT ARROW
3 Right click on the selection and choose delete

Save the file an close it
See how big the file is now?

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"John" wrote in message ...
Hi,

I have been given a file that 7.7 meg.

The content is approximately 30 cells x 30 cells. There is some border
formatting but the majority of the cells are empty as it is a timesheet
template.

There is three lines and a small picture in the file.

If I copy all cells over to a new work by pasting values and then pasting
formats & copying over the lines and image, the new file is 66.5K !!!

Any ideas why the same content can have such varying file sizes ???

Thanks
John

LARGE File Size
 

Sounds like the picture may be adding some bulk as well

since you say you didn't copy the picture.

--
Regards,
Tom Ogilvy

John wrote in message
...
Hi,

I have been given a file that 7.7 meg.

The content is approximately 30 cells x 30 cells. There is some border
formatting but the majority of the cells are empty as it is a timesheet
template.

There is three lines and a small picture in the file.

If I copy all cells over to a new work by pasting values and then pasting
formats & copying over the lines and image, the new file is 66.5K !!!

Any ideas why the same content can have such varying file sizes ???

Thanks
John