Sheet view in Excel-online not available

New Contributor

I want to collaborate on a Excel file with some colleagues using excel-online on a company OneDrive and use the sheet view functionality to individually filter the data for each user.

But the sheet view function is not available at all in excel-Online. The view tab looks like this

excelonline.png

 

 

Also when a user filters the data sheet view is not offered as an option.

I used excel2016 to generate the file and is in .xlsx format. Then uploaded it on the OneDrive.

 

What could be the reasons that sheet view is not available?

 

 

 

2 Replies

@ThomasW650 

With Excel Online is that free version or you are on Office 365 subscription?

@Sergei Baklan

It's a company account. I have the Office 2016 desktop version but some colleagues have Office365. The excel-online opens automatically when I open the file on the OneDrive.