Formula Recalculation Error

  • Thread starter uknow message board
  • Start date
U

uknow message board

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.
 
U

uknow message board

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top