Copying Data in a cell in one sheet to a cell in another sheet

[Margie]

I've run into a problem trying to copy data from a cell
in one sheet to another. I have a spreadsheet
called "rating" which contains a number of formula that
calculates a final number. I also have a spreadsheet
called "Final" that copies over the information
from "Rating". In "Final", I'm trying to copy a number
from "Rating" into a particular cell. I put in =Rating!
G89, but it won't work. When I press enter, a window
pops up "Update value:Rating". I press enter again and
in the cell where I want the number to appear, #name?
appears.

Can you tell me where I went wrong? I've followed the
same process in other cells in "Final" and it works
fine. It's just this one cell that gives me a problem.

Thanks for your help!

 

[Charlie]

Try

=[Rating.xls]Sheet1!$G$89

Charlie O'Neill