Cell reference - displays formula rather then referenced cell

[Guest]

I have Excel 2000, SP3. The spreadsheet has been working fine, but now has a
problem. Multiple users/updaters. We use the formula function to reference
and display the contents of a cell on another worksheet in the same workbook.
When you 1st set up the formula, it works fine. However, if you try to make
any modification to the formula in the cell (select an absolute value ($),
reference a different cell) it will no longer display the referenced cell. It
displays the formula instead. Clearing the cell or deleting the formula does
not help. That cell will no longer display the contents of another cell.
However, if I copy another cell that has never been used over that cell it
will again work, but only once. Once modified, it stops working.

Any Ideas??

thanks

Mike

 

[Guest]

Hello Mike,

Unfortunately I can't help you, bust just wanted to tell that I'm fighting
with the same problem. After making whatever modification to the formulas
they are to be seen as text in the cell. There are 8 sheets in the workbook
and the same bug occurs in every sheet.
Hope anyone could help us!

 

[Guest]

Hi.

Doesn't look good. I found a posting entitled "Excel considers my formulas
as plain text" under the topic "Excel Workbook Functions" posted June '06 and
that string ended w/o a solution.