Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 20, 2016 at 05:50 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 20, 2016 at 06:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • "VBA will generate the excel sheet based on LE(Each LE will get an excel file)" - not clear!

      "excel sheet" - in which file?

      "Store the excel file into local system" - what file?

      ...

      Just a waste of time...