Please be aware of the following:
If you have a worksheet without units and wish to assign new units to the column headers you might use the Data Wizard>Properties. However, when performing this step to specify units the result appears incorrect because the new specified units are not displayed. However, they have been applied but the header is simply not auto sizing correctly and you would need expanded the first row DOWN manually to see the units
This problem is NOT seen when you start with a dataset that already has units because the size of the header row is already bigger.
The defect that the header doesn’t auto size has been tracked but the integrity of the manipulation is not compromised.
See attached screenshots for further clarification.
Ana Henry
Phoenix Product Manager