Forum Discussion

Emmylou66

Copper Contributor

Apr 13, 2020

Sheet View

How do you hide columns without affecting other user's views on a shared Excel workbook?

excel

Excel for web

Emmylou66

Copper Contributor

Apr 23, 2020

Amanda_Fasano Since this question was asked I have MORE. There are no "tracking" features on the online shared excel workbooks. Shared! No way to see who or when changes are being made. That is mind blowing.

Patrick2788

Silver Contributor

Apr 23, 2020

Emmylou66

Are you referring to the legacy feature "Shared Workbook"? I can't recommend using this and Microsoft encourages using 365's co-authoring. The old Shared Workbook feature is not the most stable.

Emmylou66
Copper Contributor
Apr 23, 2020
Patrick2788 we are using the shared excel sheet through Office 365. What is "365's co-authoring"??
- Patrick2788
  Silver Contributor
  Apr 23, 2020
  Emmylou66
  Co-authoring is available when the workbook is stored on OneDrive or SharePoint.
  
  https://support.office.com/en-us/article/Document-collaboration-and-co-authoring-EE1509B4-1F6E-401E-B04A-782D26F564A4
  - Emmylou66
    Copper Contributor
    Apr 23, 2020
    Patrick2788 Thank you for this information. I appreciate it. Going to read up and see if this will work. We currently have close to 12 people working out of one shared excel database. It's been a nightmare, honestly. You cannot hide a column without messing up someone else's view, etc.