external

Hi everyone i have two questions i need help with. 1st. Is when i am using external data that is imported into excel from the web, Hyperlinks on the websites table does not get transferred into excel but instead just text. Is it possible to change this so it imports working hyperlinks. (Using a...

This snippet will create a new sheet and return all the external links but my problem is that the link it returns isn't found on any sheet within the workbook (as a formula) nor do I find it in the name mgr refs. Where else could it be and how do I find it? Thanks P.S. would be great if the...

Hi, Does anyone please have a fool proof method for finding External Links in Excel 2016 Workbooks ?. I've tried searching for them in cells, I've checked conditional formatting, names ranges etc, and yet one still persists. Thanks in advance for your help. Thanks Gav

Good day, Is it at all possible to create a connection from another workbook to include images? As data tables work fine, but leave the images behind. Or in some way dynamically add a number of images to a sheet - possibly from a folder. Thanks in advance for any help.

Hello Everyone, I am using excel table for mail merge, everything was working fine untill once i got the error stating "External table is not in the expected format". And now everything is mess. Kindly help me in this matter. Thanks.

Hello all I have a question about how to edit the formula below so that it looks up a result in an external workbook (rather than in another tab). =INDIRECT("'" & $D$8 & "'!"&ADDRESS(ROW(H95),COLUMN(H95),4)) A spreadsheet that I completed with a bit of help from this forum (thank you...

Has anyone used the new external sharing capabilities as shown in the latest Guy in a Cube video? Assigning one of our licenses to a client is quite attractive given the number of users (internal and external) would be way below making premium capacity attractive. Is it easy to use? Any...

One of my spreadsheets is calling an external file (xlsm) link on opening, but that link does not exist in the "edit links" dialogue, and a search through the formulae does not show any cell referencing that external file. There are a number of other external links that function normally. Even...

Hi I am working on a dashboard which pulls data from external excel files across multiple different columns. For the sake of this example, the columns which contain this external data are C, D and E in row 7. I want to add a column at the end of the dashboard which checks the formulas in...

Hi, I have a sheet where cell D5 is populated with a value each minute by an external source. Is there a formula that will return the word "low" if the value 32 appears three times in that cell? Thanks

=COUNTIFS(B14:B17,">=1/1/2010",B14:B17,"<=12/31/2010") Example given from a helper site What I have tried for my own data =COUNTIFS(B6:B100,">=A1",B6:B100,"<=A2") <<<< Note my data set is correct range, A1 is not activated or seen as a date, I want the...

Hi, I should start off by stating that im pretty much a complete novice in Access, but will attempt to explain the situation as best I can. I have been tasked with creating pivot tables in excel via an external connection (an access database) I have managed to do this via Pivot Table > 'use...

So I have many Excel spreadsheets that contain numerous external links that I don't necessarily want to update every time I open the file. For example, somebody might update some data in another file that I'm not ready to pick up yet. All of a sudden, every single file that I open that...

I have a evaluation form that I NEED help with. There are 4 Rating levels to choose, E, S, NI, and NA with a value of 3, 2, 1, and 0. Each Category (Blue row) has subtask (Green rows) with a percentage weight for each. In the example below, you can see in Column F that each weight is 25% for...

Hi, I have an excel file where almost in every cell there is an external reference. In every month I use a "find and replace" macro to change the reference links but it takes hours to finish it!!! Is there a way to use a macro for the followings: 1. it collects all the external file links on...

Hey guys, I read quite a few posts about breaking or delinking links to external sources. I found quite a handy code, see below, to break links the easy way. However, I am stuck with a couple of annoying links to external sources: (1) Some links are stored within data validation (I copied one...

Hi! Having some trouble here... Long story short, I have a list of URLs (approx. 100 of them) in Column A The URLs are very similar, as are the web pages themselves. I'm trying to scrape data from each URL--preferably returning the data in a single table/query in Excel. I think I need to...

Hello, I have a few questions about get external data from web for Excel 2016 for Microsoft computers. I hope this isn't an inappropriate question for this forum. I am interested in doing a lot of get external data from webs on a regular basis and would like to know more about it before moving...

Title says it all really. I'd like to combine the behaviours of ALLEXCEPT and ALLSELECTED. So remove the filters, other than external filters, from all the columns except a particular one. Is there a function or way to combine these functions?

Hi There I have a workbook that is linked to 4 SQL database tables that I would like to be able to have update automatically, say at a specific time or after a specified period, without having to open the file. The SQL data sources are password protected, so I assume VBA will be my only...