Why is Excel File so large?

1st hit ctrl end and find out where the sheet ends

there are probably formatting problems, maybe the entire sheet is formatted instead of the used range

highlight all the rows that are not being used and go to edit then clear all

then save
do the same for the columns

Originally Posted by Foogar

Hi,
Thankyou for replying. I have followed your instructions but it hasn't changed the size at all?

Any more ideas?

Did you save the file after you cleareded all??
has the scroll bar changed in size??

Originally Posted by Foogar

Hi there,
Yes defintely saved and exited and checked size in windows explorer, no change on scroll bars either!

I would suggest to open a new work book and copy then paste the used ranges in the original workbook to the new workbook and see what happens from there.