+ Reply to Thread
Results 1 to 6 of 6

automac upload and refresh

  1. #1
    Registered User
    Join Date
    08-18-2019
    Location
    Brussels
    MS-Off Ver
    2016
    Posts
    4

    automac upload and refresh

    Hi guys, I have a question for you.

    I have created a pivot table from a mix of interrelated table from various excel spreadsheet.

    Now I would like to make the process more automatic. In simple words I want, once I download the new data, this data to replace the previous one and modify the pivot table. The fact is that in each table there are also some calculated field according the data.

    So how can I do?

    thank you in advance

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: automac upload and refresh

    If I am understanding you correctly, then one way of doing this is to Load the raw data into Power Query. Merge or Append the data needed to create your PT. Once this is completed, load your new table to Excel and create your PT. Each time you amend any of the tables with new data, then go to the PT and click on Refresh twice. The PT should automatically update based upon the Power Query being refreshed.

    If you are unfamiliar with PQ, then click on the links in my signature block to get started.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-18-2019
    Location
    Brussels
    MS-Off Ver
    2016
    Posts
    4

    Re: automac upload and refresh

    Hi Alan and thank you for the answer.
    In complete honesty I have not understood, since I am not so familiar with Power query.
    Every time I need to change the data (once per month) that come form a report or a dashboard that I can download manually (no problem with that).
    The fact is that the table, after been downloaded will be modified by adding new calculated fields.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: automac upload and refresh

    Have you looked at the Power Query Links in my signature. PQ seems to be ideal for what you want.

  5. #5
    Registered User
    Join Date
    08-18-2019
    Location
    Brussels
    MS-Off Ver
    2016
    Posts
    4

    Re: automac upload and refresh

    yep I got a look, tahnk you. I have also partially fixed the issue I had.
    I have understood how to use to modify the date automatically. I still do not know how to make it download the new data, substitute and substitute the old one.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: automac upload and refresh

    If you have a file that is linked to PQ, each time you update the file on the input sheet and then click refresh on the out put sheet, PQ automatically updates the query and the output. Look at this video to better understand.

    https://www.youtube.com/watch?v=LSDQGWdgNJs

+ 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. Refresh Progress Indicator Slowing down Query Refresh
    By rabbit_post in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2018, 07:56 AM
  2. Macro to refresh Essbase data sets, display refresh date?
    By nellaneb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2014, 03:59 PM
  3. Replies: 2
    Last Post: 09-29-2013, 06:15 AM
  4. Replies: 1
    Last Post: 09-28-2013, 07:11 PM
  5. Unable to upload files to upload center
    By GeekoMania in forum Office 365
    Replies: 0
    Last Post: 09-11-2013, 03:18 AM
  6. [SOLVED] Using VBA to change a pivot table filter, refresh the report and set up a refresh delay
    By Bonnister in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-18-2012, 10:43 AM
  7. Enable Auto Refresh - Wait for refresh to sinish before running a macro
    By tomlancaster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2011, 11:52 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