external

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...

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

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...

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...

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...

I am new and was not able to find something specific. We have an external drive, this drive has folders, in those folders there are more folders, in the folders are videos of various formats. Im looking to list the top level folder name and below that list the names of the files. In excel...

Hi. Is it possible to use names from external workbook? I couldn't manage to find a way to connect workbooks so I could use external names. This is my external workbook: From my local workbook I want to look up a range name with VLOOKUP, and then look up needed percentage based on the range name.

"This workbook contains links to one or more external sources that could be unsafe." I'm getting this error in my one workbook. I've had it before and been able to fix it, but now nothing seems to work. I just can't find where the external reference is. I've tried File->Check for Issues...

Hi All, I am looking to create my own macro from an external report that I receive. The external report is write protected so the first step that im getting the macro to do is copy the cells into a new workbook. my code is: Range("A1").CurrentRegion.Copy Selection.Copy...

I am using ETL Manager extract URL as an external connection (from Web) in Excel. However that always gives me a top row with cell A1 saying "DSS Report". I would like to get rid of that row so I tried to use the ETL URL as a data source for Power Query. When I go New Query -> From Other...

I am using ETL Manager extract URL as an external connection (from Web) in Excel. However that always gives me a top row with cell A1 saying "DSS Report". I would like to get rid of that row so I tried to use the ETL URL as a data source for Power Query. When I go New Query -> From Other...

Hopefully a straight forward answer to this one... How do I get the totals for items that are the same in each column totalled. Need 1-2 (4.308+4.274), 3-11, 12-13 etc. I know it's easy to do it based on the sample below, but I've got tons of pages of data like this...

I have a table in a worksheet (named "stock list") with 5 columns in a workbook I will call Workbook1 and in other workbooks with identical tables. The last column in workbook1 named "Total" is gotten by summing the "Totals" from the external workbooks. These external data sources are saved as...

I have an issue with an excel file. Within the excel file there is a sheet that’s taking the results of a database query, and then using external links through five different excel files with pricing structure, business rules, product facts, and foreign exchange rates. Maybe I’ve forgotten...

we have six subject marks internal and external need formula to sum best of five subject external marks and sum of internal marks which correlate with best of five external marks External Marks ENGLISH HINDI MATHEMATICS SCIENCE SOCIAL SCIENCE COMPUTER SCIENCE (Internal marks )ENGLISH HINDI...

This might be a stupid question, but how do I update my Excel 2016 so that it has the new "Get & Transform Data" Data ribbon tab instead of the old "Get External data" tab?

I created a pivot table in a file that I shared with a colleague. When she opened it she received an error message: "The PitvotTable connects to an external data source that's not supported in this version of Excel." The pivot table is not referring to anything external that I'm aware of. She...

I'm trying to generate a script that locates the last row with a value contained within it and store it in a variable. I then use said variable in a range and then copy the data from an external (closed) workbook. I am able to see that it copies the data correctly, however when it gets down to...

My Spreadsheet has one External Link in it. It works fine. Anytime the External Workbook is changed, my spreadsheet updates Automatically. I went to the "Startup Prompt" and selected the option to "Don't Display the Alerts and Update Links. Now, when I open my Spreadsheet, I get an error...

I have a file with an external link that I can't locate, break or delete. In fact, I isolated the link to one particular tab, deleted all of the other tabs, and then deleted all of the content on the "corrupted" tab and it's still there. I'd love to post the file in case someone knows how to...