| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to increase the maximum rows in the worksheet?
Hi, I am using Excel97 and I try to create a pivot table getting external data form Ms Access. In Access, my database has over 120,000 records equivalent to 120,000 rows in Excel. I noticed that Excel has only 65536 rows in each worksheet. How can I increase this maximum rows so that could I paste the 120,000 records onto the worksheet? Thanks :) -- ken2005 ------------------------------------------------------------------------ ken2005's Profile: http://www.excelforum.com/member.php...o&userid=24734 View this thread: http://www.excelforum.com/showthread...hreadid=383042 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maximum number of rows that can be coppied to clipboard | New Users to Excel | |||
| Increase rows in worksheet beyond 65,536 row limit | Excel Discussion (Misc queries) | |||
| How do I unhide rows 1 through 28 on an Excel worksheet? | Excel Worksheet Functions | |||
| Increase default size of worksheet | New Users to Excel | |||
| Maximum no of rows in Excel | Excel Worksheet Functions | |||
Threaded Mode
