I have a project that requires 500+ fields (i.e. columns)
per record. Any suggestion on working around the 255
limit of Excel??

Use the right tool for the job? Access would probably be much better.

Secondly, I question that you *really* need 500 fields. You have design issues.

"Bryan" wrote:

I have a project that requires 500+ fields (i.e. columns)
per record. Any suggestion on working around the 255
limit of Excel??

You are stuck with the 256 columns per sheet.

Split the data over multiple sheets or use a different product like Quattro
Pro which will allow many more columns.

Gord Dibben Excel MVP

On Wed, 16 Jun 2004 16:58:40 -0700, "Bryan" wrote:

I have a project that requires 500+ fields (i.e. columns)
per record. Any suggestion on working around the 255
limit of Excel??

Use the right tool for the job? Access would probably be much
better.

I think Access is limited to 256 columns per table.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"medialint" wrote in
message
...
Use the right tool for the job? Access would probably be much
better.

Secondly, I question that you *really* need 500 fields. You
have design issues.

"Bryan" wrote:

I have a project that requires 500+ fields (i.e. columns)
per record. Any suggestion on working around the 255
limit of Excel??