I am using Excel to render data stored in a PostgresQL database elsewhere on our network. In general, the rendering works. However, I haven't been able to get the document to automatically update/refresh data from the data source when users view the page.
The Excel data source is a DSN. I'm assuming the ODBC drivers and DSN would need to be installed on the SharePoint server, but I suspect more than this has to be done.
Anybody know the steps involved ?