ExcelBanter - Absolute address in Workbook linking

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Absolute address in Workbook linking (https://www.excelbanter.com/excel-worksheet-functions/20990-absolute-address-workbook-linking.html)

rfhorn

Absolute address in Workbook linking

Is it normal that when I link cells from worksheets in different Workbooks
the formula is always an absolute address?

Bernie Deitrick

Yes, that's the default behavior of Excel. Just get into the habit of
hitting F4 one, two, or three times prior to hitting enter, to change the
reference type.

HTH,
Bernie
MS Excel MVP

"rfhorn" wrote in message
...
Is it normal that when I link cells from worksheets in different Workbooks
the formula is always an absolute address?

rfhorn

Thank you for the response.

"Bernie Deitrick" wrote:

Yes, that's the default behavior of Excel. Just get into the habit of
hitting F4 one, two, or three times prior to hitting enter, to change the
reference type.

HTH,
Bernie
MS Excel MVP

"rfhorn" wrote in message
...
Is it normal that when I link cells from worksheets in different Workbooks
the formula is always an absolute address?

All times are GMT +1. The time now is 03:42 PM.