Pasting high volume looses formatting?

L

Lee V

With Excel 2002, when attempt to copy a large spreadsheet, I get the following (generic error code) when trying to paste

"Data on the Clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?

Of course when I answer "OK" I loose the formatting (primarily row height).

I am trying to keep two worksheets within one workbook in sync...updating one then copying to the second and sorting/manipulating the second. Sheet is 25 cols by 250 rows with varying fonts, row heights, column sizes and colors

This happens when I try to paste into an existing spreadsheet or a new one, with and without using "special paste"

Any help would be appreciated!!!!!!!

Thanks!
(company policy requires me to post email as anonymous...sorry

Lee
 
Top