I discovered a strange issue when I was trying to copy paste data from Microsoft Excel 2010 to Project 2007. It misses the last number or digit, creating huge errors. I simply can’t make out the cause or fix to it.
I discovered a strange issue when I was trying to copy paste data from Microsoft Excel 2010 to Project 2007. It misses the last number or digit, creating huge errors. I simply can’t make out the cause or fix to it.
This happens. Try doing ‘Paste Special-Text data’. Follow the following steps for that:
1. In Excel, select the data (such as fields, cells, records, or rows) that you want to link or embed, and then click Copy.
2. In Project, on the View tab, click the view that you want.
3. Select the view that you want, and then click Apply.
4. In Project, select the location where you want to insert the data.
5. Right-click to select Paste Special.
6. Select ‘Text Data’ from the list and press OK
It should help.
If nothing works at all, I guess you should take more tedious route. Why don’t you use notepad as a mediator. What I mean is copy paste a column from Excel to notepad and then copy-paste it again to project. This will temporarily help your purpose, I’m sure.
It would have definitely worked if I had only a few data. But the problem is, we have over 1000s of project. Tedious won’t be the word in such a situation. You can very well understand, what I’m trying to explain, I guess.
I have had similar issues and I totally understand what trouble it gets you to. The issue is with MS Project 2007 SP3, remove it. I am quite sure, this will help. I did the same and it worked perfect for me. We are using the Brazilian-Portuguese version. I tested in version with no service pack and "Copy and Paste" worked as expected; But not with SP3.
Bookmarks