Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table is not refreshing problem
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 -- ghislain ------------------------------------------------------------------------ ghislain's Profile: http://www.excelforum.com/member.php...o&userid=16656 View this thread: http://www.excelforum.com/showthread...hreadid=378024 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table is not refreshing problem
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table is not refreshing problem
The query is updated first and some data are taken from the updated info but not all, only if I make the pivot table again -- ghislain ------------------------------------------------------------------------ ghislain's Profile: http://www.excelforum.com/member.php...o&userid=16656 View this thread: http://www.excelforum.com/showthread...hreadid=378024 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table is not refreshing problem
read my earlier suggestion to base the pivot on the query directly. if you STILL want to base the pivot on range with the querytable THEN use the query's range NAME not the address. the address remains fixed when the query returns more (or less data) the RANGE name is updated when the query refreshes. 3rd option define your own "dynamic name" to refer to the range of the querytable. Dynamic name is a defined name where the refersto is a formula like: =OFFSET(data!$a$1,0,0,counta(data!$A:$A),counta(da ta!$1:$1)) -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam ghislain wrote : The query is updated first and some data are taken from the updated info but not all, only if I make the pivot table again |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Refreshing | Excel Discussion (Misc queries) | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
VC Problem refreshing pivot table | Excel Discussion (Misc queries) | |||
OfficeXP "Cannot open pivot table source file" when refreshing pivot table | Excel Programming | |||
Pivot table not refreshing | Excel Programming |