Wiki Sumber Informasi iSIKHNAS

This can occur when Excel notices that the formulae in the column is inconsistent, and changes all of the cell entries to match the added data - the result is that ALL of the data are incorrectly coded. However, this error depends on the version of Excel used, the error reporting settings, and how the pasting was done (if the header row was included, then deleted, as outlined in the manual, this probably won't occur). If the formulae had been checked prior to building the pivot table, this would not have occurred.