"We can't open this workbook. It's set to only show certain named items, but they aren't in the workbook" when previewing a spreadsheet and blank worksheet when I edit
Issue When I try to preview a spreadsheet I get the error
"We can't open this workbook. It's set to only show certain named items, but they aren't in the workbook".
When I edit the spreadsheet, it just displays as a blank worksheet.
Cause The worksheet(s) have been hidden in Excel.
Solution
In FYI, edit the spreadsheet.
In Excel, from the View menu option, click Unhide
A pop-up message displays to confirm the Unhide. Click OK. This should show the content of the spreadsheet.
Close the spreadsheet and click "I'm finished Editing" in FYI.