Changing a formula on the worksheet
 

I have a worksheet with hundreds of formula, each formula has a option to
check for a site.
ex:
=SUMPRODUCT((DataSite="ABC")*
(DataAcc=510115)*
(DataAcc<=510115)*
(DataAmount)
)

How do i change Site to 'XYZ' globally without goin to each cell and change
the formula to have site 'XYZ'.

Thanks in advance,

Shashi

Changing a formula on the worksheet
 

Great.... Thanks.
"Rafael Ortiz" wrote in message
...
Toggle the sheet to Formula View (CTRL + `), then do an Edit, Replace...
Then toggle back to regular view (CTRL + `)

Note: The ` is on the same key as the tilde (~).

MRO


"Shashi Bhosale" wrote in message
...
I have a worksheet with hundreds of formula, each formula has a option
to
check for a site.
ex:
=SUMPRODUCT((DataSite="ABC")*
(DataAcc=510115)*
(DataAcc<=510115)*
(DataAmount)
)

How do i change Site to 'XYZ' globally without goin to each cell and
change
the formula to have site 'XYZ'.

Thanks in advance,

Shashi