Excel limit that stops pivot table processing at column IV??
 

I have an Office-X compatible spreadsheet on a PC and Mac that has been
working fine. It is an automated Macro w/ Visual Basic. A larger than
previously experienced data file (CSV) arrived and the Pivot Table
consistently quits at column IV. Internal size limitations? Doesn't seem
like Visual Basic word size problem.

Excel limit that stops pivot table processing at column IV??
 

All current XL sheets are limited to 256 columns (column IV)



In article ,
TooTall wrote:

I have an Office-X compatible spreadsheet on a PC and Mac that has been
working fine. It is an automated Macro w/ Visual Basic. A larger than
previously experienced data file (CSV) arrived and the Pivot Table
consistently quits at column IV. Internal size limitations? Doesn't seem
like Visual Basic word size problem.

Excel limit that stops pivot table processing at column IV??
 

Never ran into it. Is it safe to assume that Visual Basic, etc, does not
have this limitation?

Thank you for your quick response

"JE McGimpsey" wrote:

All current XL sheets are limited to 256 columns (column IV)



In article ,
TooTall wrote:

I have an Office-X compatible spreadsheet on a PC and Mac that has been
working fine. It is an automated Macro w/ Visual Basic. A larger than
previously experienced data file (CSV) arrived and the Pivot Table
consistently quits at column IV. Internal size limitations? Doesn't seem
like Visual Basic word size problem.