J
jolowe
I am linking cells from several pages in differant books - I have done this
innumerable times but this time I am getting an array formula.
Example: {=Excel.Sheet.12|'C:\Users\Joanne\Desktop\Work - TN\Working
File\ACTIVE PATIENT LIST 1.xlsx'!'!Active Patients!R5C3:R77C3'}
I normally get a link that looks like this -
Example: ='C:\Users\Annette\Desktop\Nate 1\Monthly\[ACTIVE PATIENT LIST
1.xlsx]Active Patients'!C5
I do not know what has happened - is it something I inadvertanly did? If so
how do I undo it. I just want to copy and paste (links).
And can someone tell me what the " R5C3:R77C3' " is all about? I assume it
is the cell I am copying - and that it is being treated as an item in the
array - but WHY is a straight copy/ linking paste picking it up that way?????
Thank you in advance for any help you can give me.
innumerable times but this time I am getting an array formula.
Example: {=Excel.Sheet.12|'C:\Users\Joanne\Desktop\Work - TN\Working
File\ACTIVE PATIENT LIST 1.xlsx'!'!Active Patients!R5C3:R77C3'}
I normally get a link that looks like this -
Example: ='C:\Users\Annette\Desktop\Nate 1\Monthly\[ACTIVE PATIENT LIST
1.xlsx]Active Patients'!C5
I do not know what has happened - is it something I inadvertanly did? If so
how do I undo it. I just want to copy and paste (links).
And can someone tell me what the " R5C3:R77C3' " is all about? I assume it
is the cell I am copying - and that it is being treated as an item in the
array - but WHY is a straight copy/ linking paste picking it up that way?????
Thank you in advance for any help you can give me.