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
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.
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
Bruce
The older I get, the better I used to be.
Minneapolis, MN USA
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks