+ Reply to Thread
Results 1 to 10 of 10

automatically Refresh PivotTables

  1. #1
    Forum Contributor
    Join Date
    05-01-2018
    Location
    London, England
    MS-Off Ver
    Excel 2010 and Excel 2019
    Posts
    104

    automatically Refresh PivotTables

    Hello all

    I'm not familiar with VBA at all.
    I tried to google some solution to my issue however none of the answers I found are working ...

    My challenge is to make sure all PivotTables (in PivotTables tab) are automatically refreshed once criteria in cell F2 (in book tab ) changes
    Cell F2 part number from column A (book tab)

    i tried with two part numbers
    MA-0601
    A32650

    Can you please support

    thank you

    attached workbook
    Attached Files Attached Files
    Last edited by adsako; 05-19-2020 at 02:30 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    616

    Re: automatically Refresh PivotTables

    In the module of sheet 'PivotTable'

    Please Login or Register  to view this content.

  3. #3
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,522

    Re: automatically Refresh PivotTables

    Try this in the "Book" worksheet's code module
    Please Login or Register  to view this content.
    ____________________________________________________________
    If I've been helpful, let me know. If I haven't, let me know that too.

  4. #4
    Forum Contributor
    Join Date
    05-01-2018
    Location
    London, England
    MS-Off Ver
    Excel 2010 and Excel 2019
    Posts
    104

    Re: automatically Refresh PivotTables

    Quote Originally Posted by Vraag en antwoord View Post
    In the module of sheet 'PivotTable'

    Please Login or Register  to view this content.
    Hi
    thanks

  5. #5
    Forum Contributor
    Join Date
    05-01-2018
    Location
    London, England
    MS-Off Ver
    Excel 2010 and Excel 2019
    Posts
    104

    Re: automatically Refresh PivotTables

    Hi

    very helpful

    thank you

  6. #6
    Forum Contributor
    Join Date
    05-01-2018
    Location
    London, England
    MS-Off Ver
    Excel 2010 and Excel 2019
    Posts
    104

    Re: automatically Refresh PivotTables

    I'm coming back again ...

    this solution works if Pivot Tables are on another sheet
    but what if i got this pivot table on the same sheet where is my criteria?
    i want to refresh only pivot tables when i put my criteria

    I got one big report which pulls data from different sources and I want put also Pivot Tables on the same sheet however when i moved Pivot tables to the sheet where my criteria is (part number) Pivot Tables are not refreshing
    Attached Images Attached Images

  7. #7
    Forum Contributor
    Join Date
    05-01-2018
    Location
    London, England
    MS-Off Ver
    Excel 2010 and Excel 2019
    Posts
    104

    Re: automatically Refresh PivotTables

    Quote Originally Posted by adsako View Post
    I'm coming back again ...

    this solution works if Pivot Tables are on another sheet
    but what if i got this pivot table on the same sheet where is my criteria?
    i want to refresh only pivot tables when i put my criteria

    I got one big report which pulls data from different sources and I want put also Pivot Tables on the same sheet however when i moved Pivot tables to the sheet where my criteria is (part number) Pivot Tables are not refreshing

    Hello again

    I tried several solutions I found online - none of them is working
    i still need to click on Pivot Table and refresh to get updated data
    it does not matter what solution I found ... none of them are working. What am I doing wrong?

    My PivotTable pulls data from different sheet but my criteria which change PivotTable data in source is on active sheet (this is Part number for instance ma-0601 like in previous post - see above)

    Solutions advised previously by dangelor is working once pivot in on different sheet but when i moved pivot to the same sheet where my criteria is this solution stoped working
    and Vraag en antwoord is working however this refresh all including all queries and i do not want to refresh queries each time criteria is changed

    Can you please advise ...

    thank you

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: automatically Refresh PivotTables

    Did you put the code of Dangelor in the sheet Pivot Table?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  9. #9
    Forum Contributor
    Join Date
    05-01-2018
    Location
    London, England
    MS-Off Ver
    Excel 2010 and Excel 2019
    Posts
    104

    Re: automatically Refresh PivotTables

    Hi

    i do not know what has happened but when I run this report at home all was refreshing and when I applied this code to file at work (after changing ranges), Pivot table refresh is not working ... I'm just starting to get frustrated LOL
    file is running and is not showing any error but Pivots are not refreshing ... to refresh I have to manually refresh each table

    can you please advise what is wrong ...
    I have changed range to REPORT and also criteria to $F$3 but it is not running
    Thanks
    Attached Images Attached Images
    Last edited by adsako; 05-18-2020 at 03:47 AM.

  10. #10
    Forum Contributor
    Join Date
    05-01-2018
    Location
    London, England
    MS-Off Ver
    Excel 2010 and Excel 2019
    Posts
    104

    Re: automatically Refresh PivotTables

    Quote Originally Posted by adsako View Post
    Hi

    i do not know what has happened but when I run this report at home all was refreshing and when I applied this code to file at work (after changing ranges), Pivot table refresh is not working ... I'm just starting to get frustrated LOL
    file is running and is not showing any error but Pivots are not refreshing ... to refresh I have to manually refresh each table

    can you please advise what is wrong ...
    I have changed range to REPORT and also criteria to $F$3 but it is not running
    Thanks
    hello all
    would it be possible to let me know where is the problem and what am I doing wrong

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 9
    Last Post: 09-05-2017, 06:14 PM
  2. Web page refresh automatically
    By Venkatesh.S in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2016, 10:44 PM
  3. [SOLVED] How do I selectivly refresh pivottables in a workbook?
    By swong1709 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-06-2015, 11:03 AM
  4. Annoying bug (?) in PivotTables that don't refresh properly
    By pbengtss in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-07-2015, 09:24 AM
  5. Refresh PivotTables with OLE Automation and MS Excel 2007
    By sgovoni in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-28-2010, 08:54 AM
  6. Replies: 0
    Last Post: 10-01-2008, 11:14 AM
  7. [SOLVED] Re: How to refresh dropdown lists in PivotTables?
    By Eleanor M in forum Excel General
    Replies: 6
    Last Post: 03-03-2006, 10:15 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1