I have a workbook Wb1 with version 1.0 with three sheets. Sheet1, Sheet2 and Sheet3. Sheets 2 and 3 refers to some cells in sheet1 for example sheet1!B3

I have also updated Wb1's sheet1 and named new version 1.1. Now I need to replace sheet1 from version 1.1 into version 1.0. During that process if i delete sheet1 in version 1.0 there is ref# error in sheet 2 and 3.

Is there any way we can achieve this task without getting the reference error in sheet 2 and 3 as well as replace sheet 1 from wb 1.1 to wb 1.0?

Thanks

Can't you just copy sheet 1.1 and paste into sheet 1 to overwrite the data ?


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.