1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Copying formulas between workbooks

Discussion in 'Other PC Software' started by aggletonm, 2009/05/28.

  1. 2009/05/28
    aggletonm

    aggletonm Inactive Thread Starter

    Joined:
    2002/05/13
    Messages:
    105
    Likes Received:
    0
    We've only recently started trialling Office 2007. On two devices with SP2 if you try copying a formula between two workbooks it will only paste the value - this is what is going into the clipboard. It's ok if you copy it to the same workbook (on any worksheet). Any ideas?
     
    Last edited: 2009/05/28
    aggletonm,
    #1
  2. 2009/05/28
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    PeteC,
    #2


  3. to hide this advert.

  4. 2009/06/01
    aggletonm

    aggletonm Inactive Thread Starter

    Joined:
    2002/05/13
    Messages:
    105
    Likes Received:
    0
    Pete

    Yes... However I think I've now resolved it. Basically I and the user were opening a new instance of Excel. If you open a new workbook from within the already open instance of Excel it works....... Obviously doesn't like different PIDs.
     
    aggletonm,
    #3

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...