Formula Locking?




I have excel 2003. I have made a fairly crucial 3-worksheet workbook with
formulae that speak to each other both within and across worksheets.

Recently the formulae seem to have 'locked'; so if I enter new data in a
reference cell (say, an exchange rate), normally all values shd change
dynamically - as they did before countless times in this book.

Now nothing happens. The formulae stubbornly return the values from before.

When I enter a fresh formula on the same worksheet it calculates correctly -
but does not respond to updated data in reference cell - ie as above.

Any answers? Hope it's simple, pretty desperate!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question