Pivot table doesn't refresh when base data changes
Posted by Sarah on October 24, 2001 9:08 PM
When I refresh data using the 'New Database Query' function in Excel, my pivot table which accesses this data doesn't include the new data added when I tell it to refresh.
This only happens with a macro, if I do the data refresh and pivot refresh manually the pivot will automatically pick up the new data added.
Is there anyway to write the macro so that it automatically picks up new data