One cell isn't recognized?
 

Orginally, I had some formulas pull some data over from another spreadsheet,
for some reason on cell was not being recognized. I have a total at the
bottom for the column.

So, I copy and pasted the values and still no total.

I checked my total formula, reentered it, and messed with the text/number
settings, and checked to see if the cells were locked, etc.

What could possibly be keeping this cell from being recognized?

Thank you.

One cell isn't recognized?
 

Press F9 to see if the workbook is on manual recalc. You can also peruse
the status bar and the indicator CALC is visible you're on manual. To reset
back to automatic do the following:

Click TOOLS in the menu & select OPTIONS

Click the CALCULATION tab and click the AUTOMATIC option button, click OK
when done.
--
Kevin Backmann


"LiveUser" wrote:

Orginally, I had some formulas pull some data over from another spreadsheet,
for some reason on cell was not being recognized. I have a total at the
bottom for the column.

So, I copy and pasted the values and still no total.

I checked my total formula, reentered it, and messed with the text/number
settings, and checked to see if the cells were locked, etc.

What could possibly be keeping this cell from being recognized?

Thank you.

One cell isn't recognized?
 

Kevin B,

It is on automatic, but there is no change. What is odd is I have been using
this same template on each worksheet in the workbook and no other sheet has
had this issue. I created this sheet just as I did the others.



"Kevin B" wrote:

Press F9 to see if the workbook is on manual recalc. You can also peruse
the status bar and the indicator CALC is visible you're on manual. To reset
back to automatic do the following:

Click TOOLS in the menu & select OPTIONS

Click the CALCULATION tab and click the AUTOMATIC option button, click OK
when done.
--
Kevin Backmann


"LiveUser" wrote:

Orginally, I had some formulas pull some data over from another spreadsheet,
for some reason on cell was not being recognized. I have a total at the
bottom for the column.

So, I copy and pasted the values and still no total.

I checked my total formula, reentered it, and messed with the text/number
settings, and checked to see if the cells were locked, etc.

What could possibly be keeping this cell from being recognized?

Thank you.