Forum

Connecting sheets t...
 
Notifications
Clear all

Connecting sheets to one table - does not work for me, why?

2 Posts
2 Users
0 Reactions
82 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 

Hi, thanks for the help
I have 12 sheets in the attachment and I need to attach them to one sheet
And run Unpivot to sort the months.
To do this automatically - I ran - a new query from the file
And I wrote in the formula bar in Query
= Excel.CurrentWorkbook ()
As I learned in the course I purchased from you.
But it does not work for me here in the file.
Why?
Thanks for the help, Leah

 
Posted : 06/01/2022 10:52 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Lea,

Excel.CurrentWorkbook requires the data to either be in a Table or named range. It cannot see unnamed data. If you don't want to name the data, you can use this technique.

Mynda

 
Posted : 06/01/2022 11:20 pm
Share: