Excel 2007 I had three very large sheet 70,000 plus rows. I arranged and
subtotaled these as needed and then copied only the subtotals by using
Find and Select Go To special visible cells only then copy and
pasted this info to a new sheet. When I save these in the 97-2003 format
i got a message that said it was too many lines and would be truncated.
Since I only had about 15 rows of data on each sheet. Now when I do
control end the cursor goes to N65536. I know there is no data past
row 30. The file says it's over 6 megs in size and it should only be a
few hundred K at most. How can I trim this thing down so that I can
email it?

gls858