Summary
This article details an issue where Report Designer does not save the changes to a report, despite the user receiving notification of the saved changes.
Article sections:
Symptoms
When working on a report design within Solver Cloud, saving changes along the way and receiving the pop-up window saying save was complete and published to the portal successfully, a user notices that the application had not saved any of the changes for the entire design session.
Further testing showed any change - even something simple (i.e., font color or a formula) - made and then saved, closed, and then published resulted in no changes saved and the report reverted back to its original format. It could appear as a one-off issue: report design changes are not carrying over to the web portal despite successful save messages in Excel & the web portal and publishing.
Cause
It is possible that a user setting within a user's AD is causing conflict with report template changes within the application. In that sense, the save location of report drafts could be saving onto a Cloud file location as opposed to your local desktop i.e. OneDrive.
Locate the report in the folders created at the following path: C:\Users\login name\AppData\Local\Temp\OSR
What could happen is that the location the backup is being saved to is not saving to the physical location on the user's desktop but perhaps the OneDrive location.
It would be best to connect with your IT to see if they can fix this setting as it is not so much an application issue. See if they can modify your settings to match other users who are not experiencing this issue.
Since the Report Designer upgrade in Cloud during the January 2021 release, rather, it is very possible that this issue is caused by some interference with other excel add-ins.
Resolution
Be sure to disable/remove any unnecessary third-party Excel add-ins as they may conflict with the Designer Excel plugin. You'll want to navigate to Excel Options window and look through both Excel and COM add-ins to disable any unnecessary third-party add-ins