View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JCBang JCBang is offline
external usenet poster
 
Posts: 1
Default 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