Looking Help for Pivot Table in Excel

Asked By ave broers 70 points N/A Posted on - 08/22/2012

I am working with pivot table and facing some problems. The pivot tables in which I want to avoid the row selection permanently to a set of specific items, for example excluding any new fields when refreshing the pivot table. Is this possible in a pivot table?

I am looking for a kind help.

Thanks.

• Status: Open
• Question Views: 803
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By mickiyas.mahon 0 points N/A #151615

Looking Help for Pivot Table in Excel

 

I am working with pivot table and facing some problems. The pivot tables in which I want to avoid the row selection permanently to a set of specific items, for example excluding any new fields when refreshing the pivot table. Is this possible in a pivot table?

You can exclude new fields when refreshing the pivot table if your files are link with each other or you are importing some data from an outside or external source, or you are using online processing application. You can retrieve and update your data. It will not refresh by itself, you have to set up your Pivot Table properties to automatic refresh. You can also manually refresh your table by it setting-up under ‘tools menu’ or easy as clicking your Pivot Table and hit refresh.

This feature is more accessible if you are using Microsoft Excel 2007 and 2010. 

About mickiyas.mahon

Questions
0

Answers
44

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 08/29/2012
• Question Category: MS Excel