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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
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
L
  • Solved
Code in excel VBA to refresh SAS tables instead of pivot tables
Replies
2
Views
132
Luigiportucale
L
B
  • Question
Update Pivot Tables with Refresh
Replies
1
Views
190
shift-del
shift-del
W
  • Question
Pivot table Refresh from a change to data validation list change
Replies
2
Views
164
wisemank
W
M
  • Question
Getting Power Query data to an Excel worksheet
Replies
4
Views
250
MichaelMorris
M

Forum statistics

Threads
1,215,487
Messages
6,125,073
Members
449,205
Latest member
Healthydogs

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