| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Won't Paste Formulas
I have two different workbooks in Excel 2007. I'm trying to copy the formula
from one over to the other one. When I paste it in the second workbook, it pastes the values not the formula. If I expand the Paste menu, Formulas is grayed out. The only options are Paste and Paste Special. When I choose Paste Special its like Excel thinks I'm trying to paste an object. Please help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2007 Won't Paste Formulas
Your two workbooks are open in separate instances of Excel and will not
communicate. Close one instance and open both workbooks in a single instance of Excel. Gord Dibben MS Excel MVP On Wed, 9 Dec 2009 10:37:01 -0800, lhodgdon wrote: I have two different workbooks in Excel 2007. I'm trying to copy the formula from one over to the other one. When I paste it in the second workbook, it pastes the values not the formula. If I expand the Paste menu, Formulas is grayed out. The only options are Paste and Paste Special. When I choose Paste Special its like Excel thinks I'm trying to paste an object. Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste Special Multiply Formulas not working in Excel 2007 | Excel Worksheet Functions | |||
| Paste EXCEL 2007 sheet into WORD 2007 - objects move around | Excel Discussion (Misc queries) | |||
| Cut, paste excel formulas to new worksheet | Excel Discussion (Misc queries) | |||
| how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
| how do I paste formulas in excel clipboard? | Excel Discussion (Misc queries) | |||
Linear Mode
