File Link

[krishnan4u2001]

I have a problem related File links. I cannot get right. Can some one
tell me how to write these.

I have 3 files - Test01, Test 02, Test 03

Test01 linked to Test02 and test02 linked to Test03.

All the files in the network drive.

Instead of opening all the files, some users opening the file
test01 only and are making updates,

So I am getting the incorrect results in test03.

Is there anyway to arrest this?

Regards,

Krishnan

 

[John]

Hi Krishnan,

I've had this problem before and I think there is actually
no way of avoiding it. The only solution I had was to
combine my three files into one file, (hiding relevant
sheets from the relevant people).
But maybe you can't allow this in your situation!

The problem is there is no way of updating a file (just
using a link) when the file that needs to be updated is
not open.

I'll be watching this post to see if there are any real
solutions.!

John.