Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

How to Refresh a Database Schema in the Jet Excel add-in


Overview

There may be times, especially when doing development work with Jet Analytics, when a new table or field may be added to a database that the user is currently reporting from using the Jet Excel add-in.  The database schema is typically only refreshed when Excel is opened, and sometimes it is not desirable to close all instances of Excel in order to see a new table or field that was just added.

Process

In order to force the Jet add-in to refresh the schema of the database it is currently reporting from, the user simply needs to open the Data Source Settings and then click OK on the Data Source Settings window.

 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments