Updating data in a linked table is not supported white rhino speed dating
For example, an event planning relational database might contain a table with customer information, a table with vendor information, and a table with event information.The table with event information might have a field to relate it to the customer table, and a field to relate it to the vendor table.You can also adjust the location where the pivot table will be added.This line is further down in the Create Connection code. Then go back to Excel, click the button on the worksheet, and a summary pivot table will be automatically created.Commands in Backstage view generally apply to entire databases, not to objects inside of a database.
I usually recommend that you move all the data onto one worksheet, if it will fit, or store it in a table in Access, then use that as the source for the pivot table.
You can use calendaring software, but tracking financial information in a calendar isn't a good fit.