Even when I use the Ribbon to unhide the workbook and re-save as unhidden, the workbook always opens as hidden. The file extension is xlsx, I couldn't see any macros.
Don't know what to do next. Any help is appreciated. Thank you in advance.

Try running a Diagnostic: Running Microsoft Office Diagnostics from within Excel/Word
Click the Microsoft Office button
Click on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run DiagnosticsRunning Microsoft Office Diagnostics from the Start Menu
Click on the Start button
Click All Programs
Click Microsoft Office folder
Click Microsoft Office Tools
Click Microsoft Office Diagnostics
Click Continue
Click Run Diagnostics
