• Can't Sort Excel with Access Data Source

    From Cindy Krist@21:1/5 to All on Tue Nov 2 18:24:11 2021
    I've inherited a database that is used by Excel files where they use an Access query as their data source. The user used to be able to sort and filter the spreadsheet. Now that I've moved the database and Excel file to a cloud server (both on the same
    server), the user can no longer sort nor filter the data.

    I exported the data to a new Excel file and tried using this new file as the data source instead of the Access db, but have the same issue.

    Thanks in advance for the help

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)