ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formulas cut and paste but do not compute (https://www.excelbanter.com/excel-worksheet-functions/128287-formulas-cut-paste-but-do-not-compute.html)

Chris

Formulas cut and paste but do not compute
 
When I cut and past even the easiest formula (=A1+B1) The formula pastes
correctly, but the result of the formula in the new cell is the same as the
previous formula in the original cell. Ideas?

Max

Formulas cut and paste but do not compute
 
Enusre that calc mode is set to automatic
Click Tools Options Calculation tab (Options are there)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Chris" wrote:
When I cut and past even the easiest formula (=A1+B1) The formula pastes
correctly, but the result of the formula in the new cell is the same as the
previous formula in the original cell. Ideas?


Chris

Formulas cut and paste but do not compute
 
I knew it was a setting somewhere. I just couldn't find it. THanks, Max.

"Max" wrote:

Enusre that calc mode is set to automatic
Click Tools Options Calculation tab (Options are there)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Chris" wrote:
When I cut and past even the easiest formula (=A1+B1) The formula pastes
correctly, but the result of the formula in the new cell is the same as the
previous formula in the original cell. Ideas?


Max

Formulas cut and paste but do not compute
 
Welcome, Chris !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Chris" wrote in message
...
I knew it was a setting somewhere. I just couldn't find it. THanks, Max.





All times are GMT +1. The time now is 08:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com