Hi Kristen,
I saw that you've opened a case with Microsoft, but if you haven't heard back yet, here's something that might help:
Since you mentioned the Server URL, it made me think of a support case we'd opened up in early June with Microsoft around a similar publishing issue. I can't remember the specifics of the error message but that a couple of our clients were unable to publish changes. We'd opened the case on May 30th, and Chris Bulson from the support team had suggested a temporary fix to get things working. On June 1, Chris informed us that a hotfix had been deployed, resolving the issue.
Here is what we were asked to do to work around the issue. It might work for you too.
===
From Chis Bulson, Microsoft:
This is down for everyone right now. Development has a fix that they are testing and will hopefully deploy in the next day or two. In the meantime you can go into the Add-in Settings and change the URL from - exceladdinprovider.smb.dynamics.com
To the old URL format https://<tenant>.financials.dynamics.com
This should allow you to publish. The problem is that you will need to do this every time you open a new ‘Edit in Excel’ file.
===
I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"