Loading...
Quick Links

Reply To: copy and paste Excel 2010 to MS Project 2013

Home Forums Discussion copy and paste Excel 2010 to MS Project 2013 Reply To: copy and paste Excel 2010 to MS Project 2013

#413749
Vivek
Guest

I was able to solve this. However, this is really crazy…not sure why Microsoft did not test it OR maybe the developer did test it and did not publish the test result to hide his/her ignorance. The solution:
1. Select the text from Excel and do ‘Copy’
2. Within Excel, go to another sheet and do ‘Paste Special – Values’
3. Then select the text from the new location and do ‘Copy’ again
4. Go to MS Project, and do ‘Paste’ in the cell
5. This will copy the text in MS Project
The only reason I can think of is that new Excel (2013) has bunch of hidden formatting attached to Excel cells and MS Project does not recognize that formatting and therefore cannot paste it. Considering both are Microsoft products, you would think that they would have designed the use case for this scenario.