Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 2nd 08, 09:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 1
Default math formulaes arent working in excel

I use a spreadsheet to keep track of sick and vacation days and the
spreadsheet math seems to have stopped working. These are very simple
addition and subtraction formulae's and I don't see anything out of the
ordinary.
--
Russ Johnson

  #2   Report Post  
Old May 2nd 08, 09:14 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,440
Default math formulaes arent working in excel

Hi Russ,

What do you mean: "stopped working"?
What happens? What do you see? What did you expect to see?

Check:

ToolsOptionsCalculation tabAutomatic


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Russ Johnson" wrote in message ...
|I use a spreadsheet to keep track of sick and vacation days and the
| spreadsheet math seems to have stopped working. These are very simple
| addition and subtraction formulae's and I don't see anything out of the
| ordinary.
| --
| Russ Johnson


  #3   Report Post  
Old May 2nd 08, 09:19 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default math formulaes arent working in excel

Try

Tools|Options|calculation

select Automatic
Click Ok
Tap F9

Mike

"Russ Johnson" wrote:

I use a spreadsheet to keep track of sick and vacation days and the
spreadsheet math seems to have stopped working. These are very simple
addition and subtraction formulae's and I don't see anything out of the
ordinary.
--
Russ Johnson

  #4   Report Post  
Old May 2nd 08, 09:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 123
Default math formulaes arent working in excel

As Niek has said, automatic calculation may be turned off, so that
Excel will not perform calculation until prompted.

Another common problem that presents itself this way is when another
user accidentally replaces formulas with values by typing over them.

On May 2, 4:09 pm, Russ Johnson
wrote:
I use a spreadsheet to keep track of sick and vacation days and the
spreadsheet math seems to have stopped working. These are very simple
addition and subtraction formulae's and I don't see anything out of the
ordinary.
--
Russ Johnson




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
adding up sheets that arent there yet bouncebackability Excel Worksheet Functions 0 January 10th 08 04:23 PM
Why isn't arent all my case notes transfering in a pivot report? Lorie Excel Discussion (Misc queries) 1 July 6th 07 05:27 AM
Excel Formulaes sandyramanuj Excel Discussion (Misc queries) 4 May 3rd 07 04:19 PM
I must be tired, because basic Math isn't working..... [email protected] Excel Worksheet Functions 0 June 22nd 06 05:30 AM
Why arent my blank cells moved to the end when I do a sort? George New Users to Excel 3 May 31st 06 09:34 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017