Sharepoint Excel error "Error in Value A value used in the formula is of the wrong data type"

Occasional Contributor

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

@helsbrooks1981 

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?

@helsbrooks1981 

And that is .xlsx file? Perhaps you may share the sample file with only one record?