Link to cells in other worksheets & workbooks

[stacie]

I just got a new computer & installed Excel 2002. On my old computer
I used to be able to create formulas that linked to cells in other
worksheets or workbooks. I would just type = then select the
worksheet tab & then click on whatever cell I wanted to reference.
Now when I try to do that it won't let me select cells in other
worksheets or workbooks (it's like when you try to click on a cell in
a protected worksheet & all you get is the arrow, not the cross that
lets you click the cell); it will only let me reference cells that are
located on the same worksheet as the formula. The links still exist &
can be updated in the workbooks that were created on my old machine,
but I can't make new ones. None of the workbooks are protected. I'm
not sure if it makes any difference but my old computer had Excel 2003
on it &, like I said, this new computer has Excel 2002 since I don't
have the 2003 disc anymore.
Any ideas? Thanks in advance for your help

 

[KC Rippstein]

Have you tried just typing in the reference to the other sheet?
For example, just type in a formula like =Sheet2!A1
Post back your result. I also have Office XP on my home PC, and I am quite
confident I've clicked on the sheet tab and pointed to the cell I want to
reference, but I'm glad to double check.

I assume you have all updates from Microsoft downloaded for your Office XP
installation?

- KC

 

[KC Rippstein]

Yep, my Office XP (another name for Office 2002) allows me to type = and
point to another tab and select a cell or range. My version with updates is
10.6823.6825 with SP3.