I can't get a formula in excel to recalculate when copied and pasted to
another cell. Help!

I'm trying to get three of the same bits of data from 300 different
worksheets in an excel file. Each worksheet is named with a person's
first and last name.

I inserted a new worksheet, typed in each person's first and last name
into separate cells in column A.

Then I am using an indirect formula to grab the data from each
worksheet.

The formula I'm using is

= INDIRECT ("'"&$A2&"'"&"!"&B$1)


Example Worksheet:
A B C D
1 C62 h62 m61
2 Jane Doe
3 Bob Lugnut
4 John Smith


The Formula works fine. The problem I have is when I cut the formula
from row 2 (Jane Doe's data) to row 3 (Bob Lugnut's Data), Jane Doe's
data remains until I go into the cell and hit return. Only then does
the cell recalculate the formula and show Bob's data.

Because the entire point of this exercise is so I don't have to go in
and manipulate EVERY single cell to see the data, I know there MUST be
a way to fix this.

If it helps, I've used this formula before with a different excel file
and it works and recalculates fine.

I also tried starting over in a new worksheet, thinking maybe something
about that worksheet was effed up, but it didn't help.

Hitting F9 recalculates the entire worksheet. That worked for me.
Whew.

uknow message board wrote:
I can't get a formula in excel to recalculate when copied and pasted to
another cell. Help!

I'm trying to get three of the same bits of data from 300 different
worksheets in an excel file. Each worksheet is named with a person's
first and last name.

I inserted a new worksheet, typed in each person's first and last name
into separate cells in column A.

Then I am using an indirect formula to grab the data from each
worksheet.

The formula I'm using is

= INDIRECT ("'"&$A2&"'"&"!"&B$1)


Example Worksheet:
A B C D
1 C62 h62 m61
2 Jane Doe
3 Bob Lugnut
4 John Smith


The Formula works fine. The problem I have is when I cut the formula
from row 2 (Jane Doe's data) to row 3 (Bob Lugnut's Data), Jane Doe's
data remains until I go into the cell and hit return. Only then does
the cell recalculate the formula and show Bob's data.

Because the entire point of this exercise is so I don't have to go in
and manipulate EVERY single cell to see the data, I know there MUST be
a way to fix this.

If it helps, I've used this formula before with a different excel file
and it works and recalculates fine.

I also tried starting over in a new worksheet, thinking maybe something
about that worksheet was effed up, but it didn't help.

Hi

Try
ToolsOptionsCalculationset to Automatic

--
Regards

Roger Govier


"uknow message board" wrote in message
ups.com...
I can't get a formula in excel to recalculate when copied and pasted to
another cell. Help!

I'm trying to get three of the same bits of data from 300 different
worksheets in an excel file. Each worksheet is named with a person's
first and last name.

I inserted a new worksheet, typed in each person's first and last name
into separate cells in column A.

Then I am using an indirect formula to grab the data from each
worksheet.

The formula I'm using is

= INDIRECT ("'"&$A2&"'"&"!"&B$1)


Example Worksheet:
A B C D
1 C62 h62 m61
2 Jane Doe
3 Bob Lugnut
4 John Smith


The Formula works fine. The problem I have is when I cut the formula
from row 2 (Jane Doe's data) to row 3 (Bob Lugnut's Data), Jane Doe's
data remains until I go into the cell and hit return. Only then does
the cell recalculate the formula and show Bob's data.

Because the entire point of this exercise is so I don't have to go in
and manipulate EVERY single cell to see the data, I know there MUST be
a way to fix this.

If it helps, I've used this formula before with a different excel file
and it works and recalculates fine.

I also tried starting over in a new worksheet, thinking maybe
something
about that worksheet was effed up, but it didn't help.