Excel 2010 copy and paste problem

[smiler44]

At work we have just upgraded from Excel 2007 to 2010.
I have a large work book with multible tabs. From the tab I want, I am hiding the columns I dont want, filtering the remaining columns to show only the rows I want.

I copy the remaining information, this is about 8 columns and 120 rows. not a lot of information.
I then paste this into a new work book and save it as an xls work book. From what I can see, there are only the columns and rows I want but, the file is some 25 meg in size. I cant work out whats going on but am using the same method in Excel 2010 as I did in Excel 2007.

any advice please?

thanks
smiler44

 

[smiler44]

have not tried it but the answer could be this:
http://office.microsoft.com/en-gb/excel-help/copy-visible-cells-only-HA010342322.aspx

seems to fit the problem


smiler44