I am very much comfortable with Excel 2003 Pivot table. But i am using Excel 2007. The problem with excel 2007 pivot table is for each Row Position is not showing in Seperate column (only tab space is coming). If i try to copy & paste the Pivot table in a new sheet, then each row is not copied in seperate column in Excel 2007 Pivot table. But in excel 2003 Pivot table, each rows are copied in seperate column. How to overcome this problem in Excel 2007. Please Help! Thanks in advance
When your PT is active you can go to the Design Tab from which you can alter "Report Layout" - choose "Show in Tabular Form"
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I should add you can do the same as the above via selection of "Classic Pivot Table Layout" via PT Options -> Display -- unfortunately this setting does not persist for all PTs thereafter... if interested see:
http://www.mrexcel.com/forum/showthread.php?t=357712
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks