Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Paste Special Multiply Formulas not working in Excel 2007

Not sure if anyone else uses this, but in 2003 you can copy a cell whose
formula is '=$A$1' then paste special multiply formula onto a second cell or
range of cells. If the second cell's value was 100 before the paste special,
the new formula after the paste special will be =(100)*$A$1. In effect it
converts a value to a formula of the value times another cell.

This is a very handy function that doesn't seem to work in 2007. Instead it
does the same thing as a paste special multiply values. If my A1 cell equals
10, it would return 1000 in the formula rather than =(100)*$A$1.

Is this a bug? Did they remove the functionality? Is there a fix? Any help
would be greatly appreciated!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,123
Default Paste Special Multiply Formulas not working in Excel 2007

Hi el_guapo

This bug is reported a fe months ago.
There is no known workaround

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"el_guapo" wrote in message ...
Not sure if anyone else uses this, but in 2003 you can copy a cell whose
formula is '=$A$1' then paste special multiply formula onto a second cell or
range of cells. If the second cell's value was 100 before the paste special,
the new formula after the paste special will be =(100)*$A$1. In effect it
converts a value to a formula of the value times another cell.

This is a very handy function that doesn't seem to work in 2007. Instead it
does the same thing as a paste special multiply values. If my A1 cell equals
10, it would return 1000 in the formula rather than =(100)*$A$1.

Is this a bug? Did they remove the functionality? Is there a fix? Any help
would be greatly appreciated!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What happened to paste special in Excel 2007? Louis Excel Discussion (Misc queries) 6 March 6th 08 08:59 AM
Paste Special - Formulas - Multiply [email protected] Excel Discussion (Misc queries) 4 February 4th 08 03:45 PM
Paste Special in Excel 2007 Gren Excel Discussion (Misc queries) 0 January 15th 08 05:52 PM
Paste Special, Text in Excel 2007 Vernon Balbert New Users to Excel 13 November 4th 07 08:18 PM
paste special not working in excel Lisa Excel Queen Excel Discussion (Misc queries) 1 June 5th 06 06:56 PM


All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"