Looking some tips for reducing the file size of excel workbooks. I have had this issue in the past where the file size has exceeded 30 MB, and I was unable to sucessfully add this data into an app.
I store app data in sharepoint and the file is in .xlsx format. I tried to convert the file to xlsb but it was not supported.
Previously, the file size was large because of extra rows that had been added beneath the app data and formatting that increased it dramatically.
Having done this for the current workbook I am still over the max by 8MB. Would anyone have any other suggestions for reducing this? I have read that Google Drive could be better.