Refresh all pivot tables upon change of data in a single cell

I am trying to refresh all pivots in my workbook upon click and change of text in one cell on the first tab of my work book. This cell is called "G8_Select" (which is really just cell D4 on my G8 Summary tab). I tried to use this code but it didnt seem to work:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "G8_Select" Then
ActiveWorkbook.RefreshAll
End If
End Sub

Can someone let me know what I might be doing wrong?

Thanks,
Kelly

Hi KAC1979,

There might be some hyperlink error occured in the cell "G8_Select". Please check that or can you upload the sample file.

Thanks,
aganesan99

How do i know if there is a hyperlink. I right clicked and there doesnt seem to be a hyperlink. I just re-entered the code and now it does seem to be doing SOMETHING when i click on the cell to change the value. It starts calculating, but it doesn't actually update the pivots. Do I need to do something other than Refresh All to get it to know to update the whole workbook?

Hi,

I can't figure out the problem unless I see a sample workbook. Or some expert might be helping you.

Thanks,
aganesan99

ok thanks, i can't load the information because its private. I would change to dummy data but that would take some time. I am going to try to find someone else to help.

thanks i just tried that and it still doesnt work.

no error message at all, but the pivot tables are not updating when i change the value in the cell "G8_Select"

Ok it works, but i am testing it now........

G8_Select is a drop down field. I don't actually want anything to update until I make a change to the field, but it seems to be making updates when i click on the field (before i have a chance to pick the value i want)

Also, do you know if i can add a message to the user saying "refreshing" and "Refresh complete"?

thank you soooooooo much for your help. everything is working perfectly now. Couldn't have done it without you!