View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default 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