ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My spreadsheet SUM formulas stopped working. Is there any easy rea (https://www.excelbanter.com/excel-discussion-misc-queries/227329-my-spreadsheet-sum-formulas-stopped-working-there-any-easy-rea.html)

Lynn_in_NC

My spreadsheet SUM formulas stopped working. Is there any easy rea
 


francis

My spreadsheet SUM formulas stopped working. Is there any easy rea
 
Hi Lynn

If you didn't write your message in the body of the post,
it is difficult to reply.

To your question, try press F9 key and if it calculate
Go to Tool Options Calculation
click on the Automatic under Calculation

--
Hope this help

Pls click the Yes button below if this post provide the answer you asked




cheers, francis
"Lynn_in_NC" wrote in message
...




Lynn_in_NC

My spreadsheet SUM formulas stopped working. Is there any easy
 
Hi Francis,
Please see post which began on 4/1/09 Named "Formulas won't increment when
dragging..." This person seems to be having the same problem I am having. I
have not been able to try your recommendations yet, but when I do I will
click yes if it helps. Thank you!

"francis" wrote:

Hi Lynn

If you didn't write your message in the body of the post,
it is difficult to reply.

To your question, try press F9 key and if it calculate
Go to Tool Options Calculation
click on the Automatic under Calculation

--
Hope this help

Pls click the Yes button below if this post provide the answer you asked




cheers, francis
"Lynn_in_NC" wrote in message
...





Francis

My spreadsheet SUM formulas stopped working. Is there any easy
 
Hi Lynn

If this doesn't works, would you send your file to me?
I shall see what I can do.
click on my name appear at the top of the post and you
will see my email.

btw, which version are you using?
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Lynn_in_NC" wrote:

Hi Francis,
Please see post which began on 4/1/09 Named "Formulas won't increment when
dragging..." This person seems to be having the same problem I am having. I
have not been able to try your recommendations yet, but when I do I will
click yes if it helps. Thank you!

"francis" wrote:

Hi Lynn

If you didn't write your message in the body of the post,
it is difficult to reply.

To your question, try press F9 key and if it calculate
Go to Tool Options Calculation
click on the Automatic under Calculation

--
Hope this help

Pls click the Yes button below if this post provide the answer you asked




cheers, francis
"Lynn_in_NC" wrote in message
...






All times are GMT +1. The time now is 12:52 PM.

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