Results 1 to 2 of 2

Thread: Update Files from SharePoint
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2018
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default Update Files from SharePoint

    Hi, I just started using the Power Query add-on for Excel. I have a workbook that is connected to 3 different excel workbooks. The 3 workbooks were extracted from the SharePoint site and put into a folder. I have the main workbook which appended those 3 workbooks into 1 sheet. My problem is that my main workbook doesn't add the new rows of data when I refresh it, however, if I open all 3 workbooks and refresh them, the new rows of data is shown. When I save and close the 3 files, my main workbook will then finally recognize the new data and update.

    My question: Is there a way to refresh all 3 workbooks that are appended in my main workbook without having to open them each up individually and refreshing them myself?

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Post Thanks / Like
    32 Post(s)
    1 Thread(s)

    Cool Re: Update Files from SharePoint

    maybe extract data directly to the main workbook and Append this
    I know you know but I forgot my Crystal Ball and don't know what you know

    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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