calc crashes when trying to open excel sheets which are more than 200 kb

some sheets in .xlsx books having 10 sheets and above are not loading and libre office crashes, using version 5.1.5 on my windows 10 pc. have uninstalled and reinstalled but issue not solved.

Please try resetting the user profile, sometimes solves strange issues.
https://wiki.documentfoundation.org/UserProfile
Usually it’s enough renaming/deleting the file “user/registrymodifications.xcu”, it affects all the options in Menu/Tools/Options, and the files “user/basic/dialog.xlc” and “scrip.xlc” are overwritten, additionally custom colors in “user/config/standard.soc” are lost.