Options in linking workbooks
When I select a cell in another workbook to link into my active workbook, it always comes across as an absolute reference. This is an absolute pain, because most of the time I want to extend that link to copy a number of adjacent cells and every time I have to go in and edit out the $ signs before continuing.
So how about an Excel Option to link references either as absolute or relative ?
Col Delane commented
@ Malcolm: You don't need to enter the formula link and then separately edit out the $. Instead, when you select the target cell/range in the other workbook, just press F4 key to loop through the 4 referencing options until you have the one you want, AND then press Enter to accept the result.
Agreed!!! I have yet to find a good use for the absolutes; mainly, it's just annoying that I need to remove them