Formula name value editing on workbook

[Plastics]

Recently I downloaded a template from Microsoft for a sales project-the template is called Pipeline Management-Strategic Sales Management. One of columns rows is entitled Sales Phase. It has different options for entry, such as Lead, Contact, Written Proposal, etc. However of of the names in this list is entitled Executive Sponsorship. I have no use for it. I like to rename the same to "Quote Submitted". I have tried everything I know but I can not seem to make it work across all seven sheets. I keep corrupting the data associated with the corresponding fields. Any help will be appreciated. Should you be able to provide guidance, I can send you a copy of the workbook for reference. Thanks in advance!!!!

romanest@sbcglobal.net

 

[tweedle]

Did you try..
CTRL+H
Find Executive Sponsorship
Replace with: Quote Submitted
Within: Workbook
Look In: Formulas

 

[Plastics]

I need to replace the item "Executive Sponsorship" with "Quote Submitted". Upon using CONTROL+H, which I have tried, it does replace the reference, but the rest of the worksheets containg the attendant values return an error message.

FYI-I am using MSOFFICE 2007

 

[tweedle]

There are really 2 sheets to modify.
The Month Calculations contains the affected formulas (Column O).
The Pipeline Input has the data values.
Below is code that sets my version to error free formulas.
It's notable that the formulas are very sensitive to the accuracy of the data input; ie "Quote Submitted" will work fine, but "Quote Submitted " will error.
Ideally; I would apply data validation to those.

Sub SetQS()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
Cells.Replace What:="Executive Sponsorship", Replacement:="Quote Submitted" _
, LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat _
:=False, ReplaceFormat:=False
Next ws
End Sub

From the original template, I get 25 replacement & 22 are Formulas (Monthly Calculations; Column O) with 3 Pipeline Input cells.

Alternatively; one could edit Monthly Calculations!O6
Formula is: =IF('Pipeline Input'!$G7="Contact",0.1,IF('Pipeline Input'!$G7="Lead",0.2,IF('Pipeline Input'!$G7="Qualified Lead",0.3,
IF('Pipeline Input'!$G7="Opportunity",0.4,IF('Pipeline Input'!$G7="Quote Submitted",0.5,IF('Pipeline Input'!$G7="Written Proposal",0.6,IF('Pipeline Input'!$G7="Negotiation Phase",0.7,-1)))))))
...and fill down the cells underneath.

 

[Plastics]

Finally! I don't know how I blanked out on this one.
It worked-thank you for your time and patience!!!