Paste special from MS Project to Excel does not always work??
 

I have an excel sheet which has to show data from several MS project files
which are continously being updated.
The way I have it set up now is that I copy from MS Project and then "paste
special link text" into excel. Sometimes it works and sometimes it does not.
It seems that excel is trying to re-use the same link numbers and whenever
there are two identical link numbers it does not work. Even when the path and
the file name are different.
It keeps re-using numbers from 22 upwards.

Has anybody ever encountered the same problem?

Thanks

JCBang