Avatar of Vladimir Buzalka
Vladimir Buzalka
Flag for Czechia asked on

Excel file is too big compared to few data it contains

Dear Experts

I have excel table which contains just few rows and columns of data. Originally table was big with many sheets and lot of data, but before I receive it, sender removed all sheets and left only single sheet with one summary table.

Problem - excel file is BIG - 24 MB.

I tried simply thing, created new sheet, empty one and DELETED the original one with summary table, saved and ...... size is the same.

So now, I have excel file which seems to be very empty, just having 24 MB.

Can you advice where is problem and how to shring size down to something reasonable?

Thanks

Vladimir
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Benjamin Lu

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
strivoli

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Vladimir Buzalka

ASKER
Hi, 12 kB .-)

So I know this would be easy workaround, but just curious, what is in that bloody file which makes it so big?
Kimputer

It happens with long running files where things are added, deleted etc over years and years. Call it a bug, but it has existed in most Excel version for the past few decades.

strivoli

An Excel File might:
a. have several hidden "Sheets".
b. be connected to a Data Source that stored large amount of Data in the Excel File itself.
c. was very BIG and AFAIK there is no "Auto Shrink".
d. ...

What you've got is what happens to me and my Users every now and then and usually happens with Files connected to Data Source. There's little you can do but Copy/Paste. Regards.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Tom Farrar

Kesavan Jeganarayanan

Benjamin Lu

Usually, it caused by following:
1.Millions of  condition format
>Click condition format to clean it

2.Invisible object/shape (copied again and again by user)
>Ctrl+G >Object, then you will find all objects,  delete all if you do not need it
>Another way, select one object or shape, go to format menu, click show all; you will all objects/shapes, delete the one you do not need it.

Usually, user copied data from web site or other web based report may cause this issue.

If it's OK, you can upload the file, I can help to find if it's really big or not.

 obj.jpg
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.