Carol,

If you are talking about worksheet formulas - you should be able to click in
the formula bar (where the formula is displayed), position the cursor, and
type away (even jump around in the formula and change this and that), then
hit Enter. And the formula should now be the way you want.
If you go back to the cell - you should see your 'new' formula in the
formula bar.

After this - saving should hold the formulas.

EXCEPT if there is code somewhere in the workbook that rewrites the
formulas. Than you need to go into the VB module and make the changes
there.

To make your search for formulas in code easier
Go to the VB Editor
Open any module in the workbook
Do a Find for the word formula and specify "Current Project'
Than start looking and fixing until you are satisfied.

Hope this helps...
--
sb
"Carol" wrote in message
...
I just spent several hours fixing formulas in a sheet that were pointing
to the wrong sheet for the response. I saved several times during this
period, and when ready to close, did click "Yes" to save changed.

Just pulled the book up again - the formulas are as they were before I
changed them!

This workbook is due tomorrow - before I fix these again, is there
something I need to know about changing a formula?
ie: Can you not just cilck in the box, and update that portion of the
formula that needs to be re-written? Is there more to it than that?

Thank you!
Carol