links between workbooks

  1. R

    Can I break a link, using a VBA

    I have a master excel file, that populates data (links) to excel files, when they are opened. I want this to be a once off link, so that when I save the new excel file for the first time, all links are removed, just the raw data remains. I know there is a manual option to break the link, but I...
  2. A

    Auto detect new worksheet and move/copy it’s contents(select) to a master workbook

    Hi all. I’m trying to connect several workbooks to a master workbook. The master workbook should be able to detect any new worksheets in connected workbook and bring some content from them to the master workbook. Any idea how to do this?
  3. S

    Edit Links>Change Source keeps resulting in endless multiple prompts to select new link

    Hi All, Longtime reader, first time poster. Thanks in advance for the help! I'm trying to use the Edit Links function to change a few links (one at a time, though some formulas may reference multiple files/links in the same cell), but whenever I use the feature, after I point to the new file...
  4. I

    Correcting external links in Formulas Name Manager

    Hi, There is a macro-enabled .xlsm file produced by my team at work that gets sent to others to populate every month. Any time the file is opened, a catalogue of error messages pops up highlighting links to external workbooks that cannot be refreshed. I have found these links in the Name...
  5. M

    Links only updated when [check status] is clicked

    Hi, I have one destination workbook open on PC#1 (Windows 10) The workbook has links to two source workbooks open on two networked (wifi) laptops (Windows 10) PC#2 and PC#3. I'm using the current version of Excel 365 (on all three computers). For the cells of the destination workbook to be...
  6. Z

    Why is this code to edit links so slow?

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

    Copying Linked Excel and PowerPoint files, having new copies link to each other

    I have a PowerPoint template that contains several charts and Microsoft Excel objects linked to an Excel template. I would like to have it so that when the user makes a copy of each file, the new copy of the PowerPoint file is linked to the new copy of the Excel file. Is there any way to...
  8. j3andc

    Linking to other files in Excel 365 ProPlus

    I am new to office 365 and have recently started having problems when I re-open a file that I have previously linked to. If I open the linked file while the file with the formulas is open, the link gets "broken" and has to be recreated. This is wasted time and I cant afford that. Is anyone...
  9. P

    No errors in Hyperlink formula but nothing happens

    Hello Can anyone see why this hyperlink formula won't work - it doesn't show any errors, it shows the correct friendly name result from the other workbook, but when clicked literally nothing happens... no error messages, nothing... anyone have any ideas? This is the formula...
  10. dannyok90

    VBA Refresh

    Hi, All Sorry to come to the board with a complete problem, I usually like to bring a sort of solution or at least a bit of code I'm working with. But this time I have nothing and I'm completely stumped :eeek: I have a worksheet that is full of links to another worksheet but one particular...
  11. K

    Cell formatting problem

    Hi, I have one cell in my spreadsheet "1" that doesn't react to formatting. In the spreadsheet "1" there are many cells that have links to another spreadsheet "2" and if the values in that spreadsheet "2" are zero then by using cell formatting in the spreadsheet "1" instead of values "0" there...
  12. Z

    The master file which consolidates values from other files shows #VALUE when the files are closed

    Hi, I have created a master consolidation file, which is pulling values from other files by using SUMIF function. The problem i have is that when i open the consolidation file it always shows #VALUE! in all cells that have the SUMIF formula. To get rid of the errors i have to open all the...
  13. J

    Dynamic Link to another Folder

    Hello All (cliche first time here after lot of searching for help but found nothing), I am looking to make many workbooks to monitor different information for clients that constantly change each month. What we are currently doing is having all the different excel workbooks for each client in a...
  14. N

    Losing Excel Links

    Hi folks, I have a spreadsheet that pulls in links from three other spreadsheets. Everything keeps shifting or I am losing the links. Questions: When I insert new rows, to add new data sets that I will then link, will all the links that were previously linked "after" the inserted row be lost...
  15. B

    How to view All the name ranges and deleted unwanted using a macro

    I have workbook with multiple tabs on a worksheet. when I click the name manager nothing happens. How can I view all the names in the workbook and delete the selected names. I try using the macro blow but no luck. Sub DelRefNames() Dim n As Name For Each n In ActiveWorkbook.Names If...
  16. B

    External Links not auto-updating when Source File is OPEN

    I have a very odd occurrence happening. My linked data is not updating when my source file is open. I have a central workbook that has links to about two-dozen source workbooks. The links work properly when I open the file. However, if I open both the Master workbook and one of the source...
  17. D

    How to create link to open an external file at a given tab/cell position?

    I'm trying to set a link in an Excel file, to open a different file, and place the cursor in a specific cell on a given tab. I have been unable to find anything online to show this, and I've exhausted my trial-and-error patience. Expected: =HYPERLINK("\\server\folder\file.xls]tabname!$A$3000"...
  18. S

    Hyperlink question

    Hello, I have created a hyperlink on my spreadsheet with CONCATENATE, and it opens the file from my server just fine. It resides in G4. In H4, however, I would like to have a formula that pulls a value from that hyperlink in G4. I have this formula: ='[G4]2-4-16'!$I$4, but Excel still makes me...
  19. P

    vba to refresh links

    Hi I have some vba code the will refresh links and return figures from destination workbooks.. Works fine if the workbook has been opened today. If the workbook hasn't been opened it returns the figures from the previous day. The destination workboks use the formula today(). As aswell as...
  20. M

    Pivot Table link to external workbook and naming

    Hi Guys,Has anyone done / or have an example of a pivot table that is link to an external workbook.Solution Brief:I have master workbook with 12 worksheets Jan - Dec, here there are 4 columns with sales data etc, this is called master.xlsxNow I can create the pivot table and read the data from...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top