Skip to Content
Former Member
Aug 04, 2008 at 05:42 PM

Range of Object Worksheet Failed error when creating variable report


I have BO Planning version 11.6 and am running it in conjunction with Excel 2007. Every time I try to use the Report Wizard I can create a report the first time with no problems. However, when I exit out of that report and then try to create a new report using the Report Wizard I receive the following error "The following error has occurred: Error No. 1004, Method 'Range' of obejct'_Worksheet' failed". Then a report pops up with no data in it. The error keeps occuring when I try to create new reports until I exit out of Business Objects and open it up again. Then I can create 1 report with no problems.