Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
locking or protecting formulas
Hi all
I have a series of work sheets ( sheet1 thru sheet8) all are linked to another sheet (sheet9) that displays the data that I need from each (sheet1 thru sheet9). I want to be able to rename any worksheet such as rename to (sheet1a thru sheet8a) and then create another blank copy of(sheet1 thru sheet8). When I do this renaming, the formula automatically refers to the renamed version of the original sheet "the formula that refered to sheet1 now refers to sheet1a" How can I protect my formula so it will always refer to sheet1 or shhet2 etc. Please help. All else is working as I planned but this is messing it all up -- cruchnin numbers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
locking or protecting formulas
You could try temporarily converting your formulae to text with
Edit/Replace Replace What: = Replace With: %% Then rename your sheets, set up the new sheets, and change your formulae from text back to formulae Edit/Replace Replace What: %% Replace With: = Be sure to back up before trying. "belvy123" wrote: Hi all I have a series of work sheets ( sheet1 thru sheet8) all are linked to another sheet (sheet9) that displays the data that I need from each (sheet1 thru sheet9). I want to be able to rename any worksheet such as rename to (sheet1a thru sheet8a) and then create another blank copy of(sheet1 thru sheet8). When I do this renaming, the formula automatically refers to the renamed version of the original sheet "the formula that refered to sheet1 now refers to sheet1a" How can I protect my formula so it will always refer to sheet1 or shhet2 etc. Please help. All else is working as I planned but this is messing it all up -- cruchnin numbers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
Locking formulas | Excel Discussion (Misc queries) | |||
locking formulas | Excel Discussion (Misc queries) | |||
Protecting formulas | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |