links

Apologies for my less descriptive title. There is more nuance to the situation, but I couldn't fit it in a short title. Background: The situation I am dealing with is this. We have a master takeoffs spreadsheet that we've created with about 8 different tabs in it. For the longest time there...

I would like to be able to select certain cells that have linked formula's and then select edit links and change the source only for those cells selected It would be appreciated if someone could assist me in this regard Also posted here...

Hi. Hope someone can help me with the following small problem. We've got a workbook, links to three other workbooks, but the data wont refresh through the links. When we open the three workbooks manually, then hit refrest all, the data does update. My friend has had a good search for a...

Hi, I'm sure this is probably very easy to do, but I have an inventory spreadsheet, which is duplicated each day. The sheet follows the date. 26112018 27112018. The cells which reference the previous days data, are linked to the previous sheet for the date in question. Once I duplicate the...

Hi I'm trying to update a spreadsheet with a lot of external links, I've tried to do it using the Edit Links button but it just hangs. I'm now trying to do it on another offline machine by using Find and Replace to change the network path and filename to the new location, I've turned off...

Hi all, I have a number of workbooks (i.e. workbook 1,2,3) that are summarised in one workbook (i.e. workbook 4). Workbooks 1,2,3 will need to be updated throughout time and they will also need to have other copies for scenario analysis. My issue is with version control. When I update...

I have a workbook with a ton of external links (Tabs JAN - DEC each with at least 100 external cell references). The workbook it's linked to changes annually. Instead of going through the LOOOOOONG process of editing the links via the DATA tab, is there a quicker way to do this? It used to...

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

I have been working on this spreadsheet for a few months and it is just about ready for prime time. Unfortunately it has decided in the last couple days that it has links and it asks every time I open it about refreshing them. The links are phantom and don't exist anywhere except in the warped...

Does anyone know a VBA code that will refresh all links in PowerPoint set to manual update. It takes a long time to update each link individually. The links are to excel pivot table and charts. I don't want to set to automatic as I want control as to when the charts refresh from source. Thanks

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!

Hello folks, Is there a way to Break links (changing links to values) while keeping the rest of the formula? Example: Before: =[File1.xlsm]Sheet1!A1 * B1 = 5 * 1,01 = 5.05 After: =5 * B1 = 5 * 1,01 = 5.05 My objective is that I might want to change cell B1 afterwards. Thanks you for your...

I have a file that has links from two other files. Each month, I need to change the link of one of the sources to another file Can anyone help me write a macro that will do the following: Open up the edit links option, allow me to select a source, then open up a sharepoint location where I can...

Is there any way to keep links to other sheets in a workbook when converting the whole workbook to a pdf? I have certain external links which all convert fine, but any internal links I have (e.g. a table of contents) loses all the links once saved as a pdf. I've tried Save As and Export as PDF.

Hi All, I'm having some problems with a spreadsheet I have created at work. I've created the spreadsheet in Excel 2007 and tested the spreadsheet on my computer to ensure it works right. its got links to other spreadsheets on the network. When I send out an email for people to go into it...

Hi Would appreciate and help and advice. I have a file with thousands of links in cells to other workbooks, I need to change the filepath to these links, which I've done with a find and replace, despite the updated filepath being correct, it is still opening the Open file dialogue box for...

Hello Suppose I have a hot link(s) in an excel spreadsheet. In adjacent cells to these cells containing hot link, I want to put the hot link's URL as text. Can this be done in excel? Thanks.