Question description:
This user has given permission to use the problem statement for this
blog.
if you want to process over 70,000 cells of excel data what is the prescribed computer systems
Solved by D. H. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
04/06/2018 - 07:36
Hello, how are you?
Excelchat Expert
04/06/2018 - 07:38
65536 is the maximum number of spreadsheet rows supported by Excel 97, Excel 2000, Excel 2002 and Excel 2003. Text files that are larger than 65536 rows cannot be imported to these versions of Excel. (Excel 2007, 2010 and 2013 support 1,048,576 rows
User
04/06/2018 - 07:45
over 1,000 employees
User
04/06/2018 - 07:45
we are using Excell 2007
User
04/06/2018 - 07:46
and am in bank reconciliation team
Excelchat Expert
04/06/2018 - 07:46
Hello, thanks you are back I thought you had left without getting assistance
Excelchat Expert
04/06/2018 - 07:47
What exactly is your issue?
User
04/06/2018 - 07:47
and when am trying to sort the data it is very slow and sometimes takes a day or more pls
User
04/06/2018 - 07:48
or sometimes it will hang half way
Excelchat Expert
04/06/2018 - 07:49
What you need to do is change your microsoft office version to 2010 or a later version. This will accommodate all your data up to over 1 million rows
Excelchat Expert
04/06/2018 - 07:50
Then go to the tool bar and click on the formula tab, at the top of your excel sheet
Excelchat Expert
04/06/2018 - 07:51
After clicking the formula tab, choose calculation option
Excelchat Expert
04/06/2018 - 07:52
Are you still there?
User
04/06/2018 - 07:53
yes sir
Excelchat Expert
04/06/2018 - 07:54
Then choose the option "automatic except for data tables". This will make the machine to stop hanging
Excelchat Expert
04/06/2018 - 07:54
Are you able to do that?
User
04/06/2018 - 07:56
i cant found tool on my new excel open
Excelchat Expert
04/06/2018 - 07:57
not tool, at the top of your excel sheet there is a tab labelled formulas
Excelchat Expert
04/06/2018 - 07:58
Can you see it?
User
04/06/2018 - 07:58
yes
Excelchat Expert
04/06/2018 - 07:58
Click on it
User
04/06/2018 - 07:59
i have already
Excelchat Expert
04/06/2018 - 07:59
Then look for a label called calculation options
User
04/06/2018 - 07:59
then what next
User
04/06/2018 - 07:59
yes
Excelchat Expert
04/06/2018 - 07:59
click on it
Excelchat Expert
04/06/2018 - 08:00
Then choose the option "automatic except for data tables"
User
04/06/2018 - 08:00
ok
Excelchat Expert
04/06/2018 - 08:00
are you able to do that?
User
04/06/2018 - 08:00
then what about the main complain
User
04/06/2018 - 08:01
i have done that
Excelchat Expert
04/06/2018 - 08:01
That is mainly to make your machine function without hanging
User
04/06/2018 - 08:01
i mean taking longer time to sort data (custom sorting)
User
04/06/2018 - 08:01
ok
Excelchat Expert
04/06/2018 - 08:03
Then to accommodate more rows, ensure you change your excel to a latter version
Excelchat Expert
04/06/2018 - 08:03
I hope that will solve your issue completely.
User
04/06/2018 - 08:05
later version of what year pls
Excelchat Expert
04/06/2018 - 08:05
Do 2013 or 2016.....they are the best
User
04/06/2018 - 08:05
yes we are presently using 2010 pleaee
Excelchat Expert
04/06/2018 - 08:08
I hope I have been of assistance to you
User
04/06/2018 - 08:09
yes u are my brother
User
04/06/2018 - 08:10
but presently we are using 2010 version
User
04/06/2018 - 08:10
and the work is still slow
Excelchat Expert
04/06/2018 - 08:12
And have you adjusted the calculation option as i have advised?
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.
