links

Hi I have part of a macro shown below that moves files into a new subfolder that ive created in a folder called backup. It saves the workbook as NEWSUMMARY1.XLS no problem but im then trying to break the links after the file moved. Any Ideas? Sub PERIODEND() Dim sName As Variant...

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've ended up with a corrupted workbook, so I copied each page as data to a new workbook ( without the VBA ), now when I open the new workbook it gives me a warning that it contains links to another workbook and if I remove the link(s) it will convert the affected formula(s) to values. How do I...

Hi, i have this code that i've been tinkering around with - i'm trying to have it work so that it removes all external links only on a specific tab (Summary Tab). Am i headed in the right direction with this?

Hello All, I have a perplexing problem hoping someone can help. This may not be an Excel problem, but it is definitely a MS Office problem. I have Office 2016 on a Win 7 PC. I have created a Word document where I have pasted a link to an Excel workbook chart. What I am trying to do is...

Hello all, I have a very simple problem (i am sure it is), but i just can't resolve it: - I have one excel workbook that opens another workbook with VBA: Application.Workbooks.Open Filename:="C:\Users\xxx\Desktop\yyy.xlsx", UpdateLinks:=True -I need the VBA to update all the links, then copy...

There are 2 files. File A has links to a source file and was updated from that source at 10am. File B has links to the same source file and was updated from that source at 5pm. The source file changed between 10am and 5pm. If file A is opened after file B, the data in file B changes as if it...

Hello, I insert links to webpage URLs to have access to references. The links work perfectly in the local drive but when I store the file in a shared drive for other users to get access then the links error out. Please let me know how I can insert these links so I can have access in shared...

Hi I have templates and im going to insert them into a workbook. Thing is the templates once inserted need to be linked to another workbook. Is there anyway I can do that without having to create links manually.

so i have a workbook that's linked to another workbook...but the links aren't updating! the only way I can update the links is if 1) i manually go to the cell then enter again or 2) go to "data" -- > "edit links" --> "update values" or 3) i open both workbooks (workbook with links and...

Hi, I have a Powerpoint File, which has many Excel linked linked Charts. Now the folder name and Excel File names are changed. I need a macro to a) list all the links of the powerpoint file. b) I want to update the new link. Help me by a macro to do so. Thanks in advance. Regards...

I've seen a couple of things close to this but this is a little odd. I have a password protected file "Mater File Links" Its protected from the general public (of this office) The way the data is entered is through another Workbook. Before I was forced to protect the "Master File Links" the...

Hi Cell range A599:A613 contains different links that have changed. I need to copy the links in the above range and paste the new links in cell range B599:E613 without affecting any of the contents of those cells. I'd appreciate it if there's a way of doing this with code before I die of...

Dear all, I have updated excel version to 2016. My master data file is linked to many supporting files from different locations (last year & different months). In previous version, Edit links was showing file names (and it was very easy to identify which file is required to update). In new...

Hello all, First time Poster here, and novice in coding in general. My issue I am having is more a question of knowledge I feel. I am looking to scrap a java-script table on a secure site. So far I am able to log in but to get to the Data I want. There is a few buttons and links I must click...

I have several spreadsheets with hundreds of hyperlinks to pics in one of the public drives. The links keep changing from where I originally set them to a roaming folder. It takes way more time than I have to keep manually entering the links to each cell when they change. Is there a way to...

I have created a master spreadsheet with links to four other spreadsheets which shows the correct results when all linked files are open. However, if I open the master spreadsheet alone the linked cells show #VALUE ! rather than the value. In case this is relevant the linked cells are a "SUMIF"...

HI I have 2 workbooks exactly the same numbered 1 and 2. Both have 6 sheets of data and sheet 7 has a summary. When I open workbook 2 the links where it looking for data is from workbook 1 sheets 1-6 but I need it to look at workbook 2 sheets 1-6 . I did see something about edit link on a...

Hi, I have links in column A in my excel file. They are web addresses and are highlighted blue. When I click them they don't open. Nothing seems to happen. If I right click the link and select "Open Hyperlink" still nothing happens So appreciate anyone's help with this :-D

Hi, I'm after a macro that will automatically open links as they populate in Google Sheets. Using Zapier and API I have links that are automatically loading into Google Sheets. Lets say each time a new row is made and a new link is inserted in Column A, how would I then get my computer to...