Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 8th 07, 06:04 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 2
Default CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP

Multiple wkshts same problem- formulas in cells are correct but the value
doesn't chg. I have to go to the formula line and click on it and then on
the ck mark to recalculate the formula. If I copy formulas across to
multiple cells the correct formula copies across but the value of the cell
copied appears in the cell. Is there something I need to disable/enable in
EXCEL? Help!!!

  #2   Report Post  
Old February 8th 07, 06:11 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP

It sound like you need to use"
Tools | Options; open Calculation tab; set Automatic ON
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sherberg" wrote in message
...
Multiple wkshts same problem- formulas in cells are correct but the value
doesn't chg. I have to go to the formula line and click on it and then on
the ck mark to recalculate the formula. If I copy formulas across to
multiple cells the correct formula copies across but the value of the cell
copied appears in the cell. Is there something I need to disable/enable
in
EXCEL? Help!!!



  #3   Report Post  
Old February 8th 07, 06:20 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 2
Default CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? H

THANK YOU SO MUCH!! THAT JUST SAVED ME DOUBLE TIME ON THE SPREADSHEET.
THANK YOU AGAIN


"Bernard Liengme" wrote:

It sound like you need to use"
Tools | Options; open Calculation tab; set Automatic ON
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sherberg" wrote in message
...
Multiple wkshts same problem- formulas in cells are correct but the value
doesn't chg. I have to go to the formula line and click on it and then on
the ck mark to recalculate the formula. If I copy formulas across to
multiple cells the correct formula copies across but the value of the cell
copied appears in the cell. Is there something I need to disable/enable
in
EXCEL? Help!!!




  #4   Report Post  
Old February 8th 07, 06:24 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? H

You are very welcome.
But please turn down the volume - caps in email is considered to be
shouting.
all the best
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sherberg" wrote in message
news
THANK YOU SO MUCH!! THAT JUST SAVED ME DOUBLE TIME ON THE SPREADSHEET.
THANK YOU AGAIN


"Bernard Liengme" wrote:

It sound like you need to use"
Tools | Options; open Calculation tab; set Automatic ON
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sherberg" wrote in message
...
Multiple wkshts same problem- formulas in cells are correct but the
value
doesn't chg. I have to go to the formula line and click on it and then
on
the ck mark to recalculate the formula. If I copy formulas across to
multiple cells the correct formula copies across but the value of the
cell
copied appears in the cell. Is there something I need to
disable/enable
in
EXCEL? Help!!!






  #5   Report Post  
Old September 11th 07, 01:34 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 39
Default CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? H



"Bernard Liengme" wrote:

It sound like you need to use"
Tools | Options; open Calculation tab; set Automatic ON
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sherberg" wrote in message
...
Multiple wkshts same problem- formulas in cells are correct but the value
doesn't chg. I have to go to the formula line and click on it and then on
the ck mark to recalculate the formula. If I copy formulas across to
multiple cells the correct formula copies across but the value of the cell
copied appears in the cell. Is there something I need to disable/enable
in
EXCEL? Help!!!



Thanks! I was searching for the same answer Sherberg. Someone at my office had been using a spreadsheet I created and she somehow got into that option and set it for manual calc and didn't know what she had done. Thanks again - most helpful!



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
Return Matched Numeric Values across Rows Sam via OfficeKB.com Excel Worksheet Functions 2 January 2nd 07 11:03 PM
How to Identify Values in Common Between 2 cells ahofeld Excel Discussion (Misc queries) 1 July 21st 06 07:36 PM
How to change column letters to correct ones in many formulas automatically? Dmitry Kopnichev Links and Linking in Excel 7 October 13th 05 09:52 PM
How to change column letters to correct ones in many formulas automatically? Dmitry Kopnichev Excel Worksheet Functions 7 October 13th 05 09:52 PM
Correct formulas in cells, have to retype to work budsb1 Excel Discussion (Misc queries) 3 March 5th 05 11:45 AM


All times are GMT +1. The time now is 06:17 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017