Worksheet 'shape' (#columns by #rows)

P

Peter Snell

Hi All;

Have a problem here in that we would like to import some data into a
spreadsheet, but the data array is 512 by 512 elements. Excel seems to
force a limit of 256 columns. Is there a way to change the array shape?
In any Excel version 97-2003.
--
__
Pete Snell
Royal Military College
Kingston Ontario
[email protected]

The reasonable man adapts himself to the world;
the unreasonable one persists in trying to adapt the world to himself.
Therefore all progress depends on the unreasonable man.
- George Bernard Shaw
 
P

Peter Snell

Frank said:
Hi Peter
there is now way to change this limitation (Excel 97-2003). There is a
Microsoft KB article who describes a workaround:
http://support.microsoft.com?kbid=272729

HTh
Frank

Thanks Frank! Looks like it would be simpler to use Quattro-Pro! ;-)

Pete

--
__
Pete Snell
Royal Military College
Kingston Ontario
[email protected]

The reasonable man adapts himself to the world;
the unreasonable one persists in trying to adapt the world to himself.
Therefore all progress depends on the unreasonable man.
- George Bernard Shaw
 
Top