Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Paste special problem (Excel 202)

    Hi
    I'm trying to copy a column with formulas to a column in another excel file using paste special option but insted of getting an option whether i was to paste values or only formulas etc, i am getting this type of option showed in the attached picture below. Why am i getting that option and is there a way to correct it?
    Any suggestion in this regard will be higly appreciated.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Paste special problem (Excel 202)

    The 2 workbooks are open in separate instances of excel. Paste values/formulas come when you have opened them up in the same instance

    Steve

  3. #3
    New Lounger
    Join Date
    Jan 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste special problem (Excel 202)

    Thanks Steve. But could you illustrate more on this. How can i open the two worksheets in same instance?
    Thanks

  4. #4
    New Lounger
    Join Date
    Jan 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste special problem (Excel 202)

    Alright i got it!

Posting Permissions

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