Hi, would appreciate any help on this...
I have a PowerPivot which imports 1,988,837 rows from an external connection, it gets to 1,980,000 but doesn't complete.
I'm running 64bit Excel with 16GB RAM, Task manager shows RAM and Disk use near 100%.
Is there a way to import the Rows before it...