Worksheet 'shape' (#columns by #rows)

  • Thread starter Thread starter Peter Snell
  • Start date Start date
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
(e-mail address removed)

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
 
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
(e-mail address removed)

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
 
Back
Top