Forum Discussion
Sharepoint Excel error "Error in Value A value used in the formula is of the wrong data type"
When saving an excel file to Sharepoint the column with a multiply formula shows #VALUE! - Error in Value A value used in the formula is of the wrong data type
That usually happens when you use texts instead of numbers in calculations. What do you see in formula bar if stay on any cell in column G?
It just shows the value in the cell
And that is .xlsx file? Perhaps you may share the sample file with only one record?