How Can You Disable Automating Sorting In Pivot Tables?

1.	How Can You Disable Automating Sorting In Pivot Tables?
Answer» Go to 'More Sort Options' after you right click on 'Pivot Table' and CHOOSE 'Sort' MENU. Then click on 'More Options' and finally uncheck the 'Sort automatically when the REPORT is created." Go to 'More Sort Options' after you right click on 'Pivot Table' and choose 'Sort' menu. Then click on 'More Options' and finally uncheck the 'Sort automatically when the report is created."

Answer»

Go to 'More Sort Options' after you right click on 'Pivot Table' and CHOOSE 'Sort' MENU. Then click on 'More Options' and finally uncheck the 'Sort automatically when the REPORT is created."

Go to 'More Sort Options' after you right click on 'Pivot Table' and choose 'Sort' menu. Then click on 'More Options' and finally uncheck the 'Sort automatically when the report is created."

Discussion

No Comment Found

Related InterviewSolutions

How Will You Check The Memory Consumed By Your Pivot Table In Kilobytes?
Which Option Is Used To Add Column(s) In Pivot Tables To Compute The Values In Run-time? For Eg. If The Underlying Source Table Contains Cost Price And Sales Price, How Would You Compute 'profit'.
Which Event Do You Use To Check If A Pivot Table Is Modified?
How Can You Disable Automating Sorting In Pivot Tables?
Which 3 Report Formats For Pivot Tables Are Available In Excel 2007 Or Later?
How Can You Hide The Error Values In Data Field Of Pivot Table?
How Would You Enable Automatic Refresh In Pivot Table Upon Opening The Workbook Without Using Macros?
When You Link To A Pivot Table Cell, A Getpivotdata Formula Is Created. How Would You Avoid This?
Can You Change The Default Summary Function For Data From Count To Sum?
Upon Refreshing A Pivot Table, It Always Loses The Formatting Like The Column Width. How This Can Be Corrected?

How Can You Disable Automating Sorting In Pivot Tables?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment