as far as I know it is not possible at all. 65536 is the absolute limit for
Excel. So you probably will have to split it up into different worksheets. It
might be an idea to do a little preparation work in Access (e.g. some
groupings through queries) in order to reduce the number of lines.
Thore

"ken2005" wrote:


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