Formulas in a different language

[poobear]

Hi everyone

I am trying to make an excel document that works for two people, one of which has excel in english and one of which has excel in swedish. Excel doesn't seem to recognize formulas set in another language.

Is there really no solution to this? Excel should recognize formulas in other languages, or at least be able to change the language of Excel itself.



Do I really have to have two versions of Office installed and make two copies of all documents?

Thanks!

[Colin Legg]

Excel should automatically adjust the formulas for the local user when the workbook is opened. I'm not familiar with Mac versions of Excel, but I'd be very surprised if they work differently in this respect. I assume that the formulae exist in the workbook when the user opens it and they're not, for example, being dynamically added by VBA?

Are both users using the same version of Excel? Can you attach an example workbook?

[poobear]

Thanks for the reply.

After further investigation, it looks like Excel can read other languages but not write other languages. When writing my previous post, I only tried to write in other languages.

So Excel can read formulas from other languages and on-the-fly translate them to your current language. It can not however write formulas in other languages, but seeing as the receiver can open and on-the-fly translate the formula, this is not a big issue.