View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Error message-Dataset...

Excel 2003 has only 65536 rows available.

If possible, break your incoming data into manageable chunks of less than 65536
then spread out over multiple worksheets.

OR..........Use a macro to break up the incoming data.

http://support.microsoft.com/default...;en-us;Q120596


Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 10:03:02 -0700, RUSH2CROCHET
wrote:

Running Excel 2003

Received the following message when downloading a report from our mainframe...

Dataset has exceeded the maximum of 70,000.00 unable to continue formatting...

Any ideas as to what has caused this, or what I can do to correct?

TIA,
Sandi