If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
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.
To give a virtual "pat on the back" click the icon in the gray toolbar from that user's post.
To report abuse, spam or offensive posts, please click the icon.
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.
To give a virtual "pat on the back" click the icon in the gray toolbar from that user's post.
To report abuse, spam or offensive posts, please click the icon.
icon in the gray toolbar from that user's post.
icon.
Linear Mode
