Fix relative cell references that fail to update when copied down a column by removing absolute reference symbols and verifying calculation settings.