David,

It is difficult to envisage your problem. On sheet1 I entered a simple
formula in A1
Code:
--------------------
=B1*Sheet2!A1
--------------------


I then entered a constant in B1 before selecting the whole sheet and
locking and hiding the cells. I protected the sheet and removed all
ability to select any cells.

I then changed the data in A1 on Sheet2 and Sheet1 updated OK as I
would expect

If it would help I am willing for you to post me a copy of your sheet.


---
Message posted from http://www.ExcelForum.com/