link between workbooks

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

Good Morning, I have several different files (powerpoint, excel etc). They are all in the same folder. There is one excel file that has a hyperlink to each of these (one file to rule them all), that is also in the same folder. My question is, when the folder is copy and pasted, or downloaded...

I want to copy a worksheet to another workbook where everything is linked. For ex: I have a workbook called "Budget 2016" with a worksheet called "Credit Cards" and a worksheet called "Budget IL & FL". In the "Credit Cards" worksheet I have all info about each credit card like the balance...

First time poster here... I think (?). I love the advice on this site and have used numerous tips. I also have read a few of the Mr. Excel books and trust his expert advice. Thank you in advance for your assistance. Here is my problem that leaves me perplexed....(I am using Excel 2010) I...

Is there a way to use data from a file that has been updated with a different name on the server? Location stays the same, but the name changes somehow. for example: location: G:\...\Quality\data\brackets_26-04-2016.xlsx after _ :date will be changed So there is a possibility there are...

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 having a minor but annoying hiccup on a patch of code. I have cobbled it together from various googlings, but it doesn't function. The goal is to select a file and then to replace the existign file link with the new file selected. If replace 'ExistingLink' in the last line of code and...

Hi there, A theoritical question as I don't actually have the worksheets yet but is it possible to link a cell up to multiple cells on different workbooks if the workbooks don't exist yet? Ie - I want to have a master spreadsheet that tracks the hours people work from their timesheets but they...

Good afternoon, I linked a file to other files that are generated every month to gather results. Just to make sure the formulas were working correctly I created a fake one called '9' for September (9th month). After seeing that it works properly I deleted this fake file but the results stay...

Hi, I currently have a file which has figures and comments, which need to be linked to another workbook. I've pasted as links and that works for the cells however the comments don't carry over. In an effort to do this, i've created some VBA I thought may be useful. I created the function...

Hi all, I have 3 different work books...All 3 are formatted exactly the same. I have one in a network drive at one location, #2 is on a different network drive at a different location and #3 is on the same network/drive as #2. Each workbook is broken down into 28 sheets (1 for each shift days...

As part of an office task organization to keep track of our progress with prospects, we're trying to create a spreadsheet that we can update as needed. This is related to a previous thread I had started, relating to a macro which will sort entries (rows) into other sheets in the workbook...

I apologize if this is covered elsewhere. I searched, but could not find a good solution. Our company uses DropBox to sync and share folders between employees. We store Excel workbooks in these folders. We are having issues when using formulas in one workbook that link to data in another...

Hello, I have recently (in the last month) started using VBA for a work project. My goal is to copy the values of certain cells in one workbook and paste them into what will become a Database like file. The macros were written where the destinations are links. I can break the links and the data...

Hi everyone, I tried a simple search on forums but no answer to my problem poped up. I got this situation: Got circa 20 workbooks created as output form db sotware, so formatting is exactly the same in all of them. Each workbook conains multiple sheets. I Need output in single workbook, with...

I'm trying to link to a workbook but the when I click in the workbook I want to link to, Excel changes the name. Name should read as ='[Example workbook.xlsm]Example Sheet'!A1 but instead, it changes it to read as below ='[Example workbook...m]Example Sheet'!A1 It says "The name that you...

I'm trying to link to a workbook but the when I click in the workbook I want to link to, Excel changes the name. Name should read as ='[Example workbook.xlsm]Example Sheet'!A1 but instead, it changes it to read as below ='[Example workbook...m]Example Sheet'!A1 It says "The name that you...

Hi Excel Hero's, I am using Windows 7 and Excel 2007. I have a list of a couple thousand reports e.g. 123456, 478096, 756842 all in differnt rows in Column A in a summary sheet. I am trying to link a cell from the summary sheet to a cell within each report. This is fine when done manually...

Excel 2007. Trying to create a report workbook that pulls data from other source workbooks, but I would like to be able to disseminate the report workbook to other networks without including the source workbooks as they are massive. Current setup: I am having the report workbook pull data using...

Hello everybody. I have been going crazy over this and although there are multiple threads regarding this problem none of them have helped so far. The Problem: There is a destination sheet that collects data from multiple Source sheets (12 atm, but may become more). The links have mostly been...