Hi all, I'm having a problem in refreshing a pivot table. When it does refresh, it updates data from an Access database file. The file is located in another folder. Normally, the pivot table should refresh with no problem, however, nowadays when I click refresh, it always asks me to locate the access file, is there a way to resolve this annoyance?
Reply With Quote