Forum Discussion
Best PC desktop specs for heavy Excel use?
My guess is that the issue you are having is that Excel is running slow.
Excel does things differently from most databases. A database will do the calculations when you want them. A spreadsheet does them when you enter the data and, when you want them, the calculations are already done.
So, the slow bit is when you are entering data and excel is doing calculations. The first place to start is to tell excel to turn off automatic calculations. Go to the Formulas Tab and (on the right) change Calculations to Manual. Now, if you have A1: 2 and A2: =A1*2, A2 will show as 4. However when you put a new number into A2, there will be no pause because the calculations are not being done. So A2 will still show 4. So you can pile in data as fast as you want. Once you have all the data in, go back to formulas and click on Calculate Now (or just press F9). It’ll plough through everything and update all the calculations.
If you then enter data in chunks, leave Calculate as Manual and do a Calculate Now whenever you have finished a batch of entry. If you only occasionally change data, you can switch it back to Calculate Automatically or prefer using Excel Online with O365CloudExperts/PowerQuery for excel.
Try this before spending lots of money on a top of the range computer if it isn’t needed.
Regards,
Akshay
