Error - run-time error '1004' StatusBar

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.