Links Not Updating

[mouse88]

Usually If I have a workbook in a folder ("CO.XLS") and this workbook has a link to another workbook in the same folder ("SUMMARY.XLS") when I copy the folder it will automatically look for the linked workbook one directory back.

I have tried this today and when I copy the folder it is still looking for the linked workbook in the original folder.

The links are in an INDEX MATCH formula.

Anyone have any ideas why this might be?

The below image shows the folder structure. The CO.XLS workbook links to the various SUMMARY.XLS workbooks.

 

[GlennUK]

But those summary workbooks are not in the same folder as CO.XLS according to that diagram. Care to explain?

 

[mouse88]

Basically I wanted the links to update to point to the right month folder.

I have realised now that this will only work if the CO.XLS workbook is in the same folder as the SUMMARY.XLS workbooks.

 

[lundbhaiz]

But those summary workbooks are not in the same folder as CO.XLS according to that diagram. Care to explain?

is it necesary for the workbooks to be in dsame folder for links to automatic updates ? what if these are located in same folder but different subfolders ? thansk you very much for information sir.

 

[GlennUK]

is it necesary for the workbooks to be in dsame folder for links to automatic updates ? what if these are located in same folder but different subfolders ? thansk you very much for information sir.

If you want links to be maintained when copying workbooks and their supporting information, you need to ensure that the supporting information is in the same folder, or in subfolders under the main reporting folder, in order for the links to operate automatically after copying.

When copying, copy the files into the same folder structure that they came from.

 

[mouse88]

Thats exactly what I did but it would not update.

It will only work with this structure:

January Folder > CO.XLS
> 01 > SUMMARY.XLS
> 03 > SUMMARY.XLS
> 04 > SUMMARY.XLS
> 05 > SUMMARY.XLS

 

[GlennUK]

Mouse,

Your directory structure does not have the supporting data in the same folder as the reporting workbook, or in folders under that folder. How can that be exactly what I described?

 

[mouse88]

They do.

You have the January folder. Within this you have a Colchester folder and a Phone Data Folder. In the Colchester folder you have CO.XLS. In the phone data folder you have folders from 01 to 31. Each of these folders has a SUMMARY.XLS workbook.

The CO.XLS workbook links to all 31 of these SUMMARY.XLS workbooks.

All I want to do is copy the January folder for february and have the links in the CO.XLS update to point to the various SUMMARY.XLS workbooks in the February folder but they still point to the January folder.

 

[GlennUK]

They do.

They DO NOT.

Your diagram told me this. Now you have provided a full description, that confirms it.

The CO.XLS is in the Colchester folder ... the data is under the PHONE DATA folder, which is a different folder. I don't see how I make it any clearer ... those are different folders!!!

To reiterate, I said:
you need to ensure that the supporting information is in the same folder, or in subfolders under the main reporting folder.
( main reporting folder means the folder containing the workbook with the links ... i.e. the Colchester folder ).

 

[GlennUK]

Here is a folder structure that would work:

Excel Workbook
	B	C	D	E	F	G	H	I	J
2	JANUARY		COLCHESTER
3
4						PHONE DATA			01
5
6
7									02
8
9
Sheet