Can't Sort Excel with Access Data Source

[Cindy Krist]

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