Forum Discussion

SueSSA's avatar
SueSSA
Experienced User
5 years ago

Exporting Reports to Excel

We frequently export reports to Excel, in the past this has been a terrific feature.   However this month since upgrading to 2020.3 our reports are HUGE in size, we can not email the reports they a...
  • Mike_James's avatar
    Mike_James
    5 years ago

    Hi SueSSA , none of the report templates that AccountRight uses are above 100k, so I suspect the issue may occur in your process.

     

    Can you run a test - prepare the set of reports as you do, but save the file under a different name at the very beginning, and between each new report added. Then have a look at the file sizes, and see if there is any one report that causes a large increase. 

     

    Then repeat the process, but this time only copy the area of data from each report, not the whole thing. Again check the file sizes.

     

     

SueSSA's avatar
SueSSA
Experienced User
5 years ago

There are no logos or images and they are being exported to Excel in the same fashion as always, again this month the end file size is huge.

 

I run a series of reports and copy those reports into one excel spreadsheet for reporting purposes.  I copy the whole sheet not just the cells with information as it saves time, and up to now has not caused an issue.

 

Are the reports now formatting the whole worksheet? is that the issue? if so can you not? 

 

 

Mike_James's avatar
Mike_James
Ultimate Cover User
5 years ago

Hi SueSSA , none of the report templates that AccountRight uses are above 100k, so I suspect the issue may occur in your process.

 

Can you run a test - prepare the set of reports as you do, but save the file under a different name at the very beginning, and between each new report added. Then have a look at the file sizes, and see if there is any one report that causes a large increase. 

 

Then repeat the process, but this time only copy the area of data from each report, not the whole thing. Again check the file sizes.

 

 

  • SueSSA's avatar
    SueSSA
    Experienced User
    5 years ago

    ok just did it again using your above reference and because the spreadsheets come out with a white background and i copy the whole sheet it was creating a huge sheet.  This has changed as prior to this there was no white formatted background.

     

    It now appears to be fixed, Thank you MYOB :)

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.