I suggest three improvements in Excel Pivot Table.
1. We should be able to enter formula as we could in previous version. Like
relative and absolute address. Now if we want to add another column for
example to deduct expenditure from budget we have to do it line by line or
change it to values and do it. If we create new formulas, unnecessary data is
shown for each group/top level.

2. We should be able to sort by figures within Pivot table and be able to
add conditional formatting through menus.

3. The volume of data it currently manages is less. If we have records in
thousands, then Excel AutoFilter and Pivot Table cannot manage it.

Please let me know if it's not clear enough
--
Zubair Ezzat
Database Consultant
Kabul, Afghanistan
c:(+93) 70 29 09 29


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc