NEED A LARGER SPREADSHEAT

[Guest]

Does any version of Excel have collumns past collumn IV?

What is the last available collumn in Excel v.3?

 

[JulieD]

Hi

the dimensions of a worksheet in excel has not changed (still to column IV &
65536 rows). I believe Quattro Pro has more columns / rows or consider
using a database product such as Access or SQL Server.

Regards
JulieD

 

[Guest]

hi,
column iv is about it. 256 columns. if you need more then
you may have to go to another spreadsheet. i know of no
others that have more than 256 columns. sorry.

 

[rank Kabel]

Hi Julie
Access has the same 256 columns limitation. Though one can
argue that this is enough for a database as you should use
foreign key relations rather than a 'flat-file'
structure

Not sure about SQL server though ;-)

 

[Myrna Larson]

Quattro Pro v 10 has up to 18,278 columns.

hi,
column iv is about it. 256 columns. if you need more then
you may have to go to another spreadsheet. i know of no
others that have more than 256 columns. sorry.

 

[Jamie Collins]

Access has the same 256 columns limitation.

I assume you mean a Jet database, for which the limit is 255 columns.

Though one can
argue that this is enough for a database as you should use
foreign key relations rather than a 'flat-file'
structure

I assume you mean normalization, the principles of which can be
applied to Excel data, even though Excel lacks Declarative Referential
Integrity (DRI) i.e. enforcement of foreign key relationships.

Not sure about SQL server though

The limit is also 255 columns.

Jamie.

--

 

[Frank Kabel]

Hi Jamie
[...]

I assume you mean a Jet database, for which the limit is 255 columns.

yes indeed

 

[On Film]

Quattro Pro has default of 256 columns, but it can be changed to your
requirements in the options. See:
http://spreadsheets.about.com/cs/quattropro/qt/qpqtmorecols.htm

Mike

Hi Jamie
[...]

I assume you mean a Jet database, for which the limit is 255 columns.

yes indeed

I assume you mean normalization, the principles of which can be
applied to Excel data, even though Excel lacks Declarative Referential
Integrity (DRI) i.e. enforcement of foreign key relationships.


The limit is also 255 columns.

Jamie.

--