Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-02-2012
Member
 
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.

Reply With Quote
  #2  
Old 24-02-2012
Member
 
Join Date: Aug 2011
Posts: 690
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.
Reply With Quote
  #3  
Old 24-02-2012
Member
 
Join Date: Aug 2011
Posts: 564
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Paste Special function does not work when I copy formulas in Excel"
Thread Thread Starter Forum Replies Last Post
I cannot do Copy and Paste or Paste Special between Excel Workbooks Acca-OR Windows Software 5 26-04-2012 04:16 AM
Cut/Copy/Paste function is working very slow in Excel 2007 Rounder1 MS Office Support 2 24-02-2012 07:32 PM
How to do Copy/Paste on protected work sheet in Microsoft Excel Chini mao MS Office Support 1 14-01-2012 06:58 PM
How to use Paste Formulas between Excel Sheet without any link Celestial MS Office Support 3 11-01-2012 04:08 PM
Copy Text from One Cell to Another in Microsoft Excel without copy & paste Computer_Freak Tips & Tweaks 0 18-03-2009 10:00 PM


All times are GMT +5.5. The time now is 03:26 PM.