Forum Discussion
Spreadsheet Corrupts Upon Saving
Thanks for posting. I thought I was crazy or this was a one off issue. I had the exact same problem happen with a workbook I use on a daily basis. I was able to rebuild the shapes and get working so I assumed it was something on my end. However, today another person contacted me with the same problem (different workbook). Hopefully MS fixes this soon.
After doing some testing here is what I have found. I can insert a shape and save, no problem. I can insert another shape and add a shadow and save, no problem. I can use the Camera function to capture a region then save, no problem. But if I user the Camera function to capture a region and then put a shadow on that camera object and save the bug will occur next time I open the workbook. And to make matters worse the recovery process will delete the 2 shapes (one without shadow and one with shadow) but leave the 2 camera objects.
I logged this issue on the feedback portal. If you're having this problem feel free to go there and "1 up" it. Hoping Microsoft gets on this quickly.
Thank you! That did the trick for me too. Eliminated shadows and it seems to have solved it (so far). Thanks for sharing. Good Sherlock🧐 work!
Hope MS fixes this soon! They're going to get killed by AI if they don't pull up their socks.
This was helpful. With that information I was able to bring a copy from backup that wasn't corrupted, delete the specific camera function images that I had and saved/reopened without error. Not sure which one is problematic, because I did not have any shadow effects added to those objects (at least it didn't indicate it did when I looked at the options for it). Hopefully that'll enable me to start using this spreadsheet again, though with a few slight things missing instead of everything missing after Excel tried to "fix it".
