Apache OpenOffice Community Forum

Can anyone tell me what these are and how I can delete them?

Four of them have appeared in my spreadsheet looking like this :

_Anonymous_Sheet_DB1

When clicked after 'data' + 'select range´they go to data ranges I don't remember having created!

There is no sheet named DB1 etc.

They are not visible when I click 'data' then 'define range'.

See attachment for screenshot.

Welcome to the forum!
Was the spreadsheet created by someone else?
Are these sheets visible in the Navigator? (F5)
You can make them visible with Format>Sheet>Show.

Those are created by the AutoFilter process when the filtered range is not already defined as a database range. If you have an autofilter you are no longer using, you can delete it and the corresponding anonymous range will disappear.

Thank you. Removing unwanted autofilters has solved the problem.