External data import with a formula, fiormula is not evaluated
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
|