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