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
3 Replies
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?
