ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Error message-Dataset... (https://www.excelbanter.com/excel-discussion-misc-queries/100379-error-message-dataset.html)

RUSH2CROCHET

Error message-Dataset...
 
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

Gord Dibben

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




All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com