Hello All,
I am not sure what causing it to break - we just upgraded Office 2000 to
Office 2002 but now all my XL with External queries are losing the underlying
sql statement after I do Refresh and Save action.
Open the XL -- Do a refresh -- Save -- Refresh again -- Query is lost!!!
Cannot find any resolution anywhere on the net.
Closest is
http://help.lockergnome.com/office/L...ict576321.html
but no final answer.
Thanks
Triloki