Refresh All Crashes PQ, Individual Query Refresh works correctly

[ghull99]

I have a set of queries that seem to behave oddly. If I do a 'Refresh All' the refresh never ends, but if I refresh individual queries in the order that I would anticipate their execution it only takes a few minutes - and most of that is me button clicking.

To do the manual refresh I click first on qrySource, then each of the detail queries followed by the summary, which as I've said works as expected. Unfortunately, I can't get directly to the summary from the source as the processing in each detail query is required.

When doing a Refresh All, very quickly the qrySource loads data and reports that the number of rows have been loaded, which seems correct. The detail queries then seem to get stuck at 'Loading Data.....' with a little spinning circle of dots. Even when I left it running in the background for several hours nothing seemed to happen. If I remove the qrySummary the refresh works as expected so it is the bottom set of links that seems to be causing the problem.

I really would be grateful for any ideas or suggestions.

 

[Misca]

Try unchecking the "Enable background refresh" on the query properties.

 

[ghull99]

Try unchecking the "Enable background refresh" on the query properties.

This has made my excel close and crash.