Hector

I have found that if I place the files on the second machine in a folder of
*exactly* the same name as they were created in then the links between the
files are maintained. This is enough for my purposes.

For interest I have just spent some 90 mins trying to understand why I
cannot execute your code in the immediate window but with no luck.

? Activesheet.Name

works fine although Intellisense does not kick in whereas it does for

? ActiveWorkbook.Name

I also found that

? activesheet.pivottables(1)

works ok

So, I am confused and frustrated but, as I said at the top, I do have a way
forward. I think I'll leave it at that and not take up any more of your time.

Many thanks for you help. Peter

"Héctor Miguel" wrote:

hi, Peter !

I must be being very silly but that is exacly what I did and I have tried it again but still with the same error message.
I am definitely in the Immediate window
? 4+5
returns 9 and I was on the sheet with the pivot table when entered vbe.
This is so frustrating as what you suggest seems to be the way to go.
Any other thoughts? ...

revise in vba-editor (menu) tools / references...

(perhaps) missed or crossed references to object libraries in the vba project ?

hth,
hector.