Hi everybody .
I am using Office 2010 now and have a challenge which I not have with the previous version.

I set up some simple data sheets in excel and use that as input tables for a simple access query .

An excel pivot links into the access query.

Here comes the problem : with the previous versions I was working with , I culd just go into the excel pivot select refresh and latest data was retrieved . With excel 2010 it only works if the source input tables are open as well. If they are not, the pivot just returns zero values .

As I wrote it used to work inolder excel versions, anbd it does not here despite everything setup in the same way.

Any help is highly appreciated, many thanks!