I have an ms access database that keeps track of many logs for us. The backend tables are stored on a SharePoint site document location so 3 front end users ( data entry) (front end files stored locally on users computers) can Input data for the rest of the workers to view via exported queries. I have multiple queries updated every time their associated tables are updated. I could only accomplish these exports, to replace an existing file (on SharePoint site document that is synced to data entry user computer, and from there it uploads to SharePoint cloud where everyone else can access the file). Problem is that exported files do not have the proper formatting I need for the end users to be able to affectively see the data ( freeze header row, auto filter on columns etc. ) Ideally I want to have these exported queries be updating the data in an existing excel table. This way I can format the excel tables once and that formatting will keep through every update.
Note: the computer that generates the export query and the end user of the exported query are two different users and computers both having access to the same SharePoint document folder/ file.
This is not an ideal database or SharePoint configurations. Expert tips on both ends to resolve this problem is much appreciated.