ToolsOptionsCalculation tabSelect Automatic

"Heine" wrote:

Hello,

I have a problem with a dataset I import from a business system. When I
want to look úp in the system it returns #N/A. However if I activate
the cell and press enter Excel CAN perform the lookup. That is if I go
into every cell I look up the formula works fine. I cannot change the
formats of the cell in any way before I have visited the cell. Anybody
who has any idea of how to solve this problem, I would be most
grateful.


Thanks in advance

/Heine