Combine hidden excel tabs from multiple excel files located on sharepoint drive

[Nico_Beckers]

Hello, 

I want to load data from 30 identical excel sheets for different dates that are located on sharepoint. I do not have edit rights on that sharepoint, uploading an identical excel file with the specific tabs unhidden for one file is not possible.

The data I need is in a hidden tab and I can't seem to find a way to load them all. 

When I select binary in the content column I can select the hidden tab, but this only works for the one file I selected 'binary'.

What I want to achieve is combining all my excel filles for the hidden tab.

Any thoughts?

Many thanks.

Kr,

Nico

[RMDNA]

Hi @Nico_Beckers - if you select the double-down arrow in the Content header, you should be able to open multiple tabs and append them into a single table directly within that query