Linking a pivot table in excel to access table vs query

Db-why-not

Registered User.
Local time
Today, 06:03
Joined
Sep 17, 2019
Messages
160
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?
 

Users who are viewing this thread

Back
Top Bottom