Results 1 to 3 of 3

Thread: Pivot Tables

  1. Jul 6th, 2004, 03:15 PM #1
    Helene
    Helene is offline

    Thread Starter
    New Member
    Join Date
    Jul 2004
    Location
    New York
    Posts
    15

    Pivot Tables

    Hi-
    I have a pivot table attached to a control button, however, every time I use the control button, I get a new pivot table. Any suggestions on how I can just get it to update the existing one?
    Thanks for your help, and have a great day.
    -Helene
    Reply With Quote Reply With Quote
  2. Jul 8th, 2004, 09:32 AM #2
    BrianB
    BrianB is offline
    Addicted Member
    Join Date
    Aug 2002
    Location
    Luton, UK
    Posts
    178
    Something like :-

    Code:
    Worksheets("Sheet1").Range("A1").PivotTable.RefreshTable
    Regards
    BrianB
    -------------------------------
    Reply With Quote Reply With Quote
  3. Jul 8th, 2004, 10:38 AM #3
    Helene
    Helene is offline

    Thread Starter
    New Member
    Join Date
    Jul 2004
    Location
    New York
    Posts
    15
    Thank you very much Brian. I'll let you know how it turns out.
    -Helene
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width