I want to remove all references to external data (ODBC link to SQL server)
from my workbook. I have deleted the columns that contained the data, yet the
named ranges are still showing in the properties page.

How do I remove all the references? This also invokes XLQUERY.XLA macro.