Hi Mynda,

Just to confirm, I have reviewed your lessons on the videos and spent a great deal of time and effort. 

Thanks Valerie!

Hi Valerie,

You seem to be confused about how to use the forum (did you see the email Phil sent you with instructions?), as you're still creating multiple posts that should be a single post, and you're not giving your posts a relevant title. Since you're posting your question in the Dashboard forum we already know the topic is about Dashboards, but we need you to give your post a specific subject title, just as you would for an email subject line. This will help us and others benefit from and use the forum.

Also, if you have a follow up point to make about a topic please post it as a Reply to that topic. Please don't start a new topic. I will move your followup to this topic so they are together.

Now, on to your question; I'm not sure what exactly you mean by 'link up all PivotTables to a Dashboard'. If by linking you mean controlling the filtering of multiple PivotTables with one interactive control from your Dashboard report then I'd recommend using Slicers. There are some constraints to this in that Slicers can only control PivotTables that share the same Pivot Cache, and for this they must share the same source data. You can learn more about inserting Slicers and how to connect them to multiple PivotTables in session 6.02. When you have multiple data sources the combo box macro solution in session 5.08 is an alternative.

The Dashboard course homework project has two data sources so you can't control all of the PivotTables with one Slicer, assuming you have PivotTables from both data sources.

I recommend you watch my Homework videos to see how I constructed my Dashboard. This may answer your questions better than I can in writing.

Let me know how you get on.

Mynda