Using 6.0, pivot tables will not update or refresh. I've even removed the fields and inserted new ones, and the pivot still wont update. Just shows the old fields. Can't believe this is still an issue.
Quest did a lot of improvements lately regarding pivot tables.
Try downloading the latest release 6.2, and see if that helps!