Results 1 to 5 of 5

Thread: Facing difficulty in copy pasting from Excel 2010 to Project 2007

  1. #1
    Join Date
    Aug 2010
    Posts
    129

    Facing difficulty in copy pasting from Excel 2010 to Project 2007

    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.

  2. #2
    Join Date
    Jul 2010
    Posts
    23

    Re: Facing difficulty in copy pasting from Excel 2010 to Project 2007

    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.

  3. #3
    Join Date
    Jul 2010
    Posts
    26

    Re: Facing difficulty in copy pasting from Excel 2010 to Project 2007

    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.

  4. #4
    Join Date
    Aug 2010
    Posts
    129

    Re: Facing difficulty in copy pasting from Excel 2010 to Project 2007

    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.

  5. #5
    Join Date
    Jul 2010
    Posts
    59

    Re: Facing difficulty in copy pasting from Excel 2010 to Project 2007

    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.

Similar Threads

  1. Cutting and pasting in MS Project
    By E Quigley in forum Windows Software
    Replies: 1
    Last Post: 29-11-2012, 11:45 AM
  2. Can we print notes in Project 2007 or Project 2010?
    By Akau# in forum Microsoft Project
    Replies: 2
    Last Post: 26-03-2012, 06:14 PM
  3. How to open a MS project 2007 file in MS project 2010
    By pqmot in forum Windows Software
    Replies: 3
    Last Post: 30-12-2010, 04:41 PM
  4. Replies: 3
    Last Post: 10-11-2010, 07:27 PM
  5. Project Pro 2010 with Project Server 2007
    By counselor in forum Microsoft Project
    Replies: 2
    Last Post: 27-04-2010, 05:28 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,712,361.70988 seconds with 17 queries