links

  1. Rob_010101

    VBA Update Links

    I've created and stored a workbook on a teams group for a number of users which contains formulae which link to another workbook I have saved separately, on a different teams group. I have tried to set the workbook to automatically update links but when other users, who are not that experienced...
  2. B

    Strange behaviour of cells that are set with links

    Hi. I faced strange behaviour of cells' values that are set as links to other workbook in the following manner: ='\\servername\foldername\[ExternalSource.xlsx]Sheet1'!A1 In general, there are 3 workbooks. One of them is external source which I refer to in way I've mentioned above. Other...
  3. A

    Create link based on other data from columns

    Hello, I am trying to have excel create a tracking link based on which carrier an employee selects in Column G and the tracking # in Column H. Since each carrier tracking has similar link formatting, I would copy their link, but just need to change the tracking # part of it ... for example...
  4. M

    Open list of links then save as pdf

    Hi, please help me make a correct code. I have a list of links in column A, and I need to open all links then save each webpages to pdf. I am using the below code but I can only open 1 link using it by changing the Range to A2 and it doesn't print to pdf. Unfortunately, I cannot download...
  5. J

    Formula Linking Excel workbooks in Dropbox for multiple users

    I apologize if this has been addressed and solved. I have been searching the interwebs for hours and while I can find my question many times over, I can't find a solution. My company uses Dropbox and every user has his/her own Dropbox account, although they all point to the same shared folders...
  6. F

    How to insert code into a workbook from another workbook

    Hi All, not sure if this is even possible but I'm trying to save a file from another workbook and then ensure that nobody can update any links in it, etc. upon opening, and so I'd need to insert the below two lines of code under 'Workbook_Open' but I'm unsure how to this, so I'd greatly...
  7. S

    Extracting Information From A Linked File

    Hi, I am trying to write some code that will allow me to perform checks on a file containing linked data (queries). My objective is to copy across the data source from 1 file over to a cell in the main file for verification. The linked data is output from SQL in a CSV format but the filename...
  8. C

    Excel & Cloud links

    Thanks for looking. What I am looking to to is hold some excel workbooks on the cloud. these workbooks are interlinked and work well on a local machine. links to books in the same or subfolders switched to the correct address just fine, but links to workbooks in other folders have not (as...
  9. M

    VBA solution to get rid of "update" links message when a file is opened?

    Hi I get two different types of messages when opening certain files with a macro, that I don't want to get. One of them says "This workbook contains links to one or more sources that could be unsafe. If you trust the links, update them, to get the latest data...." Then it gives you...
  10. gheyman

    Updating Linked Tables to Back End Problem

    I have a Back End (BE) with all my Tables. When I am solely in the Front End (FE) Database everything runs fine. As soon as another user opens and uses the Front End database the database somehow is loosing the links. We get a message that it doesn't recognize the back end and we have to...
  11. M

    How to create a macro add-in with customized ribbon?

    Please Help! Hello, I have a VBA module with 50 + macros located inside of personal.xlsb. I have customized an elaborate ribbon that links to all of these macros. I am trying to port this setup into a new workstation. I just made a copy of the personal.xlsb and put it in the xlstart folder...
  12. M

    How to transport Customized Ribbon Linked to Macros to another system

    Hello, I have a VBA module with 50 + macros located inside of personal.xlsb. I have customized an elaborate ribbon that links to all of these macros. I am trying to port this setup into a new workstation. I just made a copy of the personal.xlsb and put it in the xlstart folder of the new...
  13. masud8956

    Unable to break external link

    Hi, I have two workbooks. Both have one sheet with identical structure. So, for workbook 2, I just copied the sheet from workbook 1. There after I made amendments to workbook 2 formulas. These two workbooks are not required to be linked in any way. But every time I open workbook 2, I get a...
  14. S

    Stop or Remove File from trying to access external sources or websites

    The file in question is created by me (let's call it "File X"). It is located in my company's Shared drive - where all my files are kept. Another company (from Europe) sent us a file to fill out for them. When opened, it had a bunch of links to sites and sources that we don't have access to...
  15. Johnny C

    Links updating in VBA incorrectly to values previously overwritten???

    I've got 2 files, one with a sheet linked to the other so that they are the same sheet. The sheet linking to the other one is "Forecast - 8 - Output - 2020-23.xlsb" On sheet Constants, the formula in cell M22 is ='[Forecast - 1 - Assumptions - 2020-23.xlsb]Constants'!M22 That file is open. The...
  16. Q

    update multiple excel links

    this may be a bit of an overlap of MS Excel with MS powerpoint. I need to update multiple links on a powerpoint from 2 excel files. there are individual links displayed to each object, chart, graph in the edit links pop up. Is there a way i could update them all at once without having to...
  17. Johnny C

    Links updating incorrectly with a #DIV/0 error when source data is pasted values

    I have a file linked to another. Nothing fancy, 3 rows 4 columns in columns D-G with the formula ='F:\[Historic costs.xlsb]Historic costs'!B14 copied down and across. When I open the file (with the source closed) the data in columns D,E and G are fine, but the links in col F have a #DIV/0...
  18. J

    Finding Excel files with external links

    All, My administrative department has a bunch of Excel files with links to other Excel files in a variety of network folders. They want (need) to move the files to a new server. I'm thinking that if they move to the new server, all of the links will be severed and they'll need to re-link them...
  19. B

    Sorting Across the Down with Photos

    I'm creating a database of sorts with Excel. They want a photo page with links to a details page for each item. I'm trying to make a sheet that is 10 columns wide and then raps to the next row. The links are tied to the images so they need to be sortable in the case that a new item is added. I...
  20. Sanjeev1976

    Excel to Powerpoint - Link and editing range

    I have made different scenarios in Excel, which are then linked to a Powerpoint presentation. I'm trying to get the listing of these ranges of various links in the excel file. And the possibility of modifying the range in the links, which will then get reflected in the Powerpoint presentation...

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