Updating Workbooks?

[yamo]

I'm currently working on a workbook where formulas are continually changing and it is a work in progress but we want to go back to the old workbook and keep the same data but update the formulas. - I don't want to keep multiple version around for each change. Are there any applications that can change the old workbook formulas without changing the data or should I being doing something different?

Thanks in advance,

 

[TIMER]

Have you tried copying your new worksheet then going to the original worksheet and doing a paste special and choose the formulas box. This will just replace the formulas but leave the old data. I guess I should say that as long as the formulas you are changing and the data are in the same cells in both work sheets

 

[yamo]

Gosh I feel stupid... Never thought about that one... I'll try to see, but I think I may have to rework it so the references are correct.

Thanks!