external link

  1. E

    Dynamic Filename in Linked cell

    I am trying to setup a dynamically linked cell. This is the link i have: ='https://mezcom.sharepoint.com/sites/Mez/Shared Documents/John Smith/[John Smith 2018 Time Sheet.xlsx]Jan 1-15'!$AH$8 this is what i am trying to do: B1 would equal a persons name, b3 would be the year...
  2. S

    Referencing Closed via open workbook external links - VBA

    EDIT: Sorry, the title should have read: "Referencing Closed Workbook via Open Workbook's external links - VBA" --------------------------------- I have some code in WorkbookA where I ask for the location of WorkbookB (the data and location constantly change). Via a prompt I am able to select...
  3. A

    Can I turn off External Link auto updating of the “LINK” not the data?

    I have workbooks on SharePoint. I link data from Book2 to Book1 such as: Book1 cell A1 ='https://hawaii.mil/Tracker/[Book2.xlsm]Tracker'!A1 I understand the concept of not having Book1 open when and if Book2 is opened and moved because the Eternal Link will follow the move. Here is my...
  4. Z

    "Phantom links"

    Hi everyone, I often use links to external data to upload the data to my current workbook and than I delete the links to save the present values. But sometimes the link cannot be deleted! I use Office 2010 and all the tools I found on this forum either involve Excel 2003 or are broken. Can...
  5. 6

    VBA Editing External Links

    I have searched through several threads already posted and some of them "touch" upon what I have trying to do, I try out some of the suggested solutions, but nothing seems to work the way I need it to. So let me start off by explaining what I am "trying" to do. I have to track employee...
  6. D

    external workbook data link with variable workbook reference

    I have a number or workbooks containing weekly status reports..I would like to aggregate them into a single workbook for mgmt access... Given: all workbooks (status reports) are formatted identical; all worksheets (a week status report is contained in a worksheet with the week in the format of...
  7. S

    Changing name of Source Workbook

    On Jan. 1st my Jobs List folder will be archived due to the size and the file name changed to "Jobs List 2008-2011". For every job on the Job List, I have a separate workbook that tracks time and expenses for that particular job. Every individual Job Worksheet has a link back to the Job List...
  8. I

    Refrancing xlExcelLinks - VBA

    Hi, I have the following simplified array formula in cell A1 Sheet1, If I wanted to update the link within excel itself I would simply click Edit>Links>Change Source and job done. The issue is that this formula needs to be within a macro and just the result displayed in cell A1 Sheet1...
  9. J

    Simple link to external xls file

    a1: 210.xls a2: 211.xls a3: 250.xls .... an: 335.xls In my master xls file, I want to link a cell from each of the above files listed in column A. If I type (say to cell B1) =[210.xls]sheet1!$B$6 I can get the value of cell "B6" of "sheet1" of file "210.xls" Now my question: Is there a way to...

Watch MrExcel Video

This Week's Hot Topics

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
Top