Thanks, that helps. The problem is with that workbook's settings where objects are set to hidden.

Click on the Office button > Excel Options > Advanced
In the "Display Options For This Workbook" section, choose the "For Objects Show ALL" option.