NEED A LARGER SPREADSHEAT

G

Guest

Does any version of Excel have collumns past collumn IV?

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

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
 
G

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.
 
R

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 ;-)
 
M

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.
Click to expand...
 
J

Jamie Collins

rank Kabel said:
Access has the same 256 columns limitation.
Click to expand...

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 :)
Click to expand...

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
Click to expand...

The limit is also 255 columns.

Jamie.

--
 
O

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.
Click to expand...
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.

--
Click to expand...
Click to expand...
 
Top