Hello,
Three of my users (Amanda, Beth, and Rose) have a shared spreadsheet file. It is a large file with 30 tabs and ton of information.
Last week they took 10 tabs each and did their edits. Whatever data three of them entered or edited, got saved and shows up on each computer when they open it. HOWEVER, whatever rows or columns each one of them set to be hidden does not show for each of them. Instead, those changes were saved in Custom Views. So, now there are custom view for each use, and you can toggle between each view and see what cells each one of them hid. If you click "Amanda Custom Views", you can see hidden rows in first 10 tabs that Amanda was working on, but remaining columns and rows appear unchanged in Beth's and Rose's tabs. If you click "Beth Custom Views, you can see Beth's hidden columns and rows, but Amanda's no longer appear hidden. I need to combine these views before it can be sent to a client. How can I do that?
IF I can not do that, what should they do in the future to avoid this issue?
Three of my users (Amanda, Beth, and Rose) have a shared spreadsheet file. It is a large file with 30 tabs and ton of information.
Last week they took 10 tabs each and did their edits. Whatever data three of them entered or edited, got saved and shows up on each computer when they open it. HOWEVER, whatever rows or columns each one of them set to be hidden does not show for each of them. Instead, those changes were saved in Custom Views. So, now there are custom view for each use, and you can toggle between each view and see what cells each one of them hid. If you click "Amanda Custom Views", you can see hidden rows in first 10 tabs that Amanda was working on, but remaining columns and rows appear unchanged in Beth's and Rose's tabs. If you click "Beth Custom Views, you can see Beth's hidden columns and rows, but Amanda's no longer appear hidden. I need to combine these views before it can be sent to a client. How can I do that?
IF I can not do that, what should they do in the future to avoid this issue?
