I have a similar question to the one asked here: How to copy files from a network share to SharePoint each day?
But I'm trying to do it in reverse. I have a sharepoint file that's updated daily by multiple people. I also have a windows server and figured I could have my server periodically check the sharepoint file for changes, and if there's a change publish the new file to a specific shared drive directory (so I can maintain updated data for Tableau), and to another sharepoint link that's publicly available. Does anyone know how to do this? It's an excel file and ideally I'd like to publish only a few specific sheets of the excel file, but I could split the file apart if that's not possible.