exporting info to workbook

  • Thread starter Thread starter Larary
  • Start date Start date
L

Larary

Excel supports only 256 columns so data in columns IW
through ZZ is not exported from the spreadsheet. Is this
problem fixed in excel 2002?
 
There are still only 256 columns*65,536 rows. If you have XL XP, just look
under help for the limits.
 
Peo Sjoblom said:
one can question if it really would be a fix? I have heard that after
Quattro Pro changed the boundaries of the rows / columns it became
more or less unusable.
Click to expand...

It wasn't just the workbook size. It's flaky, but my experience with it is
crashes entering formulas in default size workbooks.

However, I also use Xess under Linux, and it provides over 1000 columns and
almost 100,000 rows, and I have yet to crash it. I haven't tried to build
gnumeric with more than 256 columns yet.

It *is* possible to write robust spreadsheets with more than 256 columns.
Microsoft has even written a spreadsheet web component that could be the
core of a much large grid spreadsheet, but they haven't made it into a
full-blown application. (Whether it's robust or not I have no idea.)
 
Hank,


one can question if it really would be a fix? I have heard that after
Quattro Pro changed the boundaries of the rows / columns it became
more or less unusable.
Click to expand...

"Unusable" may be an exaggeration; I've used it (Version 10, which
came with my notebook) to get around the 65,536 row limit on occasion
and haven't encountered any stability issues with it. I can get what I
need to do done, but admittedly I've never "pushed the envelope" with
it. I find it to be a somewhat frustrating product to use at times and
its on-line Help is fairly brainless, but had I the time or
inclination to learn the QP way of doing things I may feel
differently. Since I have neither, it's just a supplement to the three
versions of Excel that reside on that machine.
 
Back
Top