During installation of the full Jet Excel add-in, the software can be configured to automatically use shared data sources through the Jet Service Tier.
This can be done using the Jet Installation Program or command-line installation.
By default, Jet data source settings are stored locally on the user's computer.
Recent versions of the Jet Excel add-in include the ability for users to share data source information through the centralized Jet Configuration Service. To use this feature in previous versions, the user must select it from the Jet Application Settings.
This feature can be enabled within the Jet Reports installer as the default setting.