Excel: Run-time error '1004' If you get the "Run-time error '1004': Method 'Iteration' of object '_Application' failed", with no viewable workbook. 1. Go to View 2. Then Unhide 3. Select the workbook to unhide