I had fewer issues updating Excel files once I switched to using the XLSX engine instead of trying to open and overwrite the spreadsheet directly. Also, make sure Excel isn't running in the background. If you're using the latest tools, the microsoft office 2024 download now includes better support for integrating with external applications like SAS, which might make things work smoother.
... View more