• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Excel for Operations Management Course
    • Excel for Decision Making Under Uncertainty Course
    • Excel for Finance Course
    • Excel Analysis ToolPak Course
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
    • Password Reset
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Pivot Table filters not connecting to some pivot tables|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Pivot Table filters not connecting to some pivot tables|General Excel Questions & Answers|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumGeneral Excel Questions & Answe…Pivot Table filters not connecting …
sp_PrintTopic sp_TopicIcon
Pivot Table filters not connecting to some pivot tables
Avatar
Philip Z

New Member
Members
Level 0
Forum Posts: 2
Member Since:
August 1, 2020
sp_UserOfflineSmall Offline
1
August 1, 2020 - 1:38 am
sp_Permalink sp_Print

Hi Mynda/Philip/Catalin,

First of all please allow me to send a big THANK YOU to you with all the EXCEL tricks and demos I have been learning since 2014!

I have run into a problem that I could not find the root cause of my dashboard (googled with lots of various keywords) hence I am here to ask for your help.

My question is, like all the finalized dashboards with many slicers and interactive graphs, all of my constructed pivot tables are connected, and the data source is the same and only, but later as I added new pivot table(s) from the very same source of data to allow users the search function, the filter from pivot table fields does not apply to existing pivot tables anymore, thus the graphs are not interactive (Refresh All button clicked). However, they still respond to all Slicers. I have defined my source a name though, so whenever I need to insert a new helper column I can just add and then include the new column in the Name Manager for the same defined name, hope that's not a problem. 

I am very desperate and frustrated as this is how I was doing for the tables in the very same file earlier, but suddenly it does not work.

Thank you very much in advance!

Philip

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4448
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
August 2, 2020 - 1:08 pm
sp_Permalink sp_Print

Hi Philip,

Welcome to our forum. I'm trying to visualise the issue, but it's quite difficult to follow without your Excel file or even screenshots.

To be clear, if you're using the filter buttons on a PivotTable or Pivot Chart these filters are only applied to that one PivotTable/Chart. It's only with Slicers that you can filter multiple PivotTables/charts at the same time. Does that explain what is going on?

Mynda

Avatar
Philip Z

New Member
Members
Level 0
Forum Posts: 2
Member Since:
August 1, 2020
sp_UserOfflineSmall Offline
3
August 5, 2020 - 2:38 am
sp_Permalink sp_Print

*Revised MGMT added Event Data Quality Dashboard - Copy.xlsx: Error 106 - Upload file size exceeds maximum allowed size. - reduced to 1 month data but still over the limit. Screenshot insteadExcelForum.pngImage Enlarger

ExcelForum1.pngImage Enlarger

Hi Mynda,

Thank you so much for getting back my question with no time! I apologize for not sending you a file or screenshot as a demo in the beginning. I have uploaded this time*, however, and miraculously, Excel seems to fix the problem by itself over the weekend. Please allow me to describe what the problem was again with the file uploaded for your reference (if it does not bother you :)).

Background: In the "Management" A5, "Dashboard I" H5, and "Dashboard II" K5, there are PivotTables "Program Search" or "PROGRAM_NAME" to allow users to search by typing in program names as some basic operations. Dashboard I and II were the previously built tabs and Management was the addition.

Problem: After I added the Management tab and the PivotTable in A5, the filter was not corresponding to any of the graphs at all. I then checked and made sure all slicers are connected to the very same Data Source but the trick did not work. I tried the filters in H5 and K5 and they worked smoothly as before, and hence my confusion arose. I clicked "Refresh All" many times but it was futile.

Solution: Excel fixed the connections after I reopened the file and all tables are linked to the filter in the "Search Program" PivotTable. Note that I did close and reopen the application as well on Friday but no luck...

Thank you for your patience in reading along!

sp_PlupAttachments Attachments
  • sp_PlupImage ExcelForum.png (355 KB)
  • sp_PlupImage ExcelForum1.png (99 KB)
Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1515
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
4
August 5, 2020 - 7:17 am
sp_Permalink sp_Print

Hi Philip,

Use a free OneDrive account to store the file then share with us.

https://www.microsoft.com/en-a.....ud-storage

Phil

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4448
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
5
August 5, 2020 - 8:02 am
sp_Permalink sp_Print

Glad you got it working, Philip!

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Ngoc Tinh
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
michael serna
mashal sana
Tiffany Kang
Leah Gillmore
Sopi Yuniarti
LAFONSO HERNANDEZ
Hayden Hao
Angela chen
Sean Moore
John Chisholm
Forum Stats:
Groups: 3
Forums: 24
Topics: 6215
Posts: 27248

 

Member Stats:
Guest Posters: 49
Members: 31897
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —sp_Information

Sidebar

Blog Categories

  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
microsoft mvp logo
trustpilot excellent rating
Secured by Sucuri Badge
MyOnlineTrainingHub on YouTube Mynda Treacy on Linked In Mynda Treacy on Instagram Mynda Treacy on Twitter Mynda Treacy on Pinterest MyOnlineTrainingHub on Facebook
 

Company

  • About My Online Training Hub
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Support

  • Contact
  • Forum
  • Helpdesk - For Technical Issues

Copyright © 2023 · My Online Training Hub · All Rights Reserved. Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.