linking to other workbooks

K

KMiles

1) When linking to an external workbook, my references are always absolute. Is there a way to default to a relative reference, or do I need to resign myself to deleting the $ or using F4

2) What is the max number of links to a specific external workbook? After a short time, I am unable to link and am forced to manually type in the path
Thanks.
 
Top