Your pivot is based on a worksheet
the worksheet is based on a query.

Either:
Base your Pivot on the query directly
OR:
make sure that when the pivot refreshes
the query is refreshed first..


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


ghislain wrote :


Hello,
Excel 2003

I have a problem with pivot tables not always refreshing properly.
Data is collected from a database into a worksheet.
When the pivot table that is based on this sheet is refreshed it does
not reflect all the changes ( some are taken , others not ??? )
If I add a new pivot table based on the same date , everything is
taken

any idea?

thanks in advance

Ghislain Borremans