**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.*