When I am linking one workbook to another, the default formula always has $'s
before and after the Column id. How do I link without having the $'s added?
--
cmatthes

You don't but just toggle through the $ options using the F4 key.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Cmatthes" wrote:

When I am linking one workbook to another, the default formula always has $'s
before and after the Column id. How do I link without having the $'s added?
--
cmatthes

Cmatthes wrote...
When I am linking one workbook to another, the default formula
always has $'s before and after the Column id. *How do I link
without having the $'s added?

If when building your formulas you add external references by
switching to other workbooks and selecting the ranges you want, just
press [F4] 3 times just after selecting the external range to change
the range address to fully relative. Alternatively, if there are no
other $s in these formulas, select the cells containing these formulas
an Edit Replace $ with nothing.