Different languages collision in one function.

Copper Contributor

Hello,

I have to work with protected document without macros and I can not find its author.

It is created in German language, but I want to open document and edit with my language.

There is an original formula in locked cell

=ZELLE("Inhalt";A1)

 

When I open it with English default language, the parameter of function remains in German

=CELL("Inhalt";A1)

But it should be

=CELL("Contents";A1)

 

Is any way how to fix it?

Is any possibility to change "CELL" function definition using VBA without changing the document?

 

Thanks for reply

Kamil

 

 

2 Replies

@Kami-1 

The English codewords should work in any language.

=ZELLE("Contents";A1)
=CELL("Contents";A1)

@Detlef Lewin 

Thank you for your advice.

I tried it and it works, but problem is I can not unlock the original sheet so I can not fix it this way.