I currently have a 6 month old Dell Vostro 470 with Intel Core i7 quad processor 3.4ghz processor and 8gb SDram, 2tb hard drive and 1gb graphics card. I run Office 2010, but 99% of my work is in Excel and specifically Pivot Tables.
I run large Excel spread sheets typically size around 200-300mb built around a data sheet that may have up the 1m row limit and 200 columns. A quick glance shows that I have 1000mb files (what is that 1gb?, 1m kb if I have that right) which seem to open quite quickly, less than a minute, but on all my large files I do have issues around crashes, being able to refresh the pivot.
Typically I may have 20 worksheets in a workbook all relating to the same source data sheet, which may be in the same workbook or in a separate workbook on the same pc.
I have two queries. Where best to go for advice on the best PC spec for my type of work (if not here)? and specific advice realting to a purchase. I am contemplating a dell Optiflex and wondering if a 32gb SD RAM memory will give worthwhile extra performance against the 8gb that I have now and whether Dell has better processors that might suit me better.
I do find that on current Vostro 470 system with my 8gb quad processor, an Excel spread sheet will stop working when it exceeds a little more than 1.5gb memory according to task manager (How does that relate to 8gb of SDRAM?).
Often I have a number of workbooks open to enable the pivots to refresh. Usually it just says insufficient resource. I have found it useful to have the Pivot source data as a CSV file to reduce size, but I still find myself constantly having to adapt some spread sheets so that if the pivot source data file is only 500,000 rows then sometimes I have to limit the Pivot source to that number (rather then 1m) which is difficult if the size increases next time I need to refresh the pivots.
So I have these issues around the ability to update (refresh) Pivot tables, the size of workbooks I can open and to a degree the speed that my pc will calculate, even though I often have to work with worksheets that do not recalculate automatically ie I turn off automatic updates, so that it works efficiently.
2 KEY QUESTIONS:
- Where best to go for advice on how to manage large data sheets/ pivot tables?
- What spec of pc to go for optimum efficiency of my Excel/ pivot table needs?
I SPENT JUST LESS THAN 1,000 with Dell on my last Dell Vostro 470 (including Office 2010).
- Should I go for a Dell Optiflex and pay extra 400 to get 32gb SDRAM and could I spend even more to improve my work efficiency?
- How fast are the fastest Processors and can I improve much on what I have with my Dell Vostro 470
- Are there any other PC's out there I should be considering?
- I sometimes get messages like insufficient resources to display correctly. Do I need a better graphics card?
Not quite sure which forum to go for, so advice especially appreciated.