software

How do I get relative values when linking cells from one workbook to another
workbook? Excel defaults to applying absolute values instead of relative
values.
Is there an option or default setting that can be altered to keep this from
happening?
I have been told that I have to go into each linked cell individually and
remove the dollar signs...is this true?

You can do a search amp; replace to GLOBALLY replace the $$ signs

quot;DeborahMquot; wrote:

gt; How do I get relative values when linking cells from one workbook to another
gt; workbook? Excel defaults to applying absolute values instead of relative
gt; values.
gt; Is there an option or default setting that can be altered to keep this from
gt; happening?
gt; I have been told that I have to go into each linked cell individually and
gt; remove the dollar signs...is this true?

Good idea.
Is this just how it is when linking workbook to workbook?
Are there default options or settings that can be tweaked in order to stop
Excel from creating absolute values?

Thank you for the feedback.

quot;Duke Careyquot; wrote:

gt; You can do a search amp; replace to GLOBALLY replace the $$ signs
gt;
gt; quot;DeborahMquot; wrote:
gt;
gt; gt; How do I get relative values when linking cells from one workbook to another
gt; gt; workbook? Excel defaults to applying absolute values instead of relative
gt; gt; values.
gt; gt; Is there an option or default setting that can be altered to keep this from
gt; gt; happening?
gt; gt; I have been told that I have to go into each linked cell individually and
gt; gt; remove the dollar signs...is this true?