I have created a script which successfully creates and populates a
local .cub file.
I examine it with Excel (2003) and all is well.

I then re-run my script which deletes the original .cub file,
recreates it and populates it again with current data.

If I then go back into my Excel spreadsheet and refresh the pivot
table, the MSQuery wizard pops up and tells me it can't find
"localhost" - fair enough.. so I point it to the .cub file that it was
set to look at and MS Query hangs.

Does anyone have any ideas on what I'm doing wrong?


Thanks - MC