Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula gives unwanted result | Excel Worksheet Functions | |||
Unwanted single quote displayed in Formula bar | Excel Discussion (Misc queries) | |||
Unwanted formula being copied to cell | Excel Discussion (Misc queries) | |||
Unwanted change in width of columns when showing formula. | New Users to Excel | |||
My cell formula is generating an unwanted e-mail message. | Excel Worksheet Functions |