New Excel Worksheet not showing

[ArchStanton]

I have several times in the past added new Excel worksheets to the Excel workbook that my report is linked to.

I have just added a new worksheet, pressed Refresh All in Editor mode (Power Query) and its not appearing.

Has something changed with all the new updates that I am not aware off?

Thanks,

[Ritaf1983 · Accepted solution]

Hi @ArchStanton 
You need to modify the steps in pq to make the addition of worksheets work.

Please refer to the linked tutorial:

https://www.youtube.com/watch?v=gQo5coD9c4M&t=3s

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly