Sheet View option for Excel 365

[smalik]

Is there a way to activate "Sheet View" option for Excel 365? I understand that this option is only limited to Excel 2007.

Any advise?

Thanks in advance for the help.

 

[MARK858]

Sheet view is available for all versions after 2007 if your file is saved on Onedrive or Sharepoint under the filter dropdown on a structured table.

 

[smalik]

I don't have the option for "Sheet View" so how do I save the file with that option. I am the owner of the file and like to make it sharable to my team.

Any advise?

 

[MARK858]

As I stated the option is under the filter if you have a structured table and you have saved the file to Sharepoint or Onedrive.

If you don't have the filters then you don't have a structured table (i.e. you haven't selected the range and clicked Insert - Table).

If the file hasn't been saved to Sharepoint/Onedrive then the option will be greyed out.