I have a very large ( 400 MB) excel 2003 file broken into 18 tabs. I have
converted it to Excel 2007 (.xlsx). Each tab goes to column DD ( so about
108 columns) and they range from 20,000 - 60,000 rows. I am trying to
condense all the information on 1 worksheet in a 2007 format. The problem is
that whenever I try to copy the data, I get the error that the destination
size doesn't match the source size. I select the first cell (upper left hand
corner ) of where the cells should go, change over to the next tab, select
all the data, copy, switch back to the first tab, and try to paste in the
highlighted cell. This generates an error. How do I do this?

Instead of selecting all data,

1.Click the "Home" tab in Excel.
2.Click on the "Find and Select" button (Binoculars)
3.Select the "Go to Command"
4.In the bottom type A1:DD20000 (or the range you want to copy)
5. Press Ctrl C (Copy)
6. Select the destination cell
7. Press Ctrl V (Paste)
8. Note: excel will update formulas to reflect the new fields so be careful
if you have
formulas that are linked to other sheets.

Good Luck

"Jeff Lowenstein" wrote:

I have a very large ( 400 MB) excel 2003 file broken into 18 tabs. I have
converted it to Excel 2007 (.xlsx). Each tab goes to column DD ( so about
108 columns) and they range from 20,000 - 60,000 rows. I am trying to
condense all the information on 1 worksheet in a 2007 format. The problem is
that whenever I try to copy the data, I get the error that the destination
size doesn't match the source size. I select the first cell (upper left hand
corner ) of where the cells should go, change over to the next tab, select
all the data, copy, switch back to the first tab, and try to paste in the
highlighted cell. This generates an error. How do I do this?