You will also need event code to refresh your pivot table but first let's build an Excel defined table.Excel 2007 and later versions Excel tables A very useful feature in Excel is defined tables, introduced in Excel 2007.The model begins with an ODBC application making a call to the Driver Manager through the ODBC application program interface (API).The Driver Manager can be either the Microsoft Driver Manager or the unix ODBC Driver Manager.
In this example there are two worksheets, "Data" and "Pivot table", to make it simple.
I hope this question is not too confusing and I appreciate your help!
Second, what do I need to replace in the sub (it looks like provider, data source, initial catalog, etc) and where do I find the info to replace them with?
If the external data source that you want to access is not on your local computer, you may need to contact the administrator of the database for a password, user permissions, or other connection information.
If the data source is a database, make sure that the database is not opened in exclusive mode.