HI
I have a workbook with 4 Power Queries all of them pretty substantial 130,000 rows each and 2 of them grouped to 4000 rows and 800 rows - hope that makes sense.
If I refresh them manually 1 by 1 no problem
If I attempt Refresh All it starts and then hits a limit and bombs out - Excel just shuts down
Only 2 of the Queries need refreshing daily so I tried to uncheck Refresh this connection on Refresh All on the others - still bombs out
I tried this on just one of them - the most important data set and the largest it still bombs out
This dataset also has 432 pivot tables attached to it, across 24 worksheets - Mental I know.
FYI I'm pulling in the dataset as a connection only
Cleaning it to 811 rows which is dumped onto a worksheet
The pivot tables are then built off this worksheet
As I said if I refresh manually one at a time no problem it only causes problems if I Refresh All
Any ideas of a work around or how to fix maybe so the data loads are only consecutively instead of simultaneously
Using 64bit is a non starter - company policy
I have a workbook with 4 Power Queries all of them pretty substantial 130,000 rows each and 2 of them grouped to 4000 rows and 800 rows - hope that makes sense.
If I refresh them manually 1 by 1 no problem
If I attempt Refresh All it starts and then hits a limit and bombs out - Excel just shuts down
Only 2 of the Queries need refreshing daily so I tried to uncheck Refresh this connection on Refresh All on the others - still bombs out
I tried this on just one of them - the most important data set and the largest it still bombs out
This dataset also has 432 pivot tables attached to it, across 24 worksheets - Mental I know.
FYI I'm pulling in the dataset as a connection only
Cleaning it to 811 rows which is dumped onto a worksheet
The pivot tables are then built off this worksheet
As I said if I refresh manually one at a time no problem it only causes problems if I Refresh All
Any ideas of a work around or how to fix maybe so the data loads are only consecutively instead of simultaneously
Using 64bit is a non starter - company policy