I recently encountered a serious issue with an Excel workbook containing a dashboard.
The workbook had been working normally, including as recently as the weekend of 2–3 May 2026, with no issues opening or closing the file.
A few days later, when attempting to open the same workbook, Excel displayed error messages stating that it had found a problem with the file contents and needed to repair the workbook. After repair, dashboard elements such as charts, shapes, and other visual objects were removed.
I spent approximately two days troubleshooting the issue, including:
- Quick Repair of Microsoft 365
- Online Repair / reinstall attempts
- changing Excel trust/security settings
- testing macros and active content settings
- testing file copies on different storage locations
None of these resolved the issue. Admittedly phrasing a query correctly to get specific answers is always challenging. After two days of struggling i found a clue on a forum ( it mentioned shadow effect ) so i had to painstakingly reproduce each shape, snapshot on the dashboard one by one and that's how i found the culprit.
After isolating the cause ( reproducing each item on the dashboard step by step ) through repeated testing , I found the problem to be reproducible and specifically linked to the following:
Trigger: Applying the Shadow effect under Picture Effects to an object created using Excel’s Camera tool (live camera snapshot of worksheet content).
Reproduction steps:
- Create or open a workbook
- Use the Excel Camera tool to capture a live snapshot of worksheet content
- Place the camera snapshot on a worksheet/dashboard
- Apply a Shadow effect via Picture Effects
- Save the workbook
- Close Excel
- Reopen the workbook
Observed result:
- Excel displays: “We found a problem with some content…”
- After repair, visual dashboard objects are removed
- Repair logs reference removed drawing components (
/xl/drawings/...)
Test: If the same Camera object is used without the Shadow effect, the workbook opens and behaves normally.
Based on repeated testing, this appears to be a regression, as the same workbook previously worked correctly with the same formatting applied.
The workbook had been working normally, including as recently as the weekend of 2–3 May 2026, with no issues opening or closing the file.
I spent approximately two days troubleshooting the issue, including:
- Quick Repair of Microsoft 365
- Online Repair / reinstall attempts
- changing Excel trust/security settings
- testing macros and active content settings
- testing file copies on different storage locations
None of these resolved the issue.
I found the problem to be reproducible and specifically linked to the following:
Trigger:
Applying the Shadow effect under Picture Effects to an object created using Excel’s Camera tool (live camera snapshot of worksheet content). +
Reproduction steps:
- Create or open a workbook
- Use the Excel Camera tool to capture a live snapshot of worksheet content
- Place the camera snapshot on a worksheet/dashboard
- Apply a Shadow effect via Picture Effects
- Save the workbook
- Close Excel
- Reopen the workbook
- Observed result:
- Excel displays:
“We found a problem with some content…”
- After repair, visual dashboard objects are removed
- Repair logs reference removed drawing components (
/xl/drawings/...)
Test:
If the same Camera object is used without the Shadow effect, the workbook opens and behaves normally.
A fix that also did not work...
Note! after applying the shadow effect , saving and reopening the file i the workbook dashboard section contained almost nothing except the actual camera snapshot that even if one removes the shadow effect, other objects remain gone even when saving and reopening the workbook. the only option with a repaired workbook is to re-do the entire dashboard and if you dont know what's causing the problem you can end up doing that a few times. !!!!!!!
Questions:
Is this a known issue? or is this something new? Is the problem linked to a recent update? Will this "fix" hold " Is there a fix out there or is a fix in the pipeline ?