G
Guest
Hi there
I'm using Microsoft excel 2007, in window Vista. I got this problem to
paste rows when it is more than 65,000 row.
Eg. Worksheet A already have 40,000 rows. I want to copy data from worksheet
B with total 29,000 rows tp wprksheet A. The no of column i have is 15
columns in A worksheet.
It dont allow me to paste the data in worksheet B to worksheet A, 40,000
row+29.000 rows=69,000 rows. Error message appeared.
"The info cannot be pasted because the copy area and the paste area are not
the same size and shape. Try one of the following:
1) Click a single cell, then paste
2)Select a rectangle that the same size and shape, Then paste."
I also checked that when i pasted 20,000 rows, I could paste it in Worksheet
A.
Is there a limitation in no. of rows ?
My file currently is saved under Excel 97-2003 workbook. xls. type.
I tried save the file in "Excel Workbook(*.xlsx), it doesn't help either.
Kindly asist me for above problem.
Office email:
Thank you
Channe Lim
Singapore
I'm using Microsoft excel 2007, in window Vista. I got this problem to
paste rows when it is more than 65,000 row.
Eg. Worksheet A already have 40,000 rows. I want to copy data from worksheet
B with total 29,000 rows tp wprksheet A. The no of column i have is 15
columns in A worksheet.
It dont allow me to paste the data in worksheet B to worksheet A, 40,000
row+29.000 rows=69,000 rows. Error message appeared.
"The info cannot be pasted because the copy area and the paste area are not
the same size and shape. Try one of the following:
1) Click a single cell, then paste
2)Select a rectangle that the same size and shape, Then paste."
I also checked that when i pasted 20,000 rows, I could paste it in Worksheet
A.
Is there a limitation in no. of rows ?
My file currently is saved under Excel 97-2003 workbook. xls. type.
I tried save the file in "Excel Workbook(*.xlsx), it doesn't help either.
Kindly asist me for above problem.
Office email:
Thank you
Channe Lim
Singapore