Get & Transform Data - From Sheet missing

[PATSYS]

Hi all,

When you click Data menu, then look in the Get & Transform Data group, can you see an option From Sheet? I could not find it in mine. Is there a customization in the Ribbon or Command that i need to do to show it?

I am using Microsoft 365 Apps for enterprise version.

Any help will be appreciated.

Thanks

 

[RoryA]

You probably aren't on the required release.

 

[EXCELANS]

Hi all,

When you click Data menu, then look in the Get & Transform Data group, can you see an option From Sheet? I could not find it in mine. Is there a customization in the Ribbon or Command that i need to do to show it?

View attachment 47870

View attachment 47871

I am using Microsoft 365 Apps for enterprise version.

Any help will be appreciated.

Thanks

Hi,

I am facing the same problem. Were you able to find a solution? Thanks in advance.

 

[RoryA]

There is no such option. You can get data from a table/range but not a sheet in the current workbook.