Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does sharing a workbook cause columns/rows to unhide?
We have a shared spreadsheet that several people can access and make updates.
Sometimes when one person opens the spreadsheet, all hidden columns/rows reappear. However, if someone else opens the same spreadsheet, the columns/rows remain hidden. What can be causing the columns/rows to unhide for some people and not for others? Ultimately, we would like the columns/rows to remain hidden at all times. Thanks for the help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does sharing a workbook cause columns/rows to unhide?
Do the hidden columns/rows show up when the file is opened -- or when the user
is doing something (like creating a formula and pointing at ranges)? If they show up when the file is opened, I'd look for macros that show/hide the rows/columns. If they show up when pointing at ranges while creating a formula, then have that user turn off Lotus 123 transition settings. In xl2003 menus: tools|Options|Transition tab But either way, be aware that hidden columns/rows is not an effective way to protect information from others. If it's data that others should not see, then don't put it in excel--or don't share that file with people who shouldn't see it. Purrplegrrl77 wrote: We have a shared spreadsheet that several people can access and make updates. Sometimes when one person opens the spreadsheet, all hidden columns/rows reappear. However, if someone else opens the same spreadsheet, the columns/rows remain hidden. What can be causing the columns/rows to unhide for some people and not for others? Ultimately, we would like the columns/rows to remain hidden at all times. Thanks for the help! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freeze panes error when grouping columns and sharing a workbook | Excel Discussion (Misc queries) | |||
Freeze Panes bug when grouping columns and sharing a workbook | Excel Discussion (Misc queries) | |||
Hide / Unhide columns and rows | Excel Discussion (Misc queries) | |||
How to hide and unhide Rows & Columns | Excel Worksheet Functions | |||
sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions |