G
Grapevine
Hi
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!
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!