Pivot table issues

C

Camel123

Board Regular
Joined
Jun 5, 2018
Messages
186
Hi,

I have created a template for providing monthly reports on financial figures. I paste 1x row per project in sheet(1), then I have 7x sheets with the exact information (they are all linked). To those 7x sheets I have 7 different pivot tables.

When I update sheet(1) with new information and refresh all Pivot Tables, in the PivotChart Fields>field: Project names I need to filter all project names manually to show up in the chart. Is there a way to just click the refresh button and get an updated chart without manual adjustments in the pivotchart fields?
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
If I understand what you need:

Open the Pivot Table Field List and click on the filter field ....

... then Field Settings there should be a tick box at the bottom "Include new items in manual filter"
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
1K
Alex Blakenburg
A
A
  • Question
why does the rows remove from pivot table after auto refresh
Replies
1
Views
86
shift-del
shift-del
A
  • Question
Refresh a Pivot table with group fields gives errors.
Replies
0
Views
72
axelg
A
L
  • Solved
Code in excel VBA to refresh SAS tables instead of pivot tables
Replies
2
Views
179
Luigiportucale
L
B
  • Question
Update Pivot Tables with Refresh
Replies
1
Views
231
shift-del
shift-del

Forum statistics

Threads
1,216,101
Messages
6,128,845
Members
449,471
Latest member
lachbee

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top