external

  1. M

    external link?

    When file open, msgbox asking "This workbook contains links to one or more external sources that....." I searched for .xl in formula and found non. any idea where I can find external link and delete?
  2. M

    Importing Website Data Into Excel Issues

    I am having an issue with "Get External Data" from two different websites from the same vendor https://results.enr.clarityelections.com/IL/Will/95133/Web02.225997/#/ and https://www.dupageresults.com/IL/DuPage/94959/Web02.225997/#/. Currently, I am unable to figure out how to pull the data into...
  3. D

    Wrapping not changing row height with linked formula

    Hello I have 2 sheets in my workbook. Basically it is an external and internal version of the same content. All information on the external sheet is linked by formula to the corrosponding internal version. So in A1 on external version is a formula linking to A1 on external version. Both cells...
  4. P

    External Links- Can't find. Tried everything

    I know everyone is going to think this is an easy one to solve, but please read all before commenting. This is not the typical situation where all you need to do is CTRL F and search for [ or search for .xlm I've tried those fixes. It is not as simple as going into Excel Options and...
  5. P

    Difficult Situation External Links (tried everything- need advanced user to help)

    I know everyone is going to think this is an easy one to solve, but please read all before commenting. This is not the typical situation where all you need to do is CTRL F and search for [ or search for .xlm I've tried those fixes. It is not as simple as going into Excel Options and...
  6. gmooney

    ChartSheet ComboBox Scaling Issues

    I have code that sets the zoom level to match the PC that it is being displayed on. This works great so that ChartSheets fill up the screen for large sized external monitors down to small laptop screens. The issue is that my combobox dropdowns resize and move whenever I move from external...
  7. J

    Killing External links

    I have Excel 2016. Occasionally I have a difficult time breaking external links. My process is as follows: Data - Edit Link - Break link. If link is not broken then I delete any "named" ranges referencing an external files, and then Data - Edit Link - Break link again. Most of the time this...
  8. J

    VBA Batch Update external links

    I have an Excel file that is looking at a few hundred external Excel files. These external links now need to be changed to new files each of which has a new file path and name. I have a list of all the old files paths and names in column A of a spreadsheet and a list of all the new files paths...
  9. G

    VBA Code to prevent inclusion of external links in the Workbook

    Hi all, I hope you can help me with this. I need a code to prevent that any external link or reference can be included in my Workbook. For example, I have my Workbook "Master" and someone wants to include in it a reference from another Workbook called "Country", let´s say in tab "Data", cell...
  10. M

    SUMIFS when data source is closed

    After reading many threads I realize I can't use SUMIFS when the data source workbook is closed, but I just can't wrap my head around the SUMPRODUCT function, if that is what I should be using. I've posted my current SUMIFS formula below that works when the external data source is open. I have...
  11. S

    How to automatically refresh an excel sheet

    Hi All, I have an excel sheet that pulls information from an external source. The external source updates regular. My query is :- How do I get my excel sheet to update automatically without having to do anything manually. I need the excel sheet to this as it will be on a monitor as live data...
  12. D

    External table is not in expected format

    Hi Everyone, I am using power query to access a file from share point. I used Microsoft flow to connect an email folder to outlook (get attachment). This folder will receive an attachment everyday. So far only two days this flow has worked. Here is the error that I am getting. "External table...
  13. P

    Lookup for value with multiple IDs repeating in same columen

    Hello, I am new here and hope you can help with with my problem. We have an output from attendance system (is mostly up to 200-300 rows) and need this data to use/input in another file without adding in manually and checking if assigned values to the correct cell. I create connection with...
  14. H

    Bulk changing links to external workbooks that dont yet exist

    I need to change the text in a large number of links to external workbooks. This is a monthly task and sometimes the workbooks I reference have yet to be created. This means if I use Find and Replace to change part of the text string in the links the update values dialogue will appear and end...
  15. Madara

    Value paste all external links

    Hello guys, Can anyone provide me a VBA code to value paste all external links in my active workbook? Only external links. I don't want to value paste functions in workbook such as SUMS, SUMIFS!. Thank you!
  16. J

    Dropping/inserting a text string into an external link formula

    Hello all, I am trying to poll/extract quote information from an external source using a formula in Excel… Based on the input into cell C4, how do I insert that address into my link formula? ="PROPHETX|QUOTE!"&C4&"?Last" returns <tbody> PROPHETX|QUOTE!ATO?Last instead of the price for...
  17. C

    Showing the last saved date in a cell (external file)

    Hi Im currently using Excel 2010 Is there a way of doing the above? the external file in question is in a separate directory "\\H:\Dashboards\P6Update I would like my spreadsheet to just show the latest saved date of this file whenever it gets saved in cell C2 Thanks
  18. B

    Can't find a phantom link

    When I input a formula in a cell, it is randomly updating other cells in different columns with no apparent links. I have gone through and deleted all external links, I've reviewed all formulas to make sure they are manually removed, and I've gone through charts and shapes to make sure there...
  19. O

    external references aren't updating as expected

    Hi all, I have a markbook that is pulling in data from an external reference. There are a lot of external references in the markbook, and quite a few versions of the markbook (for different departments) all referencing the one data sheet. What I seem to be experiencing is that the markbook is...
  20. J

    Unhide sheet from hyperlink - except when it's external link

    So I have this code which works great for unhiding a sheet when i click on a hyperlkink. The problem is, when i click on an external link (i have some links that take me to sheets within the workbook an other links that take me to external folders) it will throw out an error when the external...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top