Forum Discussion

SueSSA's avatar
SueSSA
Experienced User
5 years ago
Solved

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.

     

     

Komal_S's avatar
Komal_S
MYOB Staff
5 years ago

Hi SueSSA 


Upon further investigation, we've not found any specific issues with the report sizes in 2020.3. The balance sheet or profit and loss reports should not grow massively in size as the data retreived for these reports are just the account values as you mentioned. However, if your reports are custom reports or have logos/images on them, try removing them as that could cause a difference.


Also, what happens when you print the same reports from Clearwater sample file?  If they are normal in size, the issue would be with the customisation of reports as previously mentioned.


Please do not hesitate to post if you have further concerns on this. 

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

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

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