Forum Discussion
5 Replies
- Komal_SMYOB Staff
Hi SueSSA
Generally, it could be due to the amount of transactions that have been retrieved in the report. You can try compressing the Excel spreadsheet and then emailing it as that would considerably reduce the file size. The only other alternative would be shortening the date range and creating a report that has less number of transactions and then emailing them out individually.That being said, we're currently investigating if the issue is related to recent update and will post an update on this thread if it is.
- SueSSAExperienced User
it is profit and loss, balance sheet etc nothing long or big that should cause that size.
- Mike_JamesUltimate Cover User
Hi SueSSA , a couple of links that have suggestions that may help:
https://www.excelefficiency.com/reduce-excel-file-size/
https://www.exceltip.com/tips/why-is-my-excel-file-so-large-how-to-reduce-the-excel-file-size.html
Re the used range, if you press Ctrl+Shift+End, what cell does Excel jump to? If it's XFQ1048576 for example (the bottom-most, right-most cell in Excel 2016), then the file will be huge, and all the rows below your report should be selected and deleted.
Do you add anything to the file after exporting, or just save it? What version of Excel are you using?
Are you using the standard MYOB Excel template for this report, or a modified version?
Looking for something else?
Search the Community Forum for answers or find your topic and get the conversation started!
Find technical support and help for all MYOB products in our online help centre
Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.