PC Desktop Specs to handle large sets of data ~ Formulas, VBA, PowerPivots etc.

[countryfan_nt]

Hello friends, hope all is well!

I rely heavily on MS Excel on the work PC (desktop). PowerPivots, charts, VBA, formulas and large sets of data (daily bills, customer number of visits, per branch). I want your kind advise and suggestions .

What PC specs do I need placed on my computer. The PC that I currently have hangs and freezes a lot.

Your time and suggestions are truly appreciated in advance


All the Best,

 

[Logit]

.
What are the specs of your present machine ?

 

[countryfan_nt]

======================================
Excel 2013 Professional Plus

Windows 8.1 Pro

Processor: Inter( R ) core i3-3220 cpu 3.30GHz

Installed memory (RAM): 14.0GB (13.9GB usable)

System type: 64-bit Operating System, x64-based processor

 

[Macropod]

I rely heavily on MS Excel on the work PC (desktop). PowerPivots, charts, VBA, formulas and large sets of data (daily bills, customer number of visits, per branch).

So how much data etc. are there? What do the used ranges span & how large is the saved workbook?

I used to work with workbooks with 1million+ cells containing complex formulae on a Win 2000/Office 2000 Pentium system and never had 'freezing' problems.

Have you tried repairing the Office installation (via Windows Control Panel > Programs > Programs & Features > Microsoft Office (version) > Change > Repair)? Have you tried running Excel in Safe Mode?

 

[Logit]

.
I would agree with Macropod. Your machine sounds very capable of handling EXCEL very well.

 

[RoryA]

For Power BI and very large data sets, I would recommend 64bit Office.