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 |
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) |