Forum Discussion
JW2020
Feb 11, 2020Copper Contributor
Hidden tabs showing for other users in shared file
I have a shared file saved on our network. It has many tabs, one for each week of the year, for a large remote team to enter data on weekly. There are then summary tabs to analyse the data. I have hidden most of the tabs, with currently only the January and February weeks showing, to make it easier to use / less scrolling through tabs. However, some users when they open the file, cannot see the same tabs as me - for example, the February ones are missing. They are able to Unhide them themselves, but why would the view be different for different users? Is there a setting on their laptops which means it doesn't show the same? When they enter data and save the file, the data shows when I open it, so they are using the correct file and it works. It is a Shared File so multiple users can enter data at the same time, and I have not used the new co-authoring feature, just the legacy Shared Workbook feature. I do not want to protect the file or lock it down, I just want it to show them the relevant tabs when they open it. Does anyone have any ideas? Thanks in advance.
3 Replies
Sort By
- Hello, once you have hidden all the tabs except the January and February tabs and you saved it... Other users, when they open the file, should be able to see only the two tabs - Jan and Feb... That's how it works
For some not to be able to see the Feb on their laptop, there is something wrong.
Just try to send the same workbook via email to one of them with all tabs hidden except Jan and Feb... Confirm whether when they open the file, they are able to see the only two tabs..- JW2020Copper Contributor
Thank you Abiola1
I know, it's weird isn't it? I did a screenshare on Teams yesterday afternoon with one of the users, and could see when he opened it that some tabs were missing, and yet when I opened it they were there. I wonder if it's something to do with when they are accessing it remotely from the network, I will try emailing it to see if it works - but they will need to access it on the network normally, as all users need to edit the same version of the document. Thanks!
- Alright. Try to email it and see if it works