Excel 2013 Pro, 64-bit on windows 7 running on a quad core i5 with 8Gb ram.
All files are local.
The file is averaging about 150 Mb and links to six others which in total average about 100Mb. It has five Powerview worksheets which each reference the one Table range. This Table is 38k rows by 130 columns. Plenty of MATCH and INDEX at work and some VLOOKUP also. COUNTIFS and SUMIFS also, some of these making use of INDIRECT to delimit the ranges they are working with. A first pass recalc averages 1.5 hours. This is not my problem. It's doing a lot with a lot of data. I'm okay with that. I also know that I'm probably not making use of all the functionality available to me and that this model is first generation and has been constructed on an ad hoc basis and some of what it is doing is no longer required and a lot could possibly be designed to be more efficient. What is frustrating me is the two days it can take to write the recalculated file to the hrddrv.
Ive pushed excel to use 512 threads but it didn't seem to affect the save time,
Please if anybody could shed a little light it may at least make my current situation a tad more bearable.
many thanks,
john
All files are local.
The file is averaging about 150 Mb and links to six others which in total average about 100Mb. It has five Powerview worksheets which each reference the one Table range. This Table is 38k rows by 130 columns. Plenty of MATCH and INDEX at work and some VLOOKUP also. COUNTIFS and SUMIFS also, some of these making use of INDIRECT to delimit the ranges they are working with. A first pass recalc averages 1.5 hours. This is not my problem. It's doing a lot with a lot of data. I'm okay with that. I also know that I'm probably not making use of all the functionality available to me and that this model is first generation and has been constructed on an ad hoc basis and some of what it is doing is no longer required and a lot could possibly be designed to be more efficient. What is frustrating me is the two days it can take to write the recalculated file to the hrddrv.
Ive pushed excel to use 512 threads but it didn't seem to affect the save time,
Please if anybody could shed a little light it may at least make my current situation a tad more bearable.
many thanks,
john
