I'm populating a worksheet with data from SQL Server.
(Excel 2007)
The chosen method is via a 'Microsoft Query' connection, mainly because this route enables me to map parameter values from cells in the sheet, to my stored procedure.

And it works - yey !

However, I cannot for the life of me get the thing to refresh in background, as I 'understand' I should be able to.

The only setting relating to backround refresh is in the connection properties, under 'usage', there is a section called 'Last Refreshed' and a tick box named 'Enable Background refresh'.
Well I ticked that, but still my whole Excel app freezes up for 2 minutes on each refresh (am refreshing manually).

I guess I might have misunderstood what I believe should be happening here. And I am curious as to the wording in the properties dialogue 'Last Refreshed' - that doesn not make clear sense to me, 'last' ??

Can anyone help clarify if getting data via MSQ is indeed possible to do in the background ?
And obvously ... what am I doing wrong ?

Many Thanks