I used to have several databases (several xlsx files), each of which ~340kB. Each of them in one template. Each of them has 140 rows (remaininh have been removed). Some of those files, however for no reason grew up to 3,1 MB and it lasts quite long to open them.

Any effort to edit them, e.g. removing 1 columnt or one row is impossible as the program says there's not enough resource for it. OFC it is silly, my PC is really fast and it happens even if I try ti remove empty column or groups of cells.

Is anybody able to help me?

Hi,

According to your description, this issue might be caused by the file size of an Excel workbook unexpectedly increase exponentially.

We may try to reduces file size and check if it is helpful. Here are some methods that worked for some customers, I copied here.

Method one:

one of reasons for increase in file size may be pivots, apart from that the issue may occur if :

1. Have blank characters in empty cells
2. Unwanted formatting in cells (example :say you have formatted the entire row/column with a particular color, where in you do not require that in all the cells)


Solutions/Workarounds :

1. How to remove the cells with blank character:
- Select the entire worksheet
- Press F5 on the keyboard, this would bring up the "GO TO" window
- Click on Special
- Select Blanks and then click OK
- Click on the Edit menu and then click on clear contents

2. Download and install the addin :Microsoft Excel Excess Formatting Cleaner Add-in to clear unwanted formatting:
http://www.microsoft.com/downloads/details.aspx?FamilyId=ECFD076C-B873-48CC-B842-DA999C848C82&displaylang=en

3. Save the file as .XLSB, it reduces file size.


BLACK BARRON


P.S : Please post back with status. If this post has helped you, please vote for my post
        If my suggestion resolved your issue, please mark my post as answered.

http://answers.microsoft.com/en-us/office/forum/office_2003-excel/unexpected-increase-of-an-excel-file-size/0a9c6c6d-d019-4321-835a-257de72a4589

Method Two:

Go to each and every sheet of the file. Press 'End' and then 'Home' button. It will take you to the last cell which excel recongnising as your last range cell and putting it in to memory.

You will find that this cell where cursor has gone is far below and right side of the actual range used by you.

Now delete the rows and columns which are in excess from your actual cell to cell which persuming.

Do it for all sheets and save the file.

It will reduce the file tremedously.

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/the-file-size-of-an-excel-workbook-may/1fbe1047-c1be-4f18-90d4-9e2c538167ff

More reference:

https://support.microsoft.com/en-us/kb/930253/en-us

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support