Migrate App to Office 365, but sync slow down.
My app is based on data from Google sheet, and then i migrated the app to office 365 by copying the app and data and save to MS.
It works perfect, but the problem is the sync speed is slowing down.
I noticed the newly generated excel files within Onedrive does have max number of the row/columns, not like a google sheet where we user have a control to delete the unused columns and rows by choice.
I delete the unused cells and rows on excel online, by selecting area where i don’t use, but MS seems not to allow this actions. After deleting the selected area, still MS excel online shows the entire (max) number of the available rows and columns even after that.
Not sure if this is a cause of slow response and sync from the app, but most likely. Also this might not be a question to raise in this community, but anyone do you know how to delete the unused columns and rows from ms excel online?