S
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
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