Excel file too big even when I delete all cells

[holly...@hotmail.com]

My file size is 700 KB for a spreadsheet with little text and few
formulas with links but no macros. I deleted the cells to the right
and bottom of the cells being used and the size stays the same; even
deleting all of the cells in the workbook does not change the size. I
cut the spreadsheet and pasted into a new file and the new file has
the same size as the original. Any ideas? Thanks!

[Pete_UK]

You might have some named ranges defined in the workbook which are no
longer needed. Another common reason for a workbook to increase in
size is for there to be some graphic objects which are no longer
needed. Check also that the file is saved as the latest version, not
as a hybrid (i.e. Excel 5.0/95 workbook).

Hope this helps.

Pete

[Gord Dibben]

After deleting the unused rows and columns did you SAVE the workbook.

Some versions require a sav/close and reopen before changes take effect.

Gord Dibben MS Excel MVP

[Cheng@discussions.microsoft.com Daniel Cheng]

All mentioned methods did not work!!

I tried the following tests and appended my finding:

Test #1
Action Result
Remark
1. Copy "Problem" Excel File to dummy >>OK
Data + Chart
2. Open dummy Excel File >>OK
3. Delete "Slow-motion" Worksheet >>File Size drop dramatically
4. Copy & Paste data from "Problem" file >>File size increase litte bit

Test #2
Action Result
Remark
1. Open "Problem" Excel File >>OK
Data + Chart
3. Delete "Slow-motion" Worksheets' charts >>File Size drop very little bit
4. CLEAR ALL"Slow-motion" worksheet' data
5. Save & re-open Excel File >>File size still same

Any suggestion to fix my problem on using Excel 2003.

Daniel Cheng

[Gord Dibben]

No ideas left.

Gord

[Spiky]

On May 5, 5:09 am, Daniel Cheng <Daniel

> > On Wed, 27 Feb 2008 21:35:43 -0800 (PST), hollymr...@hotmail.com wrote:
>
> > >My file size is 700 KB for a spreadsheet with little text and few
> > >formulas with links but no macros. I deleted the cells to the right
> > >and bottom of the cells being used and the size stays the same; even
> > >deleting all of the cells in the workbook does not change the size. I
> > >cut the spreadsheet and pasted into a new file and the new file has
> > >the same size as the original. Any ideas? Thanks!

Are there objects? Press F5, click Special, choose Objects. If there
are any, the Delete key will get rid of them quickly. Assuming you
really want to get rid of them.

Exactly how much data is there?

[kannanseetha]

Thank you very much..

This helped to fix the same issue I faced the same file size prob.

Deleting the Objects reduced size dramatically..

Regards
Kannan

[danfleming]

In case another solution might help someone else, - I had an excel file with pivot tables that referenced external source data. I tried to save an extract version of the workbook that did not contain the pivot tables or reference the external data, but the workbook file was larger than expected and did not reduce much in size even if all the sheets were deleted. The problem appeared to be that cross-references to the external data were still retained somewhere internally in the workbook. One solution was to go back to a version of the spreadsheet before deleting the sheets containing the pivot tables and other external references, then transfer the external source data into the workbook, making sure there were no additional external links (menu item: Edit / Links), and THEN deleting the various sheets I didn't need including the data that had been transported back in and was not needed for the extract version of the workbook. CAUTION - use a separate copy of the workbook and the source data copied into a separate directory so that the original workbook and its reference links to the source data are not messed up. [note - Other potential solutions to a too-large spreadsheet included looking at the menu item: "format / sheet / unhide". and looking for hidden objects under the menu option: "tools / macro / visual basic editor" but that is for more experienced or risk-taking users.]

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng

[raymond...@gmail.com]

Try this free Tool(docoptimizer.com) , it can reduce the number of styles in use and the number of activated cells.

[George]

Op donderdag 28 februari 2008 06:35:43 UTC+1 schreef holly...@hotmail.com:

I have into this many times, and all of the above (with the exception of one or two objects every now and then) fails. My file grew from less than 300 KB to almost 4 MB.

The solution for my .xlsm file is:

Open the file with the .xlsm extension, then Save as: .xls (tried this several times, the size was reduced in half with the file that was just exploded in size).

Then, because you want to use the .xlsm functionality, open the .xls file and Save as .xlsm again.

Miraculasly the size was reduced back to almost the original level.

I have not tried all possibilities, but changing back and forth from xlsm to xls and back to xlsm again did the trick.

George

[jdq...@gmail.com]

Delete the Rows or Columns that are empty and save voila. Do not delete just the cells but the rows or columns

[benc...@gmail.com]

Something that works for me is to save the workbook in .xlsb which is binary format it reduce the workbook in a 60%

[davidw...@gmail.com]

This worked for me! I have kept files open for so long and tried a million ways to get the cells to remove the content. So simple that I can't believe I never tried before. Excel 2016.

[Auric__]

Bad enough that you effectively posted "me too!", but the original post was
***10 YEARS AGO!!!***

--
This woman seemed flawless because she didn't have enough time to
drive you crazy, as any person you know well will eventually do.