Filter button doesn't work after changing worksheet name

[Former Member]

I am using Bex 7.10. I have a workbook with 2 queries. I want to change the name on the Tab for each sheet but when I do that the Filter and Information buttons no longer work. Is there a way to do this?

[Former Member · Accepted solution]

Check in the Design mode and right click on the Filter tab and check do you see all the filters listed?

If not you can reinsert the query to a new workbook and try.

@AK

[Former Member]

I went into the VB editor and saw all the places where the sheet name is used, about 20. probably more work than it is worth to try to change it.