If you use a query vs a table in access linked to your pivot table in excel will it be faster? Will it make excel faster? The table in access has several fields I don't need in my pivot table. Eventually the access table is going to get pretty big. Im also using a timeline to filter my pivot table. My excel pivit table is going to be used to create a monthly report. Its not that hard to create a query and use that as my source but I'm just wondering if its necessary, does it help with excels performance?