Known problem. Any time you “touch” the .ListOfValues object, it actually REFRESHES the darn thing! And if there is no data when it refreshes, you’ll get that message too. In this utility … Document a universe using Excel and the Designer SDK … I finally just gave up and skipped that property altogether.
As far as a property that tells if Designer is busy, no. But there is an Application.DisplayAlerts (or something like that) property in Excel that will suppress those annoying “waiting for response” warnings from popping up. It will still be slow becaues of the above, but give it time and it likely will eventually finish.
Dwayne Hoffpauir 
(BOB member since 2002-09-19)