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 tries to do any calculations ?, or is there a way to see that it is actually running, and where it is in it's processing.
Thanks for your help.
Gavin
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 tries to do any calculations ?, or is there a way to see that it is actually running, and where it is in it's processing.
Thanks for your help.
Gavin