Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LL LL is offline
external usenet poster
 
Posts: 13
Default Copying a formula but only getting the result

I'm trying to copy a formula in my spreadsheet but when I copy it doesn't
copy the formula to another cell, it copies the result of that formula to the
cell I'm trying to copy to. I've tried paste special and choosing formula
only but it still copies the result. Please help. I have too many cells to
copy to and can't re-enter my formulas in every cell. What am I doing wrong?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Copying a formula but only getting the result

Check and make sure calculation is set to automatic:

ToolsOptionsCalculation tabAutomaticOK

It might also be that your formula uses absolute references so the result
will always be the same. You didn't post the formula so I can't tell!

--
Biff
Microsoft Excel MVP


"LL" wrote in message
...
I'm trying to copy a formula in my spreadsheet but when I copy it doesn't
copy the formula to another cell, it copies the result of that formula to
the
cell I'm trying to copy to. I've tried paste special and choosing formula
only but it still copies the result. Please help. I have too many cells to
copy to and can't re-enter my formulas in every cell. What am I doing
wrong?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LL LL is offline
external usenet poster
 
Posts: 13
Default Copying a formula but only getting the result

Thank You so much!! That fixed it!

"T. Valko" wrote:

Check and make sure calculation is set to automatic:

ToolsOptionsCalculation tabAutomaticOK

It might also be that your formula uses absolute references so the result
will always be the same. You didn't post the formula so I can't tell!

--
Biff
Microsoft Excel MVP


"LL" wrote in message
...
I'm trying to copy a formula in my spreadsheet but when I copy it doesn't
copy the formula to another cell, it copies the result of that formula to
the
cell I'm trying to copy to. I've tried paste special and choosing formula
only but it still copies the result. Please help. I have too many cells to
copy to and can't re-enter my formulas in every cell. What am I doing
wrong?




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Copying a formula but only getting the result

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"LL" wrote in message
...
Thank You so much!! That fixed it!

"T. Valko" wrote:

Check and make sure calculation is set to automatic:

ToolsOptionsCalculation tabAutomaticOK

It might also be that your formula uses absolute references so the result
will always be the same. You didn't post the formula so I can't tell!

--
Biff
Microsoft Excel MVP


"LL" wrote in message
...
I'm trying to copy a formula in my spreadsheet but when I copy it
doesn't
copy the formula to another cell, it copies the result of that formula
to
the
cell I'm trying to copy to. I've tried paste special and choosing
formula
only but it still copies the result. Please help. I have too many cells
to
copy to and can't re-enter my formulas in every cell. What am I doing
wrong?






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
Odd result when copying functions Ron Rosenfeld Excel Worksheet Functions 0 May 8th 08 08:20 PM
copying the Hyperlink function result without copying the actual formula mcheng Excel Worksheet Functions 2 June 9th 07 03:43 AM
Copying result of formula into another worksheet??? Amanda Excel Discussion (Misc queries) 3 April 15th 05 10:40 PM
How do I copy a result without copying the formula? riffmastr7 Excel Discussion (Misc queries) 1 February 2nd 05 08:10 PM
copying a formula, the reference adjusts, but the result does not chezoo Excel Discussion (Misc queries) 1 January 12th 05 02:51 AM


All times are GMT +1. The time now is 11:57 AM.

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

About Us

"It's about Microsoft Excel"