wsnyder
Board Regular
- Joined
- Sep 23, 2018
- Messages
- 224
- Office Version
- 365
- Platform
- Windows
Hi all,
Using Excel 365.
Is my the background refresh false tripping over another background refresh?
I'm getting
Thanks,
-w
Using Excel 365.
Is my the background refresh false tripping over another background refresh?
I'm getting
There are 4 worksheets each with 1 Table created from Power Query Close & LoadRun-time error '1004':
Microsoft Excel is refreshing some data. Please try again later
VBA Code:
With wb
For Each ws In .Worksheets
For Each lo In ws.ListObjects
lo.QueryTable.BackgroundQuery = False
Next lo
Next ws
End With
Thanks,
-w