Ross Fontana
New Member
Hi,
I am using excel to conduct analysis for a project I am working on. My computer is and I7 6700HQ with 16GB ram. I have a hard drive and an SSD drive to save and work files from.
I have windows 10 and MS Office 2016 Professional
I currently have a file that has 230,000 rows and 105 columns of data. A lot of data.
I am doing vlookups and producing pivot tables to produce some out puts that I use to analyze the data sets.
The processor takes about 3-5 minutes to run a vlookup and will do so each time I update a record. this is time consuming and extremely inefficient.
1. What computer set up is best to handle such large volumes of data and calculation? I would figure that mine was sufficient.
2. Is there something I am doing wrong in the set up that prevents Excel form working efficiently?
I am using excel to conduct analysis for a project I am working on. My computer is and I7 6700HQ with 16GB ram. I have a hard drive and an SSD drive to save and work files from.
I have windows 10 and MS Office 2016 Professional
I currently have a file that has 230,000 rows and 105 columns of data. A lot of data.
I am doing vlookups and producing pivot tables to produce some out puts that I use to analyze the data sets.
The processor takes about 3-5 minutes to run a vlookup and will do so each time I update a record. this is time consuming and extremely inefficient.
1. What computer set up is best to handle such large volumes of data and calculation? I would figure that mine was sufficient.
2. Is there something I am doing wrong in the set up that prevents Excel form working efficiently?