Excel file size in SharePoint increase dramatically RRS feed

  • Question

  • in our team we are working on some excel files and store them in our SharePoint site for some reason which I could not figure out the size of our excel files jump up suddenly over 200mb or even 300mb!

    I download the excel file and notice one of the sheet rows is almost full.! 
    does any one can see such issue and can any one assist me?


    Monday, October 12, 2020 3:04 AM

All replies

  • Hi there,

    In the issue of a file size increases, very little can be done to reduce the size again, bar deleting absolutely everything. However building up and earlier version of your document to match what  most recent version was, you will face no trouble.

    But this sudden increase can be because of you conditional formatting kindly Check for bug and pressing Cntrl+End key in last cell of every worksheet.

    Hope this helps

    Thanks and Regards

    Monday, October 12, 2020 6:43 AM