external

As the title reads, i'm looking to see if there is code to break external links only on specific tabs in a workbook. I have found a few codes on this forum, however, they all break external links in the entire workbook - not specific tabs. I can provide these code if necessary. Thank you!

Hello Board, I have just taken over a workbook and on checking it, I can see there are around 90,000 cells that have links out to data in another workbook. is this the best was to have one workbook update another?

I have a rather large workbook that has a 'Template Page' where the default page styling, formulas, and tables reside. I have a Macro that clones the page, and then auto updates the formulas to refer [NewPage] instead of [Template] page. All works well, no issues. Then now they want to put in...

I'm very new to PowerPivot and the underlying data structure, so forgive me for missing any obvious answers here. I'm replacing a manually updated workbook with a data model and PowerPivot features and ultimately going to be sharing a dashboard-like file with external users. I want them to be...

I am experiencing problems when multiple users are saving userform data to an external workbook. I included error coding that informs when the save has failed and to try again which appears to work but now and then the workbook opens twice - and the message the workbook is already open is seen...

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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!