When opening a Projector report you may receive the following error message from Excel: Run-time error '1004': Method 'StatusBar' of object '_Application' failed
The error message is displayed when you open a report in Protected View mode. You will know you're in protected mode because a message will be shown at the top of your Excel report (see screenshot).
Solution
Protected View is explained in detail for each version of Excel. Click the appropriate link below.