Why does Navigator show non-existent sheets in Calc?

The Navigator shows “Sheet2” and “Sheet3” but there are no sheet tabs with those names (see screenshot).

How do I prevent the Navigator from showing sheets that don’t have tabs?

Navigator tabs.JPG

Which OS and LO-Version do you have? I have one spreadsheet and only that is displayed in the navigator. With me Windows 10, Version 1809, 64-Bit | LibreOffice, Version: (x64).


It appears those may be sheets which were hidden. Right mouse click on an existing Tab or blank part of tab bar & select Show Sheet. A dialog will pop up & allow hidden sheets to be revealed.

You are so right. I should have thought of that.
Glad that you are available to answer so many questions so well.

Surely I don’t have an answer to all your questions (deal mostly in Base) but certainly glad to help if I can where I can.