Dear all,

I have been at this but with no success. For eg. I copy a chart or select some highlighted cells and paste special - link to Powerpoint, the link is ok.

However, whenever, I try to send out both the Excel and Powerpoint file to another user or use manual method such as copy and paste (my local drive to memory stick and then to other users local drive), the links does not automatically detect the change in the file location and thus a link update failure.

It is even more fustrating when I need to rename the Excel file.

Does anyone has a better way to manage paste special link

Cheers,
CL