link between workbooks

I need to create a “workcopy” of a workbook with many worsheets. Once created, I need to update the workcopy manually to upload changes and redo powerqueries etc from the workcopy is this possible and if so how to do it with or without macros? Thank you

I have 2 workbooks that I have linked together. One takes 2 massive csv files and makes them show ready for the second file. I am currently working on cleaning these files up to make them quicker and cleaner, plus merging in some more from other files. However, when needing to make changes in...

I'm trying to use an XLOOKUP function in Excel referencing a file that is in SharePoint online (aka SharePoint for web) =XLOOKUP(NUMBERVALUE(B9),'https://SERVERNAME.sharepoint.com/sites/XXXStoreDevelopment/Doc...

Hi guys I have a problem, you might be able to help me with. I have two workbooks. I am able to create a macro, which allow me to copy a range(table) from workbook1 and insert it in workbook2. My code is very simple (just an example) workbook1.sheet1.range("xxx").copy...

Hi all, I'm trying to create a single Excel file that links to other files that reference their own sheets. This would be simple enough I think except that I am trying to have all the information contained in one file to show the amount of working. So 'New file' would have sheet links to 'File...

Hi all, I have a new milestone process at work that means I need to archive off all the relevant data at each point so it can be referred back to. We have 3 teams contributing to this which results in the following workbooks: 1. Forecast/Target/Revenue 2. Bill of materials/typical...

I have a spreed Sheet linked to another SS in a different Folder. In "My Computer" the linked Files work.... But If I send the ZIP (Folders and Files) to another computer the Folder Path Link gets Broken... In my Origin The Formula says...

Hi All, My edit links started displaying the full file paths to all linked workbooks in the files list display (screenshot example attached). If I open the linked workbook, the full path goes away but if I close the file again, the full path comes back. This is causing issues if I'm trying to...

I currently have a link on a spreadsheet that will open the source file for when data may need refreshing. How do I get the data to refresh by clicking this link without the source file opening up?

Hi all, I am really struggling to find an answer to my question so hoping someone here might be able to help. I have a set of Excel documents set up as a template for new jobs each time a new job comes in. When we get a new one in I copy and paste the "template" file and rename it as the new...

Hello all, Does anyone know how to auto populate 1 row in excel (Workbook B) from information contained in 2 rows in a separate spreadsheet (workbook A)? Workbook A auto populates daily from a google doc form and workbook B is used for accounting (inputted manually). Do you know how to make...

So generally I am trying to make my text formula work, but as many other methods, this one doesn't work for some reason. =IFERROR('K:\PLANING\Apr\[Thu, Apr 11.xlsb]Millright data'!B7+'K:\PLANING\Apr\[Thu, Apr 11_2.xlsb]Millright data'!B7,'K:\PLANING\Apr\[Thu, Apr 11.xlsb]Millright data'!B7 This...

Dear All, I hope this wonderful forum could help please. I gain alot of experience and knowledge from people on here so firstly a thank you for that. I've looked on the forum but am unable to find the answer the to query below (I may not be wording it correctly). The code I'm trying to...

Is there a way to link workbook files so that workbook A (the master) feeds into workbook 1 & 2 without workbook A always having to be open so you can see the data in workbook 1 & 2? We want to enter the data in the master and have select daily data put into workbook 1 and weekly data put into...

So there are bunch of ways to find where excel file data is pulled from, but I found none to find where data is fed to. I want to rename an excel file, but I want to also make sure other files that are linked to that file will change the file name.

Hi all, I have a legacy macro that is used to read data from an excel file to a linked file to get info in to an Access database. The source files are protected, and I don't know where to find the passwords, but I need to get more of the information out of the source file and in to my database...

Hi folks, The issue I am having is I have tens of thousands of entries in an excel workbook and all of them require different users to put a comment for the ones belong to them. Since there may be up to 100 users accessing the file at the same time, the file has been constantly corrupting. I...

Hi There, I have two workbooks linked to a Master workbook. Any data input into the cells of the first two books, updates in the Master. Everything except for the Comments (Insert Comments, with the little red triangle). Is there a way to have the inserted comments copy over automatically...

Below is the modules I'm trying to get to work. I have added comments in blue where module has troubles. I cannot resolve the issue with having to open the file and also the issues with looping thru the next files. Your help would be greatly appreciated Sub Linkworkbooks() 'Linking...

Hi, I am using following formula in a cell to get data from another workbook. The formula is {=INDEX('D:\Offical\Calculation.xls]Sheet 1'!$B$2:$B$598,SMALL(IF('D:\Offical\Calculation.xls]Sheet 1'!$D$2:$D$598=L$3,ROW('D:\Offical\Calculation.xls]Sheet...