Forum Discussion
Tabs in Excel Online worksheet move unexpectedly
For me the tabs move when I have chosen to "Save as Adobe PDF" from the File menu. If I do not ask for all the worksheet to be included in the PDF then all the excluded worksheet tabs are moved to the end of the worksheet tabs when the save has completed.
It feels like there is a bug that has moved the tabs so the worksheets selected for adding to the PDF are all contiguous, but that they have not been reverted to their original positions once the PDF creation process has finished.
The password is optional, so allows others to use the same spreadsheet... they just need to "unprotect" the workbook temporarily if adding sheets. And then remember to protect the workbook structure again.
I can imagine that this may not be convenient for every situation, but it should be a reasonably painless workaround for most.
However, Microsoft, sort out the bug, please. Thank you.
GRKS Thank you for your suggestion. I rarely save my Excel to a pdf so that's interesting you would recognize. My tabs have remained still for quite a while so maybe MS fixed? Unfortunately, protecting all the sheets I manage and share on a daily basis is not ideal and would cause more confusion and frustration. For example, I introduced Excel to my department 4 years ago and the managers are just NOW at the beginning stages of being comfortable and trying things on their own. A simple filter still freaks them out when they can't find their info. It's also not just the tabs that move, it's the column widths that shrink which is infuriating.
