Normally, sharing a workbook works perfectly well. However, some features may seem annoyingly uncooperative. One is hidden columns.
Various Excel users have complained that their hidden columns become "unhidden" when the workbook is shared. The primary user does not see the hidden column. But other users see the column, which can lead them to tinker around with data best kept hidden.
To resolve this problem, do the following in Excel 2010. Under the Review tab, click on Share Workbook. Click on the Advanced tab. Under Include in personal view, uncheck the Filter settings box. Click OK.
The hidden columns will now stay hidden for all users with this setting.