Results 1 to 3 of 3

Thread: Paste Special function does not work when I copy formulas in Excel

  1. #1
    Join Date
    Jan 2011
    Posts
    26

    Paste Special function does not work when I copy formulas in Excel

    I am using Excel 2007 and I can't seem to copy and paste formulas from one workbook to another. Instead I get a dialogue box asking me if I want to use paste or paste link and to chose from a list of formats. Does anyone know if there is something that I can change in Excel to fix this problem.

  2. #2
    Join Date
    Aug 2011
    Posts
    695

    Re: Paste Special function does not work when I copy formulas in Excel

    It sounds like you have the workbooks open in separate instances of excel. Close one of the workbooks (and its instance of excel) and then back to the first workbook/excel. Hit ctrl-o and open your second workbook and try the copy|paste.

  3. #3
    Join Date
    Aug 2011
    Posts
    566

    Re: Paste Special function does not work when I copy formulas in Excel

    Are both workbooks open in the same instance of Excel. I find it difficult to know when that it is actually the case. To be sure, I use File > Open to open the second workbook instead of clicking on the file icon.

Similar Threads

  1. Replies: 5
    Last Post: 26-04-2012, 04:16 AM
  2. Cut/Copy/Paste function is working very slow in Excel 2007
    By Rounder1 in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 07:32 PM
  3. How to do Copy/Paste on protected work sheet in Microsoft Excel
    By Chini mao in forum MS Office Support
    Replies: 1
    Last Post: 14-01-2012, 06:58 PM
  4. How to use Paste Formulas between Excel Sheet without any link
    By Celestial in forum MS Office Support
    Replies: 3
    Last Post: 11-01-2012, 04:08 PM
  5. Replies: 0
    Last Post: 18-03-2009, 10:00 PM

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,670,518,359.86624 seconds with 17 queries