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...
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?
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...
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...
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...
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)...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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"...
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...
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...
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 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.