Range names

[Guest]

I imported external data (from Access) into a worksheet and named the range
in the External Data Range Properties dialog.

The format of the external data has changed so I deleted the query and then
the range name (using the Insert => Define => Name menu) and reimported it.

However I cannot give the query the same name as I get the message 'A query
with this name already exists in this sheet'.

There are no links to external files and no other worksheets in the workbook
containing this name. I also tried deleting the range, saving and closing,
then reimporting, without success.

It is essential that I use an identical range name as there are many
formulae in other worksheets within the workbook dependent on this. What is
causing this problem?

 

[Guest]

hi,
did you do this with microsoft query(get external data)
If you did you may have deleted the data but not the query.
click in top left corner of where there query was.
then go data>get external data>properties.
uncheck the top box(something about query definition)
you should get a message about removing the query. click
yes.
if you didn't do it with Microsoft query, disregard this
post.

regards.