Elmura
06-04-2008, 02:37 AM
I have an 8 sheet workbook that has had queries added over a period of time. I wish to delete them all. I have deleted the ranges where the queries have been previously used but if I attempt to create a new query using a name that has already been used, Excel won't allow it.
So these old queries are stored somewhere??? Can't find them however.
Another indication I get that they are still floating in the workbook somewhere, is that the Range name box in the toolbar lists all the queries ever created.
How do I do this?
So these old queries are stored somewhere??? Can't find them however.
Another indication I get that they are still floating in the workbook somewhere, is that the Range name box in the toolbar lists all the queries ever created.
How do I do this?