cmon this is due to german excel just like sometimes you have to use ;
instead of ,.

I wrote that the formula works fine when I enter the cell via F2 and get out
again!

There is nothing wrong with the formula!

"NickHK" wrote:

You are referring to the offsets with the wrong style of bracket :
"=RC[-1] & RC[1]"

NickHK

"Sierrraxray" wrote in message
...
The Formula is very simple:

=RC(-1)&RC(1)

It will only be evaluated when I enter the cell and leave it again.

It seems that after it is being inserted through the get external data
query
it is treated as something that is not recognized by excel so that it does
not evaluate it



"Allllen" wrote:

First suggestion:
ToolsOptionsCalculationAutomatic, but I guess you will have tried
that.

Otherwise can you post the formula here.
--
Allllen


"Sierrraxray" wrote:

I import data from a database into Excel. One of the fields contains a
formula. However, the Formula is not evaluated after the import. All
the rest
works fine.

Only if I enter the cell via F2 and then get out again the formual is
evaluated.

Is there a workaround, without using VBA?

Thanks