When copying a row from one KPI import sheet to another where both sheets have pre-populated UoMs, the paste method used in Excel determines which UoM is retained.

• Using normal paste will copy over the UoM from the source sheet, which may be incorrect for the destination sheet.

• Using paste with formulas will use the destination sheet’s pre-populated UoM — this is the correct behavior.