Excel 2010 vs Excel 2016 (365)

[Kosie123]

Hi
My formulas, especially the more complex ones, works in my Excel 2010 at home but gives an error message in 2016 at work!? Even when copied and pasted from 2010 to 2016. Annoying!
Any help will be much appreciated.

 

[RoryA]

Welcome to the forum.

You mean you get an error when you open the same workbook in Excel 2016 at home? If so, what error?

PS Please don't post the same question more than once - I've deleted the duplicate.

 

[Kosie123]

Hi
A window says: "There's a problem with this formula"
Not trying to type a formula?
(...and the rest of it...)
Sometimes a formula copied off a tutorial also give the same problem in 2016 but works in 2010.
Thanks

 

[RoryA]

And you are using the same actual workbook as you were on 2010? If not, I'd guess your regional settings are different on one of the machines - e.g. you need to use a semicolon instead of a comma to separate the arguments, or vice versa.

 

[Kosie123]

Thankyou. Semicolons worked. Where do I adjust the regional settings of my machine?
Thanks again

 

[RoryA]

In Control Panel.

 

[Kosie123]

Thankyou Rory.
Regards

 

[RoryA]

Glad to help.