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

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

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

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

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

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

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

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

What I am working on is a template file for doing material takeoffs. I am trying to set it up so that it can reference another document and pull in data from that document. Basically all the values it is pulling in are set up as indirect links within an IF statement. What I am hoping to do...

Hi I have 1000 of website links some of them are having Java scripted and some are not. i need a macro to identify all the java scripted links. thanks for help.

With office 365 on the horizon, I need to catalogue all of our spreadsheets, and identify links. I am doing this by creating a workbook object, setting the object to" Set wb = Workbooks.Open(path & file) var_Links = wb.LinkSources(xlExcelLinks) 'set variant = excel links This works great...

When I open a workbook, it asks to connect to links. Is it possible to remove them and just leave the values in? Thanks

I have built a report in Excel. The report includes a set of web links. I used the following formula to create a link and the link works perfectly in Excel. However, when I convert the Excel report to PDF, the link doesn't work. Any suggestions? =IF(OR(O204="Blind Spot", I204<4)...

Hello, I wrote some code to look for external links to "file A" and replace them with links to "file B". The code is in PowerPoint, and in this PowerPoint file I have about 25 "objects" linked to excel (the objects are primarily just cells from excel pasted into PowerPoint as linked objects)...

Hello Everyone, I am interested in learning about Add-Ins, specifically how to make them. Any helpful resource you know about??? Any links to guide, videos etc. Regards,

Morning all I am trying to populate listboxes with hyperlinks. I have 2 Userforms "Project Tracker" and "Add Links". When "Project Tracker" is in use I want to be able to add links into different ListBoxes via an additional "Add Links" Userform when the command button "Add" is pressed from my...

Hi, I am looking for code that would be able to scrape a link like this ? https://future.pinnacle.com/en/baseball/mlb/houston-astros-vs-detroit-tigers/987051592/ There would be multiple links that it would have to run through that would have the same structure. The prefix would always be...

We have a master database that holds a lot of data. We want to migrate this to SQL. The issue becomes we do not know who all accesses this database and what other databases/processes have links to this database. What are your best way to determine what all connects to a master database? I...

Hello, I don't normally venture in to Outlook programming, but I have a problem I'm trying to solve. My organization recently enabled ATP for incoming outlook email links from external sources. So now, when I reply to an email, or forward it internally, identifying information remains in place...

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!