Re: Excel 2000 file size.

Subject: Re: Excel 2000 file size.
From: "Rick Bishop" <BishopR -at- jcdc -dot- jobcorps -dot- org>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Mon, 05 May 2003 17:27:23 -0500

Hi John: I believe you are at around one-third the max for Excel 2000. No way its going to handle 500k rows. In the early days of Excel, we would bump into this problem regularly.
There is a lot of info about Excel limits here:

>>> John Posada <JPosada -at- book -dot- com> 05/05/03 04:58PM >>>

Hi, guys...we're always talking about Word limitation.
I have an Excel spreadsheet being used for a configuration matrix. Right
now, it is 6.5mb in size X 23,000 rows X 11 rows. Nothing fancy, just lines
of text.
Anyone know if there is a practical size limit for Excel? I know I could
convert to Access, or even directly to an SQL table, but I want to stay in
Excel as long as possible because it fits with the model of my other tables.
BTW...with the amount of data I still have to import, that 23,000 rows could
go 20X in size before I'm done. This is for column characteristics for all
our SQL database tables on all our servers.
So, is a half million rows too cumbersome with Excel?
John PosadaSenior Technical WriterBarnes&
jposada -at- book -dot- com
NY: 212-414-6656Dayton: 732-438-3372
"There are those who look at things the way they are, and ask why... I dream
of things that never were, and ask why not?"
-----Robert Francis Kennedy, 1968 presidential campaign


Order RoboHelp X3 in May and receive a $100 mail-in rebate, PLUS
free RoboScreenCapture and WebHelp Merge Module.

Order RoboHelp today:

ATTENTION FrameMaker Users: Fill-out the following survey
to receive a chance to win a FREE RoboScreenCapture.

FM users only please:

You are currently subscribed to techwr-l as:
archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit for more resources and info.

Previous by Author: Re: Correct terminology?
Next by Author: Re: Tutorial With Video Capture
Previous by Thread: Re: Excel 2000 file size.
Next by Thread: RE: Excel 2000 file size.

What this post helpful? Share it with friends and colleagues:

Sponsored Ads