links between workbooks

I have several linked workbooks in various folders, some of which have the same names. I want to move them all into the same folder, make the names unique where necessary, and automatically update the links. The simplest way I can think of is: In Windows, move [and rename) each workbook into...

Hi! I store weekly reports in a folder. A summary excel spread sheets gets cell information form these weekly reports. I would like to use a cell in the summary report to guide which weekly report that is showed in the summary file. The link in my summary report look something like...

Hi all, I am working on an Excel 2013 workbook and there is a link that has appeared in my workbook, and I cannot remove it for the life of me. There is a link to an external sheet (lets call it sheet 'B') , I believe this link came about because a college copied a number of cells from this...

I attempted to copy the cells (which had formulas) from one workbook worksheet into another workbook worksheet. It didn't paste properly, so I deleted it and resolved to enter the formulas I needed manually one by one. The formulas reference values in other worksheets within the same workbook...

Hi I have a spreadsheet that contains property costs and have created a pivot table for this data. I also have hundreds of seperate workbooks for individual properties that feed off the costs pivot table by way of an =GETPIVOTDATA formula. The issue I am having is that when I update the cost...

Hi all, hope someone can help me please. I have 2 workbooks that are linked together. Book1 pulls information from Book2 and displays it in a table and graph for colleagues to use. Book 2 is password protected so that only I can view the details in it. The password is currently "lion". When...