Hi Chevell,
is there a way to set the pivot table source to a table instead of a sheet?

i want to later update the source sheet with proc export and if the pivot table dont have a table as a source the changes to the source are hard to update if i dont want to rebuild the whole workbook.

thanks!