Hi Carol

Edit and save should be it. The only place I've seen this happen is when
someone opens an email attatched workbook, edit immediately and saves as
something more permanent in My Documents. Then this is not the file that's
the email attatchment, it's an adjusted copy saved in My Documents, and
reopening the attatchment will show the old thing, not the adjusted file.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Carol" skrev i melding
...
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