Need More Columns

[agweer]

We use Quick Books 2003 which has a feature that allows us to save financial
reports to Excel with the simple click of a button. One especially useful
report allowed us to sort financial data by Class (i.e., Property) into
separate columns in Excel. Once into Excel, we could reformat the data
easily.

Unfortunately, in 2003 we went over 256 "Classes" and can no longer do that
report (P & L by Class). Quick Books simply gives an error message saying
"Sorry, you've exceeded 256 columns" and refuses to go any further.

Is there an Add In that will increase the number of columns in Excel? The
problem will probably still remain, because of the rigidity of Quick Books,
but I thought I'd ask.

 

[Arvi Laanemets]

Hi


No way for Excel to exceed the column limit. Maybe you can redesign QB
report so, that you get 2 reports instead - one for 1 group of classes, and
second for rest of them. Then you can merge both Excel workbooks to one
2-worksheet workbook afterwards.

 

[Aardvark]

Presumably you could also split the spreadsheet into two workbooks and have
them both open at the same time in the same workspace.

Danny