Use of a excel copy file

[Constant]

.
Hi everyone,

I have a very important excel file who's have links to several other excel files.

As it is very important I make a copy on an external disk every day in case of...

Now, two days ago it happens; my master files crashed!

I took the backup copy and replace it in the corresponding directory of the master file.

My surprise is that I can't use it because all the links addresses are changed and not usable.

I edit that the links and change the source to the right files but I save the "restored" file it do it with the changed links and every time I reload the file I must rebegin this circus.

Can someone help me?

Thanks in advance

C. Peten from Bruges in Belgium

 

[SirJB7]

Hi, Constant!

Well, Excel behaves a little weird with links.

If you happened to open the backup file from the alternative place where it was stored you might have notice that linked addresses kept the original cell range and path, but the drive got changed to the actual drive of the opened file.

If you restored (copied, moved, etc.) the backup file to the original drive (same letter, not necessarily same physical device) then you shouldn't have problems.

Use the attached files for testing, C file has links to A & B files. Change the sources the first time, save C, then move C to other folders on same device and to other folders on other devices and see what happens.

Regards!

 

[Constant]

Thank you for your tips. I did some tests and I solved the problem but I am still looking for some logic behind this behaviour.
Regards from Bruges in Belgium

 

[SirJB7]

Hi, Constant!
If you want to share the solution with the community, you're welcome. It may help other people who step into this problem.
Regards!