| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
When I copy a formula to another cell, I get the value of the ori.
I am now having a problem that has never happened before. When I copy a
formula from one cell to another, the copied cells show the value of the original cell. I have tried the special paste option and that doesn't work either. How can I fix this? Help |
|
#2
|
|||
|
|||
|
Toolsoptionscalcualtion set it to automatic
-- Regards, Peo Sjoblom "queenie" wrote in message ... I am now having a problem that has never happened before. When I copy a formula from one cell to another, the copied cells show the value of the original cell. I have tried the special paste option and that doesn't work either. How can I fix this? Help |
|
#3
|
|||
|
|||
|
queenie
You can probably fix it by going to ToolsOptionsCalculation and selecting "Automatic" Gord Dibben Excel MVP On Fri, 18 Feb 2005 08:17:02 -0800, "queenie" wrote: I am now having a problem that has never happened before. When I copy a formula from one cell to another, the copied cells show the value of the original cell. I have tried the special paste option and that doesn't work either. How can I fix this? Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy a formula as text to another cell? | Excel Discussion (Misc queries) | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
| HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
| When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
Linear Mode
