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.
[Solved] Data range issue anonymous _sheet_db1
[Solved] Data range issue anonymous _sheet_db1
- Attachments
-
Last edited by RoryOF on Mon Dec 08, 2014 3:25 pm, edited 1 time in total.
Reason: Added [Solved] and green tick. [RoryOF, Moderator]
Reason: Added [Solved] and green tick. [RoryOF, Moderator]
Thomas
Open Office 4.1.1
Windows 7 Ultimate
Open Office 4.1.1
Windows 7 Ultimate
Re: Data range issue anonymous _sheet_db1
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.
Was the spreadsheet created by someone else?
Are these sheets visible in the Navigator? (F5)
You can make them visible with Format>Sheet>Show.
Last edited by Alex1 on Sun Dec 07, 2014 7:03 pm, edited 1 time in total.
AOO 4.1.15 & LO 24.8.4 on Windows 10
Re: Data range issue anonymous _sheet_db1
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.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Data range issue anonymous _sheet_db1
Thank you. Removing unwanted autofilters has solved the problem.
Thomas
Open Office 4.1.1
Windows 7 Ultimate
Open Office 4.1.1
Windows 7 Ultimate