Hi All,
I've got a problem with data I read from a database.

I wrote a VBA Sub in Excel 2007 with retrieves data via
ActiveSheet.QueryTables.Add() per OLEDB out of a database.

This works fine and puts the data in the range beginning on cell "A8"

Now my problem:
I have a formula '=SUM(A8:A10) in cell "B1".
This formula always comes out = 0, although there are values in the cells.

But if I edit cell "A8" without changing the value (just the alignment
changes) it is recognized and the formula shows = 1

What am I missing here ?

Thanks for any help,
Ralf.