+ Reply to Thread
Results 1 to 2 of 2

How to update automatically a joined table and its pivot tables?

  1. #1
    Registered User
    Join Date
    01-18-2021
    Location
    Italy
    MS-Off Ver
    365
    Posts
    22

    How to update automatically a joined table and its pivot tables?

    Hello everyone,
    I was trying to use VBA to update a Table ("db_Joined", set in the "DB_Joined" Sheet), which is the result of two tables ("db_Analyzed" and "db_ToBeAnalyzed, set in their respective Sheets) joined with a Power Query.
    Since the Joined Table generates some pivot tables, which are copied into a Dashboard, I would like to be able to update everything automatically, whenever I add a new row to "db_Analyzed".

    Obviously I tried many times to do this. I can do it with a simple table, but it looks like I'm doing something wrong in this particular case...
    Do you think it is a good idea? If so, may you help me? I'm open to any advice!

    As always, I attached my example workbook. It is zipped, because normally it occupies 1,02 MB.

    Thank you in advance!
    ifritaeon61
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-18-2021
    Location
    Italy
    MS-Off Ver
    365
    Posts
    22

    Re: How to update automatically a joined table and its pivot tables?

    It's not all that necessary that you make a macro for me.
    It would be much appreciated to have some feedback, too. Maybe about whether my idea is good or not, so that if necessary I may change something.

+ 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. [SOLVED] Automatically update a summary page from different pivot tables
    By jimjones1958 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-24-2020, 11:31 AM
  2. Replies: 1
    Last Post: 02-25-2018, 09:47 PM
  3. Two pivot tables with the filter of pivot table 2 to automatically update to filter 1
    By StefaniaLa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2018, 06:19 PM
  4. Macro to update pivot table filters from multiple pivot tables of different data sources
    By groblerdn85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2017, 05:10 AM
  5. Update my Pivot Tables automatically after X minutes
    By akardar1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2014, 10:11 AM
  6. Automatically update all data connection & Pivot tables every hour
    By PWinkz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2013, 11:32 AM
  7. Update pivot tables automatically
    By minrufeng in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2005, 09:41 PM

Tags for this Thread

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