Skip to Content
0

Microsoft excel 2013 has stopped working while printing the EPM10.0 report

Dec 20, 2016 at 05:13 AM

67

avatar image

Hi All,

After refreshing the EPM report we are generating the workbooks and saving it in local system. After generating 200-300 workbooks I'm getting below error (Microsoft excel has stopped working) . I have to print more than 1000 workbooks. Kindly provide me the solution

Thanks in Advance!

Regards,

Alagappan R

rmaqq.png (39.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Dec 20, 2016 at 05:50 AM
0

Sorry, but you have to provide more details! Explain your case step by step.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Vadim,

I have a report with more than 10 sheets each sheet having details like legal entity,master data, rates etc.. and I have a common template also in the same report. After refreshing the report I'm printing the workbooks based on legal entity using VBA. It will fetch the data from master data sheet, rate sheet and other sheets final result will be stored in my common template and it will be stored in my local system, each legal entity generating the workbooks. While printing workbooks only I'm getting issue

Regards,

Alagappan R

0

Sorry, not clear!

"After refreshing the report I'm printing the workbooks" - what do you mean??

Step by step, please!

0
Priyanka Jagtap Dec 20, 2016 at 06:03 AM
0

I dont think its possible to generate 1000 worksheets in a go!! Its a standard error of Excel.....worksheet generation limit will depend on the report complexity. If you say you are able to generate at least till 200 workbooks without any error...then create hierarchies of about 200 members each and then generate the worksheets using the hierarchies! That would be easy....

Regards,

JP

Show 15 Share
10 |10000 characters needed characters left characters exceeded

Hi JP,

Last year we have generated around 1300 workbooks. We were used Ms office2007 but currently we are using ms2013.

In our case hierarchies not possible.

Regards,

Alagappan R

0

As I said.....worksheet generation will vary depending upon the report complexity and not MS versions!!! You have a macro too in your sheet which is fetching data from different sheets. Its highly complex.

In our case hierarchies not possible. - Why? You cannot create 5 dummy nodes for this purpose?

0

You can create a macro that can generate unlimited number of workbooks :)

Copy template, refresh, save with some name, print, close!

0

Yes...this is possible... :)

0

Topic author is not talking about worksheet generation...

0

Is he generating them through Macro?

0

That's the reason why I am asking to describe step by step...

0

Yes, by using VBA only we are generting

0

Sorry guys...I misunderstood. :(

0

Look on the perfect idea of the topic author - he just deleted his comment with my comment :)

0

:) :)......

0

Sorry! What I explained was not correct.

0
Show more comments

1. Open EPM report

2. refresh the report with my input (like time, version)

3. Execute the VBA available in the same report

4. VBA will generate the excel sheet based on LE(Each LE will get an excel file)

5. Store the excel file into local system

6. While saving some 200-300 workbooks no issue after that I'm getting below error

Regards,

Alagappan R

ebxas.png (35.6 kB)
0
Show more comments