ExcelBanter - External data references in EXCEL 2002

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - External data references in EXCEL 2002 (https://www.excelbanter.com/excel-discussion-misc-queries/21155-external-data-references-excel-2002-a.html)

JSPAIN

External data references in EXCEL 2002

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.

All times are GMT +1. The time now is 04:32 AM.