update data link

  1. J

    VBA help - Code to update excel links when file path changes

    Hi all, I am really struggling to find an answer to my question so hoping someone here might be able to help. I have a set of Excel documents set up as a template for new jobs each time a new job comes in. When we get a new one in I copy and paste the "template" file and rename it as the new...
    • jirose93
    • Thread
    • file path error file path; links link between workbooks update data link vba & macros
    • Replies: 1
    • Forum: Excel Questions
  2. C

    Updating External data links automaticly without opening the Workbook

    Hi There I have a workbook that is linked to 4 SQL database tables that I would like to be able to have update automatically, say at a specific time or after a specified period, without having to open the file. The SQL data sources are password protected, so I assume VBA will be my only...
    • custy
    • Thread
    • automatically external sql update data link vba
    • Replies: 0
    • Forum: Excel Questions
  3. M

    Open Excel file & update links in Word doc not working with Protected View Excel files

    OBJECTIVE: I have a Word file with 275 linked fields to an Excel file. I would like the user to be able to select any range in the Word file and update selected links, and I would like this process to occur without the Excel file opening/closing for each individual link. CURRENT SOLUTION...
  4. S

    Updating Spreadsheet From Online Source

    Hi I currently have an excel workbook that extracts data from an online excel file. I am new to VBA and the macro I built accesses the master file online and simply copies and pastes everything into my workbook on my first sheet. From there my other sheets access my copy of the master to build...
  5. M

    Issues with automatic updating of Excel charts in PP

    Hi guys, I've made a PP presentation with numerous charts. To make the monthly updates run smoothly, I've created dynamic references to the input vectors of these charts - you know, offset(,,,,counta()) and so forth. Then I paste the charts to PP, choosing the 'link data' option and everything...
    • mattisz
    • Thread
    • dynamic cell range powerpoint 2013 update data link
    • Replies: 0
    • Forum: Excel Questions
  6. M

    PowerPoint presentation that refreshes excel links that gets interrupted when file is in use

    I have spent the last two weeks reading many forum posts trying to solve my problem. I have been unable to find a clear working resolution. What I have:A power point presentation that has information in the slides that pull from excel files on the network drive.(Paste special, link to excel...
    • Marcor
    • Thread
    • automatically excel & vba 2007 power point macro refresh hyperlinks update data link
    • Replies: 2
    • Forum: Excel Questions
  7. J

    Using VBA to update data links from 2 excel files

    Hi, I am new to VBA so please bear with me!! I have 3 excel files. File1 contains the raw data. File2 contains links to file1 to put it into the required format. File3 contains links to File2 to present the data. Due to a number of reasons this is the file structure that we need to maintain...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top