INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Linking Cells to Pivot Table Data

Linking Cells to Pivot Table Data

(OP)
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

RE: Linking Cells to Pivot Table Data

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Linking Cells to Pivot Table Data

...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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close