Share via

how to reduce size of excel file?

Anonymous
2023-07-29T01:14:30+00:00

Hi,

i used to work mostly on excel to maintain data, but eventually the size causing me more trouble, its buffering for a while, screen gets freezing, moreover its file size making it concern to send via email, please help me by guiding how to reduce excel file size.

Note: i tried saving in excel binary format, but it doesn't seem to be effective.

Thanks,

Santhosh

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2023-07-29T06:05:03+00:00

    The usual issue are columns full of formulas that doesn't calculate anything.

    Go from sheet to sheet and press CTRL+END to jump to the last used cell. If you can't see your data from that cell scroll up / left till you see it, select all rows below you data till the end of the sheet and delete the rows. Do the same for columns.

    Locate and reset the last cell on a worksheet - Excel

    In most cases, this will significantly reduce file size/load time and file behavior will return to normal.

    Andreas.

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-07-29T03:43:38+00:00

    Dear Santhosh,

    If the file contains a lot of data such as some hidden sheets, some blank space, some formula and some custom formatting, automatic calculation, picture resolution and pivot table cache and so on, the file size may become large.

    I suggest you check whether there are some unwanted content mentioned above existing in the file you are using first. Clicking on Review>Workbook Statistics in Excel may be helpful to some extent.

    You may manually check whether unwanted and unused content exists in your file and remove them to see the result. If you are using the Automatic calculation, I suggest you change it to Manual under the Formula tab in Excel.

    If you haven't checked other suggestions mentioned in Reduce the file size of your Excel spreadsheets - Microsoft Support, I suggest you check them and take the actions to see if the file size can be reduced.

    Thanks for your effort and time.

    Sincerely

    Cliff | Microsoft Community Moderator

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2023-07-29T08:22:52+00:00

    thanks for your time

    0 comments