Error with VLOOKUP and GETPIVOTDATA double-populating characters
When I try entering a formula in which the range references cells in a separate workbook, I get a double-character in the formula when I start typing again.
For example, I try to enter the formula:
To populate the cell range, I click into the other workbook and highlight the desired columns. Then I enter the comma and 3. Excel will automatically turn the 3 into a 33.
For GETPIVOT, I see similar issues, but this time it tends to insert two commas after the workbook cell reference.
If I create formulas reference ranges within the same workbook, the problem does not seem to occur.
I believe this is a defect. I currently experience this problem on Excel for Mac version 15.19.1 (160212).