software

I'm linking one cell in excel to another cell in a seperate spread sheet and
using the absolute reference $ to allow the formula to move when the source
cell moves. This doesn't work unless both spread sheets are open when the
cell is moved.
What am I doing wrong?John,

You're not doing anything wrong. Both sheets need to be open for Excel to know that something has
moved...

The better alternative is to use formulas that find your moving cell: match/index/vlookup etc...

HTH,
Bernie
MS Excel MVPquot;johncquot; gt; wrote in message
...
gt; I'm linking one cell in excel to another cell in a seperate spread sheet and
gt; using the absolute reference $ to allow the formula to move when the source
gt; cell moves. This doesn't work unless both spread sheets are open when the
gt; cell is moved.
gt; What am I doing wrong?
gt;
Bernie,
Thanks I'll try that, you've saved me a lot of frustration!

quot;Bernie Deitrickquot; wrote:

gt; John,
gt;
gt; You're not doing anything wrong. Both sheets need to be open for Excel to know that something has
gt; moved...
gt;
gt; The better alternative is to use formulas that find your moving cell: match/index/vlookup etc...
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;johncquot; gt; wrote in message
gt; ...
gt; gt; I'm linking one cell in excel to another cell in a seperate spread sheet and
gt; gt; using the absolute reference $ to allow the formula to move when the source
gt; gt; cell moves. This doesn't work unless both spread sheets are open when the
gt; gt; cell is moved.
gt; gt; What am I doing wrong?
gt; gt;
gt;
gt;
gt;