Unwanted Array Formula
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. |
All times are GMT +1. The time now is 10:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com