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

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

The Formula is very simple: =RC(-1)&RC(1)


"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

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

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

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

Oh, I didn't realise I was suppose to guess you use the German version ?
Because what you posted errors in the English version.

NickHK

"Sierrraxray" wrote in message
...
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

The problem has been described from a different view angle in KB Article
135506.

However, there is only a manual solution offered, by way of entering the
cell via F2, similar to what I wrote.

I am lokking for an automatic solution, however.

Why does Excel not recognize a formula that is fetched from a database?

Thanks

"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