LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Can exceed 65,000rows in Excel?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exceed Row Limit Freshman Excel Worksheet Functions 6 August 9th 07 05:10 PM
Exceed Row Limit Freshman Excel Worksheet Functions 0 August 9th 07 05:22 AM
Matching a value, which does not exceed Min or Max. Assad Excel Worksheet Functions 3 July 15th 07 05:08 PM
Excel columns do they exceed IV? James Dalton Excel Worksheet Functions 6 June 10th 07 10:12 PM
Exceed Scale MarkN Charts and Charting in Excel 5 November 12th 06 09:29 PM


All times are GMT +1. The time now is 03:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"