links

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. D

    Find 'unsupported features" and "unsupported links"

    I have a large-ish .xlsx file that I keep live on sharepoint for multiple users to view/edit and it suddenly is saying that it has 'Unsupported Features' and external links. I've searched the whole workbook for external links and I have not found references to an external workbook in any cell. I...
  14. N

    Data Connections and Workbook Links

    I am creating links between 2 excel workbooks. When I open one workbook, there supposed to be a popup message as below for me to decide whether to update or don't update the links from the close workbook: In Trust Center, already checked "Prompt user about Data Connections" for Security...
  15. U

    Break External Links only in Certain Cells

    Good morning, I have a worksheet which links to other worksheets for its calculations. I already have a macro which deletes all external links, but I'd like one that deletes just external links from a certain worksheet, as that worksheet pulls in many values and can slow the program. The linked...
  16. C

    VBA - Links to other data sources

    Hi all, I have a some very simple coding saved in a Macro Enabled workbook. Everytime I open the workbook I get the message stating that it contains links to other data sources - it gives me the option to Update, Dont Update or Help. What I want is some coding so that on opening the macro...
  17. M

    Updating links from excel 2016 to powerpoint 2016 by clicking on an action button

    Is is possible to build an "action button" in PowerPoint 2016, that will allow the links on that slide to update by clicking on, instead of right-clicking and selecting "Update Link" on the pop-up menu? Is there a macro that can be assigned to the "blank" button in PowerPoint? If possible, this...
  18. N

    Phantom Links in Workbook that cannot be found to be deleted

    Hello, There is a workbook links that is hidden in my Excel 2016 Excel file. I believe it is causing Excel to crash as it tries to access a network folder I don't have access to. The only way I know the links exist is through the Inquire tab, using the Workbook Analysis tool. The problem is...
  19. W

    excel hyperlink issue

    I created a monster. I have a workbook that isbeing used as an index of all our documents. Each row represents one document and each row is made up of several columns. Each row has a hyperlink that spans the entire number of columns . The hyperlink is to a scanned document on the network. They...
  20. M

    VBa help

    Hi i have few links in column A of an excel sheet. i am looking to check for java scripted links by opening each link manually on IE, then press CTRL +U it open up a page on browser then i have to find the same link of column A there if its present there column B is filled as Yes else No...

Some videos you may like

This Week's Hot Topics

Top