We are using Microsoft 365 which is indicating Excel version 2401 (Build 17231.20236 Click-to-Run). The workbook template we have been using has been in service for over three months, working without issue until yesterday. The user opened the template, enabled macros, populated the necessary fields then activated the rename button. The rename button renames the workbook based on the fields populated and saves the file to a specific location.
The error message presented to user:
Next, the user attempted to Save As and was presented with this error message:
Now the template file continues to give these errors and is unusable. I have placed a backup template file in place which is working properly. I have also compared the working file to the file with errors and cannot find any differences.
We have been presented with the second error message on three occasions over the past 45 days with other files. All use similar macros and VBA that we have been using for several years without issue.
What has changed and what needs to be done to prevent or fix this issue?