Absolute address in Workbook linking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it normal that when I link cells from worksheets in different Workbooks
the formula is always an absolute address?
 
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
 
Thank you for the response.

Bernie Deitrick said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet relative reference 3
External workbook links don't update when source file changes 1
XL2000 Links Between Workbooks 2
Absolute Sheet Reference 3
Absolute reference when creating links to another workbook? 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Get location of match in another worksheet 2
Linking Workbooks - getting absolute values? 2

Back
Top