Below is how the one cell comes in on the remote spreadsheet.
='C:\Users\cbeckwith\Documents\UtilityBill-MasterStorage\Sharepoint-Utilities2012FY(Actuals)\2012FISCAL YEAR COMPLETED\[2012 FY Utilities (UMCB-COMPLETE).xlsx]UMCBrack-CP'!$M5
-CP'!$M5 The column M stays stagnant (Vertical on original), but having a problem in the sheet with the 5 increasing in value in the Horizontal direction, it just stays the same across 12 columns when I drag the link across the columns. Then I have to manually fix all the columns. Is there an easier way to fix this?