Cell Being Evaluated Contains a Constant

[Rcketfan]

Hello,

I know enough about excel to be dangerous. The issue I have is I have created a worksheet that references another workbook and worksheet. It has been working fine until now. I had to insert a new row and copy the formula from the cell above down to the cell in the new row. This works fine until I need to change the referenced cell i.e. "sheet1!A1" to "sheet1!A4". I hit F2 to edit the cell number, I change A1 to A4 hit enter and instead of it referencing the information from the "sheet1!A4". The formula shows up. So I went to Tools then Formula Auditing then Evaluate Formula it tells me that "The Cell Currently Being Evaluated Contains a Constant"

Like I said I know enough about Excel to screw things up. I would appreciate your help

[Paul]

Most likely the cell that your formula is in is formatted as Text.

To fix this, click on the cell with the formula, then click Format->Cells... and change the format back to General. Click OK to close the dialog box.

Now, on your cell, either double-click or press F2 to enter the cell and then press the ENTER key. This will update your cell format to read the formula as a formula, and not text.

[swatsp0p]

I can think of two things that would cause the formula to show in the cell, neither of which would be caused solely by editing a cell reference.

1) cell is formatted as TEXT
2) Tools>Options>View |Window options| "Show Formulas" is checked.

Good Luck

Bruce

[Paul]

swats, even if Tools->Options->View->Window Options->Formulas was checked, when you go to Evaluate it, the result will work. It's almost certainly a Text formatting issue, as I get the same error when I set up the cell that way.