Results 1 to 7 of 7
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,824
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Pasting values between multiple Excel sessions (Excel2003)

    Are there any guidelines/best practices available for copying/pasting data values between Excel workbooks opened in different Excel sessions?

    I want to paste values (not formats) from one workbook to another, with each workbook opened in its own Excel session/instance.

    zeddy

  2. #2
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting values between multiple Excel sessions (Excel2003)

    Hi Zeddy,
    In my experience, paste as special values is not an option when copying data between different instances of excel. I rarely ever work with more than one excel session for this very reason. It can be a pain, but I am not aware of any workarounds.

    Added later: I suppose you could copy and paste as special values to a blank workbook / worksheet in the same session to lose the formatting and then paste to your other session. Unless there are easier alternatives known by more experienced loungers than I <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting values between multiple Excel sessions (Excel2003)

    Why multiple sessions?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,824
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Re: Pasting values between multiple Excel sessions (Excel2003)

    Hi Nathan

    Problem resolved.
    It seemed to matter how I opened the other Excel files.
    In my particular case, I have a SAP version of Excel running.
    SAP Excel will not allow you to open another Excel file using the File->Open command.
    This function is disabled.
    If I had another Excel running first, they were 'disconnected'.
    The PasteSpecial->Values option was not available in the SAP Excel.

    However, if I start the SAP Excel and then use Explorer to browse, and use Explorer to open my other Excel files I find:
    1. The other Excel files will now show up when selecting Window in the command bar of the SAP Excel.
    2. The SAP Excel will not allow you to switch to another file listed under the Window.
    3. But you can switch to the other Excel file via the Windows Taskbar, copy some data to the clipboard.
    4. Come back to the SAP Excel and, unexpectedly, the PasteSpecial->Values command was now available.

    In the circumstances, that will do for me!

    zeddy

  5. #5
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Pasting values between multiple Excel sessions (Excel2003)

    That's a handy tip for other people running Excel from SAP. Thanks for sharing.

    StuartR

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,824
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Re: Pasting values between multiple Excel sessions (Excel2003)

    Hi Jan

    In my particular case there is no choice when running SAP Excel.

    I can imagine other circumstances when you may wish to view multiple independant Excel files on an extended i.e. multi-monitor desktop.

    zeddy

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting values between multiple Excel sessions (Excel2003)

    Yes, I saw your other message about SAP Excel when I had just posted my question.

    A bit silly SAP Excel tries to keep you from opening other files in it (and obviously fails to do so properly <vbg>).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •