Why do my Excel files become huge?

Is Excel file stored on a network share and accessed by multiple users?

Also consider people (you or others) adding huge images.

And perhaps the file is damaged. Copy it down locally, copy the contents and make a new Excel file. This almost always works.

Hi the file is stored in the network in our server. All users can access to it but only one user can edit document at the same time.

One User at one time is normal. There were some collaboration features built into Excel 2016, but I have not yet enabled these. We use Office 2016 at clients and the file is available but locked except to the user editing.

John,

How to disable this features ? "collaboration features built into Excel 2016"

There is a setting to prevent collaboration.   Here is a good description

https://excelribbon.tips.net/T008487_Turning_Off_Sharing.html

John,

I could not find this setting in Excel "Display the Review tab of the ribbon. "

Is it not here?

Reason why I ask about file being used on share sheet (article about older Office though)
https://support.microsoft.com/en-us/help/930253/the-file-size-of-an-excel-workbook-may-unexpectedly-increase-exponentially

Qlemo

you mean open 7zip and open archive?

I can see that one worksheets is huge when I added the excel file into the archive.

But what next ?

Did you try locally remaking the worksheet as suggested?

As per Qlemo's suggestion, check sheet64 in the Excel file

Hi I cannot open Sheet64 I'm getting error.

That sheet is corrupt

As I noted above the sheet may be damaged.

 this is the error

And perhaps the file is damaged

Very broad statement. Qlemo's suggestion isolated the issue to the actual sheet in workbook

You said what I said. Bye All.

Can you post file via dropbox link or the similar

Okay thanks.

So the question now is why this file became corrupted?
whats user could have done wrong ?

Shaun Sorry I cannot.

Can only say if you can post file

That sheet is 1GB large, so your options are restricted. I cannot remember if you just can extract the XML file as .xls and open it.

But if you still can open the XLSX file, do so and copy the content as suggested above into a new worksheet or workbook, then delete the sheet, save and reimport the copied sheet.
That will not show what is the cause, but from my experience t repairs enough it does not happen again.

Cheers guys