Google Answers: Excel PivotTable Page Field

View Question

Q: Excel PivotTable Page Field - stop resetting to "all" ( No Answer, 0 Comments )

Question

Subject: Excel PivotTable Page Field - stop resetting to "all"
Category: Computers > Software
Asked by: kevin_excel-ga
List Price: $15.00

Posted: 26 May 2003 15:13 PDT
Expires: 25 Jun 2003 15:13 PDT
Question ID: 209064

I recently upgraded to Excel 2000 and I'm encountering an annoying
PivotTable "feature" that I'd love to get rid of.  When I add data to
an existing PivotTable and resize the data range to incorporate the
new data, the page fields in the pivot table automatically reset to
"all", rather than just staying at their previously selected value. 
Any ideas on how to disable this "auto reset to all" feature?

Answer

There is no answer at this time.

Comments

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.

Search Google Answers for

Google Home - Answers FAQ - Terms of Service - Privacy Policy