TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
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: http://www.decisionmodels.com/memlimitsc.htm
>>> 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
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&Noble.com
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
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 http://www.raycomm.com/techwhirl/ for more resources and info.