M
mathel
Hi,
I am new to Pivot tables and I am trying to do a report to track certain
information. I created a workbook that has 19 columns and intended to do 3
worksheets (reports) using various rows/columns from the Master List
worksheet. One report would be 'Active', the other 'Potential' and the last
'Finalized. Initially I was working with formulas to bring the data forward
to whatever spreadsheet, however, the file was so big, it took forever to
open. Pivot tables came to mind, but, I need at least 11 columns of data
from the Master List on the Active report. When I tried to refrshed the
report when more data was added to the Master list, I got an error code
'....there are too many rows or columns. Drag at least 1 row or column field
off the report......'
Is there a limit to the number of columns Pivot Tables can handle? The way
it is set up now, I have the Status (Active, Potential, Finalized) as the
Page, showing rows of data broken into sub-catagories by region, then the
detail for each beside the region. Ie:
Region Portfolio Name Address Balance Due Value Est. Cost ....etc
Quebec 1234 John 15 Now 25,000. 50,000 3,000.
2333 Sam 2 Hard 18,000 22,000 2,000
Subtotal
Ontario etc.........................
I am using Excel 2003. Perhaps I am using the wrong type of report,
application? Any suggestions are welcome.
Thanks
I am new to Pivot tables and I am trying to do a report to track certain
information. I created a workbook that has 19 columns and intended to do 3
worksheets (reports) using various rows/columns from the Master List
worksheet. One report would be 'Active', the other 'Potential' and the last
'Finalized. Initially I was working with formulas to bring the data forward
to whatever spreadsheet, however, the file was so big, it took forever to
open. Pivot tables came to mind, but, I need at least 11 columns of data
from the Master List on the Active report. When I tried to refrshed the
report when more data was added to the Master list, I got an error code
'....there are too many rows or columns. Drag at least 1 row or column field
off the report......'
Is there a limit to the number of columns Pivot Tables can handle? The way
it is set up now, I have the Status (Active, Potential, Finalized) as the
Page, showing rows of data broken into sub-catagories by region, then the
detail for each beside the region. Ie:
Region Portfolio Name Address Balance Due Value Est. Cost ....etc
Quebec 1234 John 15 Now 25,000. 50,000 3,000.
2333 Sam 2 Hard 18,000 22,000 2,000
Subtotal
Ontario etc.........................
I am using Excel 2003. Perhaps I am using the wrong type of report,
application? Any suggestions are welcome.
Thanks