Updating Workbooks?

yamo

New Member
Joined
Jan 27, 2005
Messages
2
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,
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

TIMER

New Member
Joined
Jan 27, 2005
Messages
2
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

New Member
Joined
Jan 27, 2005
Messages
2
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!
 

Forum statistics

Threads
1,182,032
Messages
5,933,354
Members
436,889
Latest member
vamsi nandan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top