Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special Formula Multiply feature doesn't work anymore
Has anyone noticed that the "Paste Special - Formula - multiply" feature
does not work and it works instead the same as "Paste Special - Values - multiply"? In Excel in 2003 I was able to copy a formula like '=$A$1' then "Paste Special - Formula - multiply" onto a second cell (call it A2=$Z$1) and get a new formula in A2 = $Z$1*$A$1. Example: Z1 = 5 A1 = $Z$1 A2 = 100 Copy cell A1 & click cell A2 In Excel 2003, "Paste Special - Formula - multiply" would result in cell A2 becoming =100*$Z$1 In Excel 2007, "Paste Special - Formula - multiply" is resulting in cell A2 becoming =500 (inherent calc being 100*5) This suggests that Excel 2007 has a bug in feature "Paste Special - Formula - multiply" because it works instead as Excel 2007, "Paste Special - Values - multiply" Has anyone found a solution from Microsoft. I can create a macro but I use to use that feature a lot and don't want to create a macro every time. Help will be appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help: paste special with an operation (add, multiply,...)converts everything to values, pasted formulas & links are lost | Excel Discussion (Misc queries) | |||
Paste Special Multiply Formulas not working in Excel 2007 | Excel Worksheet Functions | |||
Paste Special - Formulas - Multiply | Excel Discussion (Misc queries) | |||
Can't Access Paste Special Anymore | Excel Worksheet Functions | |||
why don't my functions in paste special work? | Excel Worksheet Functions |