Hello,
I have a multi sheet workbook that I grouped the sheets to copy a formula
through out. When I do this the formula looks like this [R2]*-1 in each cell.
I looked at the referencing and all is correct. I looked at the tools options
for the cell referencing and tried that option but it still did not compute
my formulas.

Any ideas.
Thank you.
Lou

Is it really "[R2]" etc or is it "=[R2]" etc

--
Kind regards,

Niek Otten

"Lou" wrote in message
...
Hello,
I have a multi sheet workbook that I grouped the sheets to copy a formula
through out. When I do this the formula looks like this [R2]*-1 in each
cell.
I looked at the referencing and all is correct. I looked at the tools
options
for the cell referencing and tried that option but it still did not
compute
my formulas.

Any ideas.
Thank you.
Lou

Sorry, I think it was "=[R2]*-1

Thank you,
Lou

"Niek Otten" wrote:

Is it really "[R2]" etc or is it "=[R2]" etc

--
Kind regards,

Niek Otten

"Lou" wrote in message
...
Hello,
I have a multi sheet workbook that I grouped the sheets to copy a formula
through out. When I do this the formula looks like this [R2]*-1 in each
cell.
I looked at the referencing and all is correct. I looked at the tools
options
for the cell referencing and tried that option but it still did not
compute
my formulas.

Any ideas.
Thank you.
Lou

Is this what you see in the cell or just in the formula bar?

If you see it in the cell, two possibilities:
a. ToolsOptionsView, uncheck "Formulas" or
b. Your cells were formatted as text before entering the functions. Format
the cells as General. Then do a Find and replace all "=" by "="

Check ToolsOptionsCalculation tab, Automatic

--
Kind regards,

Niek Otten

"Lou" wrote in message
...
Sorry, I think it was "=[R2]*-1

Thank you,
Lou

"Niek Otten" wrote:

Is it really "[R2]" etc or is it "=[R2]" etc

--
Kind regards,

Niek Otten

"Lou" wrote in message
...
Hello,
I have a multi sheet workbook that I grouped the sheets to copy a
formula
through out. When I do this the formula looks like this [R2]*-1 in each
cell.
I looked at the referencing and all is correct. I looked at the tools
options
for the cell referencing and tried that option but it still did not
compute
my formulas.

Any ideas.
Thank you.
Lou