Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Reports
Hi I have some data which I want to sort and group together. I figured out that using pivot table would give me a nice format and save me the trouble of updating even though I don't need the summarise function of pivot tables. I managed to create a pivot table with 7 fields and I actually hid the 'Total' column as it's useless to me. The problem comes in when I want to increase the range of the data. I got the error message below: "Microsoft Excel cannot make this change because there are too many row or column items. Drag at least one row or column field off the pivot table or to the page position." Currently, I only using 150 rows and 11 columns. Can anyone help? Thanks -- Muffin ------------------------------------------------------------------------ Muffin's Profile: http://www.excelforum.com/member.php...o&userid=36093 View this thread: http://www.excelforum.com/showthread...hreadid=558733 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! Reports
Hi,
I'm receiving the same error. It means that, in the pivot table layout step, you put too many fields in either the row or column section. Apparently, you can only have so many. Not sure if that helps you...I'm still trying to figure out what other options there are for reporting my data. "Muffin" wrote: Hi I have some data which I want to sort and group together. I figured out that using pivot table would give me a nice format and save me the trouble of updating even though I don't need the summarise function of pivot tables. I managed to create a pivot table with 7 fields and I actually hid the 'Total' column as it's useless to me. The problem comes in when I want to increase the range of the data. I got the error message below: "Microsoft Excel cannot make this change because there are too many row or column items. Drag at least one row or column field off the pivot table or to the page position." Currently, I only using 150 rows and 11 columns. Can anyone help? Thanks -- Muffin ------------------------------------------------------------------------ Muffin's Profile: http://www.excelforum.com/member.php...o&userid=36093 View this thread: http://www.excelforum.com/showthread...hreadid=558733 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create org chart from excel file with reports to column | Charts and Charting in Excel | |||
macro to run series of reports to PDF | Excel Worksheet Functions | |||
help on excel reports for anaylsis and trending | Excel Worksheet Functions | |||
merging reports | Excel Discussion (Misc queries) | |||
Can I Distribute Excel reports that retrieve Data-On-The-Fly ... | Excel Discussion (Misc queries) |