When you enter a new Web Services URL in the Strategy for Office add-in, the changes are not retained. If you reopen Excel to access the add-in, the Web Services URL is still the prior value.
This is a known issue which occurs in Strategy for Office 2020 and later versions.
Set the Web Services URL via the Registry Editor. For steps and more information, see KB483066: Unable to permanently replace Web Service URL in MicroStrategy Office. The registry key must be modified manually on the Office client machine.