Linking Cells to Pivot Table Data

[EliseFreedman]

hi There

I have got a report dashboard which has a bunch of pivot tables which update in the background. The user can select a function/site to filter by and the pivot tables should change to that site/function. I had no issues with it working last week but suddenly its not working at all. Nothing happens when the selected cells change.

I exported the code and report to a separate workbook and tried running the code but still nothing happens when the values in the cells change.

I cant work out what im doing wrong - no doubt im missing something stupid so I am asking the experts to help

 

[SkipVought]

Elsie,

The CODE in your workbook had some errors.

1) You need Option Explicit at the top of EVERY module.

2) The End With and End Sub statements were misspelled.

Then, I'd use the Worksheet_Change rather than Worksheet_SelectionChange and I'd at least use only ONE MsgBox if not NONE.



Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[SkipVought]

...and the other thing that I would do is...

1) make a list of unique Home Teams and

2) make a Data > Validation Drop Down to select a Home Team

3) make a list of Home place of work based on the Home Team selection

4) make a Data > Validation Drop Down to select a Home place of work.

5) change the procedure to fire when the 4) selection changes the worksheet.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}