**Question description:**

*This user has given permission to use the problem statement for this
blog.*

Hi, my excel file crashes since it is too big, all escess formatting is already cleared. Let me know if you can help in any way. thanks!

Solved by E. C. in 14 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
01/05/2018 - 07:06

Hi

Excelchat Expert
01/05/2018 - 07:06

Welcome to Got it Pro

Excelchat Expert
01/05/2018 - 07:06

Can you elaborate more on the issue you are facing?

User
01/05/2018 - 07:07

Hi, I have an excel file of 8mB

User
01/05/2018 - 07:07

all excess rows and coloumns are cleared

User
01/05/2018 - 07:07

still the file remains too huge

User
01/05/2018 - 07:07

i want to reduce the size

User
01/05/2018 - 07:07

i have converted to xlsb already

User
01/05/2018 - 07:07

hope thats clear

Excelchat Expert
01/05/2018 - 07:08

so you have cleared all the rows and columns?

User
01/05/2018 - 07:08

yes all excess ones are cleared

Excelchat Expert
01/05/2018 - 07:08

The ones that are there is there some formulas that are applied in excel?

User
01/05/2018 - 07:08

yes, lots

Excelchat Expert
01/05/2018 - 07:08

i mean are there vlookup formulas?

Excelchat Expert
01/05/2018 - 07:08

how many rows would be there?

User
01/05/2018 - 07:08

few lookups yes

User
01/05/2018 - 07:09

between 100 to 400 on different sheets

Excelchat Expert
01/05/2018 - 07:09

are there tables or pivot tables that are leading to this?

User
01/05/2018 - 07:09

no tables

Excelchat Expert
01/05/2018 - 07:09

so nearly 400 rows and how many tabs?

User
01/05/2018 - 07:10

i cannot seem to connect the file here or i would have done that

User
01/05/2018 - 07:10

i can possibly share a google link with you

User
01/05/2018 - 07:10

will that help

User
01/05/2018 - 07:10

lots of tabs

User
01/05/2018 - 07:10

over 20

Excelchat Expert
01/05/2018 - 07:10

are there blank spaces between data?

User
01/05/2018 - 07:11

yes on few occasions some rows are blank

Excelchat Expert
01/05/2018 - 07:11

delete unnecessary hidden sheets if there are any

User
01/05/2018 - 07:11

https://drive.google.com/file/d/1JUG643DvWaZByN21ikhvsiGDtBu2qBal/view?usp=sharing

User
01/05/2018 - 07:11

here you go

User
01/05/2018 - 07:11

you can access the file

Excelchat Expert
01/05/2018 - 07:11

you can try to remove automaatic formula

Excelchat Expert
01/05/2018 - 07:11

change that to manual

User
01/05/2018 - 07:12

i already changed to manual

User
01/05/2018 - 07:12

no unused sheets

Excelchat Expert
01/05/2018 - 07:12

we are not allowed to access files on other links as then we need to exchange emails which is prohibited

User
01/05/2018 - 07:13

i have made such models before with over 30 tabs but file size stayed at 3 mb max

Excelchat Expert
01/05/2018 - 07:13

try removing formulas or calculations that are not required

User
01/05/2018 - 07:13

how do i share the file in this suitation, any idea

Excelchat Expert
01/05/2018 - 07:13

you can try to move the sheets into new excel and then make a new file

Excelchat Expert
01/05/2018 - 07:13

that would reduce the size

User
01/05/2018 - 07:13

but the file crashes

User
01/05/2018 - 07:13

if i try to move entire sheets

Excelchat Expert
01/05/2018 - 07:14

such large files are not supported

Excelchat Expert
01/05/2018 - 07:14

for that you have to make formulas manual

Excelchat Expert
01/05/2018 - 07:14

and wait

Excelchat Expert
01/05/2018 - 07:14

may be you are not giving time that is why it crashes

User
01/05/2018 - 07:14

okay can you hold on for a second let me try one sheet

Excelchat Expert
01/05/2018 - 07:14

when size is huge you need to give time to excel

User
01/05/2018 - 07:14

ive waited for over 10 mins

Excelchat Expert
01/05/2018 - 07:14

yes please try

User
01/05/2018 - 07:17

file won't open and my session will probably expire in the meantime

User
01/05/2018 - 07:17

are there any other useful tools or methodds i can try

User
01/05/2018 - 07:18

and i will try them once the file opens

User
01/05/2018 - 07:18

appreciate you trying

Excelchat Expert
01/05/2018 - 07:18

for things to work on you need to open the excel

Excelchat Expert
01/05/2018 - 07:18

Try closing all the excel

Excelchat Expert
01/05/2018 - 07:18

then open a blank excel

Excelchat Expert
01/05/2018 - 07:18

change its formulas to manual

Excelchat Expert
01/05/2018 - 07:18

and save it

Excelchat Expert
01/05/2018 - 07:18

then open the excel you were woking on

Excelchat Expert
01/05/2018 - 07:18

and then shift the sheets to other excel

Excelchat Expert
01/05/2018 - 07:19

this is how it can be done

User
01/05/2018 - 07:19

alright ill try this out

Excelchat Expert
01/05/2018 - 07:19

Yes i understand we have a constraint of time and excel not uploading

User
01/05/2018 - 07:19

thanks anyway

Excelchat Expert
01/05/2018 - 07:19

But please do give me good rating and reviews

User
01/05/2018 - 07:19

sure

Excelchat Expert
01/05/2018 - 07:19

I want to help you in best way

Excelchat Expert
01/05/2018 - 07:19

Let me know if i can help you in any way

Excelchat Expert
01/05/2018 - 07:19

I will be happy to help you

Excelchat Expert
01/05/2018 - 07:20

Hope you understand

User
01/05/2018 - 07:20

i think that was the only issue i had, thanks!

User
01/05/2018 - 07:20

i get it

User
01/05/2018 - 07:20

ill end it now in that case

Excelchat Expert
01/05/2018 - 07:20

You good rating would really help a lot

Excelchat Expert
01/05/2018 - 07:20

Try the method i told you

Excelchat Expert
01/05/2018 - 07:20

That should work

Excelchat Expert
01/05/2018 - 07:21

there may be lot of other things running on your pc

Excelchat Expert
01/05/2018 - 07:21

which might be slowing it down

User
01/05/2018 - 07:21

okay, thanks, will try it out fingers crossed, have a nice day

Excelchat Expert
01/05/2018 - 07:21

try restarting your pc and work on it

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*