Are you referring to linking workbooks vs. worksheets?

SmartyPants wrote:
wrote:
=sum(SheetXX!A1:A10)

the sheet name preceeds the rest range reference.


SmartyPants wrote:
I want to link to a certain cell in a different worksheet.

How do I do this?


I'm sorry, I guess I was unclear before.

I want the person veiwing the current worksheet to be able to view the
other worksheet, at a certain cell. Either by opening the worksheet or
opening a veiw of some sort.

Any Help?