Copy and Paste Special in Excel #REF error

Discussion in 'Project' started by Karina Hernandez, Mar 24, 2016.

  1. Karina Hernandez

    Karina Hernandez

    Joined:
    Mar 24, 2016
    Messages:
    1
    Likes Received:
    0
    Hi everybody,
    I could really use your help. We have stored several Project files in Sharepoint (Project Server) that contain Start and End Dates of Installation of equipment. Most of the users in our factory find Project too difficult to manage and we want to create an Excel file that "pulls" the info from the Project in Server and updates itself in case any change was done to the Project file (This way, the excel file is always updated!)

    I have tried the "copy + Paste Special - Link Text" solution and it works fine. It does bring the information from Project into Excel, however, when opening again the Excel and Project, if I click on the button "Update" I see the #REF error in all cells with imported info. If I choose "Don't update" links are still functional (But what is the purpose of links, if they won't update?)

    Anybody having same issue? PLEASE HELP!
     
    Karina Hernandez, Mar 24, 2016
    #1
    1. Advertisements

  2. Karina Hernandez

    ChrisJ

    Joined:
    Apr 13, 2016
    Messages:
    4
    Likes Received:
    3
    Hello Karina,

    I am not sure whether it would really help, however, you can try the following:

    After you "copy + Paste Special - Link Text", Copy once again + Paste Special + Paste Values. And then try the update option and check what happens.

    All the best.
     
    ChrisJ, Apr 15, 2016
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Solliss

    Project - paste link problem

    Solliss, Jul 20, 2011, in forum: Project
    Replies:
    0
    Views:
    1,015
    Solliss
    Jul 20, 2011
  2. da_raw1

    Importing Excel Into Project

    da_raw1, Sep 20, 2011, in forum: Project
    Replies:
    1
    Views:
    477
    cookieheadjenkins
    Nov 11, 2011
  3. luke
    Replies:
    0
    Views:
    3,448
  4. blueburn97

    Incorrect dates when copying from Excel

    blueburn97, Apr 22, 2012, in forum: Project
    Replies:
    0
    Views:
    700
    blueburn97
    Apr 22, 2012
  5. mfarif2

    Step to generate s curve in excel

    mfarif2, May 3, 2012, in forum: Project
    Replies:
    0
    Views:
    1,124
    mfarif2
    May 3, 2012
  6. PharmaProject

    Error with Copy Picture to Wizard (2003)

    PharmaProject, Jul 6, 2012, in forum: Project
    Replies:
    0
    Views:
    514
    PharmaProject
    Jul 6, 2012
  7. Dan Beisel
    Replies:
    0
    Views:
    454
    Dan Beisel
    Feb 14, 2013
  8. coupling

    Copy with delay

    coupling, Oct 22, 2015, in forum: Project
    Replies:
    0
    Views:
    319
    coupling
    Oct 22, 2015
Loading...