+ Reply to Thread
Results 1 to 5 of 5

Offline query update and backup

  1. #1
    Registered User
    Join Date
    05-29-2020
    Location
    Braga
    MS-Off Ver
    2019
    Posts
    18

    Offline query update and backup

    Morning all,

    I have a query that is getting data from a folder and I want to set a specific day/date to update it and automatically saves a back up file of whole data on a specific folder. I want something autonomous without any user interference.

    The folder with the source is on my Company’s SharePoint and the query is on my OneDrive.

    Is this something possible to do?

    Thank you all 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 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: Offline query update and backup

    Please read the yellow banner at the top of this page on how to attach a file.
    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
    05-29-2020
    Location
    Braga
    MS-Off Ver
    2019
    Posts
    18

    Re: Offline query update and backup

    forgot to add the example. hope this can helps. this is just an quick and easy example but just to have an idea.

    as i said before, just want to make the process automatic and with no user interference to refresh and save a copy (if possible just data with no connection.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-29-2020
    Location
    Braga
    MS-Off Ver
    2019
    Posts
    18

    Re: Offline query update and backup

    Everyone, any help?

  5. #5
    Registered User
    Join Date
    05-29-2020
    Location
    Braga
    MS-Off Ver
    2019
    Posts
    18

    Re: Offline query update and backup

    All, I really need your help on this.

+ 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] Update Web Query Without deleting old data, just update new ones.
    By pancho111 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-30-2017, 05:09 PM
  2. Update Query Url: Excel 2016 Query
    By igoodable in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2017, 12:45 PM
  3. Can anyone give me on an offline update?
    By J0k3r in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2008, 05:56 AM
  4. Update Worksheet using an offline workbook?
    By Trojanhorse in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2007, 09:58 AM
  5. [SOLVED] Backup:always create a backup file in the save options
    By Alek in forum Excel General
    Replies: 1
    Last Post: 01-07-2006, 09:25 PM
  6. [SOLVED] When I update a Excelspreadsheet backup copy is automatically crea
    By Pat Berardinelli in forum Excel General
    Replies: 0
    Last Post: 01-04-2006, 10:05 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