Apologies if this is not the right place to post this question, but I couldn't find a better suited sub-forum. I deal with fairly large (sometimes up to 150 Mb) and complex Excel spreadsheets on a daily basis. This data is manipulated using both built-in formulas and VBA routines. Excel is my company's default tool because that's what the clients prefer to see and use, but we also use Access and occasionally SQL Server if necessary to do the work.
Unfortunately, some of our VBA routines are starting to take forever to run in the new Windows 8/Excel 2013 environment, and with the source Excel files constantly growing in size it was decided to purchase a new desktop machine that we can use to tackle especially large files or complex models. Would anyone have suggestions as to the PC I should be looking into, which processor/memory are the best? The company is ready to make a pretty significant investment into this, so I am natually interested in what's best on the market.
Thanks in advance!