Forum Discussion
Tabs in Excel Online worksheet move unexpectedly
We use a shared Excel Online worksheet that is concurrently accessed by approx. 50 users. The tabs are all named by date and we keep about 3 months of dates available at any time. Periodically, the...
I have also been having tabs move after "Save as Adobe PDF"... it definitely appears to be a bug (that should be fixed, please) but the very first solution in this thread works for me... Review > Protect Workbook > (Structure)
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.
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.