Formulas not "saving"

[Guest]

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

 

[Harald Staff]

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

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?

 

[steve]

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

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?

 

[Tom Ogilvy]

I would use Edit=>Replace

what Sheet1
with Sheet2

If you save it, the changes should be retained. Or, do a saveAs and give it
a new name - then you should have both - the old and the new.
--
Regards,
Tom Ogilvy

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?

 

[JMMach]

It sounds like it may be a rights issue on a network.
Try saving it to C: and see if that works, then copy it to where the
original file resides.
Let us know if that helped.
--
TTFN
JMMach

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?