Any way to get around the number of columns limitation?

  • Thread starter Thread starter 43fan
  • Start date Start date
4

43fan

I'm pretty sure there's not, but figured I'd ask anyway. ;)

I have a charting workbook that has grown to very probably needing more than
the 256 columns of data to do all the charting. At least for it to
continue doing it the way it is. I was hoping this particular deal I'm
doing right now would stop prior to running out of columns, but it's not
looking like it will.

Any help?

Thanks!
Shawn
 
http://blogs.msdn.com/excel/default.aspx

Some of my favs:

Number of conditional format conditions on a cell
Old Limit: 3 conditions
New Limit: Limited by available memory

The maximum length of formulas (in characters)
Old Limit: 1k characters
New Limit: 8k characters

The number of levels of nesting that Excel allows in formulas
Old Limit: 7
New Limit: 64

Maximum number of arguments to a function
Old Limit: 30
New Limit: 255

Lots of good info at that link.

Biff
 
Biff wrote...
http://blogs.msdn.com/excel/default.aspx

Some of my favs:

Number of conditional format conditions on a cell
Old Limit: 3 conditions
New Limit: Limited by available memory

The maximum length of formulas (in characters)
Old Limit: 1k characters
New Limit: 8k characters

The number of levels of nesting that Excel allows in formulas
Old Limit: 7
New Limit: 64

Maximum number of arguments to a function
Old Limit: 30
New Limit: 255
Click to expand...
....

Some of these more useful than others. Much longer formulas aren't
necessarily all that useful given the current formula bar. A 4K formula
should be able to cover the entire visible worksheet area under
1024x768 resolution and a reasonable default type size.

Arguments to functions also aren't that big a deal. It'll only benefit
the aggregation functions, SUM, COUNT, AVERAGE, etc. that accept
variable numbers of arguments. Will udfs share these specs? If so, I
don't know whether I'd look forward to passing a ParamArray argument to
a udf.
 
I can't wait to see the first application of 64 nested levels of:

SUBSTITUTE or IF

Biff
 
43fan said:
I'm pretty sure there's not, but figured I'd ask anyway. ;)

I have a charting workbook that has grown to very probably needing more than
the 256 columns of data to do all the charting. At least for it to
continue doing it the way it is. I was hoping this particular deal I'm
doing right now would stop prior to running out of columns, but it's not
looking like it will.

Any help?

Thanks!
Shawn
Click to expand...
Current version of Quattro Pro will give you many more columns -- no
need to wait. I assume you're already using more than 256 rows for your
data. If not, transpose data.

Bill
 
Back
Top