- Mar 2, 2007
Ok, experts, how do I update the data source for a Pivot Table to an access MDB for office 2003? I know I right click on the pivot, select wizard, then click the back button to the data source (step 2 of 3 in the wizard), click the get data button..., and then what? I don't see an option to point to a new location for a data source??? Any ideas?