Which external reference is formatted correctly?
O =[My_Sales.xlsxl!Quarter1:C12
O ='(My_Sales.xlsx)!Quarter1':C12
O ='[My_Sales.xlsx]Quarter1'!$C$12
O =(My_Sales.xlsx)!Quarter1:$C$12