nevermind, just have to click refresh. If you were to create a macro, is there a way to build that in to refresh the pivot table?