Can anyone advise how I get around my "little" problem!

I have a series of calculations on one worksheet that reference another
sheet which is deleted and then re-created. When re-creating the reference
sheet I lose the calculations on the referencing worksheet.

I'm sure there is a simple way to avoid this but don't know the answer! Any
advice greatly appreciated,

Neil

Tools-Options-General tab. Uncheck "R1C1 Reference Style"



"highlystrung" wrote:

Can anyone advise how I get around my "little" problem!

I have a series of calculations on one worksheet that reference another
sheet which is deleted and then re-created. When re-creating the reference
sheet I lose the calculations on the referencing worksheet.

I'm sure there is a simple way to avoid this but don't know the answer! Any
advice greatly appreciated,

Neil

Bill, doesn't solve the problem. Any other ideas? thanks, Neil

"Bill" wrote:

Tools-Options-General tab. Uncheck "R1C1 Reference Style"



"highlystrung" wrote:

Can anyone advise how I get around my "little" problem!

I have a series of calculations on one worksheet that reference another
sheet which is deleted and then re-created. When re-creating the reference
sheet I lose the calculations on the referencing worksheet.

I'm sure there is a simple way to avoid this but don't know the answer! Any
advice greatly appreciated,

Neil

Sorry - somehow this got posted to the wrong thread. Apologies.

"highlystrung" wrote:

Bill, doesn't solve the problem. Any other ideas? thanks, Neil

"Bill" wrote:

Tools-Options-General tab. Uncheck "R1C1 Reference Style"



"highlystrung" wrote:

Can anyone advise how I get around my "little" problem!

I have a series of calculations on one worksheet that reference another
sheet which is deleted and then re-created. When re-creating the reference
sheet I lose the calculations on the referencing worksheet.

I'm sure there is a simple way to avoid this but don't know the answer! Any
advice greatly appreciated,

Neil

my only thought is to just clear the sheet, don't delete it.

--


Gary


"highlystrung" wrote in message
...
Can anyone advise how I get around my "little" problem!

I have a series of calculations on one worksheet that reference another
sheet which is deleted and then re-created. When re-creating the reference
sheet I lose the calculations on the referencing worksheet.

I'm sure there is a simple way to avoid this but don't know the answer! Any
advice greatly appreciated,

Neil

Select all the cells on the worksheet with the formulas that point at the sheet
to be deleted.

Edit|replace
what: =
with: $$$$$
replace all

Now all the formulas in the cells are just text.

Delete the 2nd sheet
and replace the $$$$$ with = to convert the text back to formulas.

Watch out if you have names that point at ranges on that sheet to be deleted.

You may want to use Gary's suggestion and clear the 2nd worksheet and just paste
the new values/formulas into that sheet.

highlystrung wrote:

Can anyone advise how I get around my "little" problem!

I have a series of calculations on one worksheet that reference another
sheet which is deleted and then re-created. When re-creating the reference
sheet I lose the calculations on the referencing worksheet.

I'm sure there is a simple way to avoid this but don't know the answer! Any
advice greatly appreciated,

Neil

--

Dave Peterson