Skip to Content
Former Member
Mar 13, 2007 at 10:39 AM

how to detach/delete queries from workbooks


One of our users has a huge workbook with over 200 queries. He wanted to remove part of the queries but instead of deleting the queries he removed the excel tabpages with the queries as a result of wich the connection with the queries is still there.

Is there a way to remove the connected queries without having to remove all queries ?

Refreshing all queries is not an option.

I also tried to remove the records in table RSRWORKBOOK but this also didn't remove the connection, after opening and saving the workbook in Bex, the removed records in RSRWORKBOOK appeared in the table again.