Skip to Content
avatar image
Former Member

reduce excel file report

Hi All,

I used bpc 10 nw excel sp 25. I build simple report, which is one worksheet have 3 report ID. Those report is only retrieve account list and no transaction data. While I saved it into local PC, file size is 99 MB. My file type is .XLSM, because I have vba script.

My question is: I updated this report, I was getting file size to be more than 99MB, I did not have transaction data in file. How to reduce file size?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 20, 2017 at 07:45 AM

    "Those report is only retrieve account list and no transaction data" - EPM reports always retrieve transaction data (even empty data).

    I don't think it's possible to reduce file size.

    Add comment
    10|10000 characters needed characters exceeded