Hi there -
I have been building an app that has been working well. The app writes to two files excel files in OneDrive. The only issues I would have writing data to the sources with the app is if they are opened on someones local machine and if there are in cell comments / notes. I have been cautious of this and do not believe these are the issues currently.
I have recently on-boarded new users to the app and have gotten this issue twice. I am not sure what the cause is at the moment. I have tried to restore the workbook but past versions of the book seem to be having issues too. Has anyone else had this issue?
I am worried the app will not be viable if this sort of instability occurs. Thank you!
Solved! Go to Solution.
Hello @a-ovbord -
Thanks for the support. Case closed.
So it sounds like this may be an Excel bug and the best way to avoid it is to not use Excel and try to employ a different backend. There is work around to minimize disruption but it is not 100% (I already have these setting aligned with the solution). For now, I will make sure to save off the data regularly to minimize risk to data-loss.
I will work on trying Azure SQL server longer term to avoid this silly, known issue that has existed since 2014.
Attached screenshot of 'workaround' to maximize for other viewers with similar issue:
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT