Need to expand past column IV

[Vinecom]

Hi,
Were using Excel 2003 and ran into the end of colums at IV. Besides
upgrading to Office 2007 is there way to extend or add-in more columns.


Thanks,
BobV

 

[Bernie Deitrick]

Bob,

No, but using all 256 columns is often a sign that you should use database data style entry -
instead of having a column for each of the ?days(?) enter the column property as a field, with each
entry in a separate row. Beyond that, it is hard to be more specific since your question is vague.

HTH,
Bernie
MS Excel MVP

 

[Vinecom]

Bernie,
I have a 2003 spreadsheet. My first column is A1....My last available column
is IV1.
Is there a way to add more columns in 2003?

BobV

 

[Tyro]

No. Versions of Excel prior to Excel 2007 have a limitation of 256 columns.
There is no way to expand that.

Tyro

 

[Gord Dibben]

What part of Bernie's "No" did you miss?


Gord Dibben MS Excel MVP

 

[Niek Otten]

<There is no way to expand that.>

Not in the same sheet, that is.
You can of course use a second sheet. But it will be difficult to keep the rows together correctly.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| No. Versions of Excel prior to Excel 2007 have a limitation of 256 columns.
| There is no way to expand that.
|
| Tyro
|
| | > Bernie,
| > I have a 2003 spreadsheet. My first column is A1....My last available
| > column
| > is IV1.
| > Is there a way to add more columns in 2003?
| >
| > BobV
| >>
|
|

 

[Tyro]

I wouldn't even contemplate that.

Tyro

 

[Bill Sharpe]

Bernie,
I have a 2003 spreadsheet. My first column is A1....My last available column
is IV1.
Is there a way to add more columns in 2003?

BobV

Those are full cell addresses. Your first column is A. Your last column
is IV. The 1 is the row number.

The answer is No. Change to Quattro Pro or Excel 2007 or perhaps use a
database program instead. What kind of a spreadsheet really needs 256
columns?

Bill

 

[Paul Hyett]

Those are full cell addresses. Your first column is A. Your last column
is IV. The 1 is the row number.

The answer is No. Change to Quattro Pro or Excel 2007 or perhaps use a
database program instead. What kind of a spreadsheet really needs 256
columns?

Some of mine would benefit from more than that - but from what I've
heard Excel 2007 is a PITA.

 

[Andrew Dearborn]

Bill,

The answer is No. Change to Quattro Pro or Excel 2007 or perhaps use a
database program instead. What kind of a spreadsheet really needs 256
columns?

The problem that I'm facing now is that the VB application that I originally
wrote for Excel using 50 columns has expanded to 1715 rows/230 columns; it is
a matrix to define what layers/datatype are to be defined in a process
technology. Obviously, I would prefer not to sink an add'l month(s) of
development time creating the same application inside a different tool that
has > 256 columns; Excel has worked fine so there is no need to change unless
Excel doesn't support it.

Instead of questioning a user's methodology, perhaps you should simply
answer the question yes/no and/or provide a workaround if one exists... there
could possibly be a good reason why people push Excel to the limit (because
there is a limit).

-Andrew

 

[Ron Rosenfeld]

On Fri, 12 Dec 2008 16:35:00 -0800, Andrew Dearborn <Andrew

Bill,


The problem that I'm facing now is that the VB application that I originally
wrote for Excel using 50 columns has expanded to 1715 rows/230 columns; it is
a matrix to define what layers/datatype are to be defined in a process
technology. Obviously, I would prefer not to sink an add'l month(s) of
development time creating the same application inside a different tool that
has > 256 columns; Excel has worked fine so there is no need to change unless
Excel doesn't support it.

Instead of questioning a user's methodology, perhaps you should simply
answer the question yes/no and/or provide a workaround if one exists... there
could possibly be a good reason why people push Excel to the limit (because
there is a limit).

-Andrew

Andrew,

As Bill wrote, "The answer is No."

Changing to Excel 2007 will increase the number of columns and rows and may not
require you to modify your VBA application at all.
--ron

 

[Bob Harrison]

What kind of Spreadsheet needs over 256 columns...Hmmm

365 days in a year, 366 in leap year.

Comparing weekly earnings CY vs PY = 365 x 2 = 730 columns.

Just a couple of examples