An untested thought: try using Paste Special | Values , if this is
appropriate to your needs
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"gls858" wrote in message
...

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