Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Exceed Row Limit | Excel Worksheet Functions | |||
Exceed Row Limit | Excel Worksheet Functions | |||
Matching a value, which does not exceed Min or Max. | Excel Worksheet Functions | |||
Excel columns do they exceed IV? | Excel Worksheet Functions | |||
Exceed Scale | Charts and Charting in Excel |