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.
