how to stop auto show query table at refreshing

[aboly8000]

[FONT=&quot]hi​
I'm trying to get a few columns hidden with my worksheet using Power Query.[/FONT]
[FONT=&quot]I've tried hiding the columns like you would do normally in Excel, but every time I refresh the query the columns automatically unhide.[/FONT]
[FONT=&quot]What can I do to prevent the Columns from unhiding. [/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Thanks[/FONT]

 

[sandy666]

remove these columns from Query Table

 

[aboly8000]

remove these columns from Query Table

i want automaticaly update this table
i cant remove from query table

 

[aboly8000]

Can't anyone help?

 

[sandy666]

what is you excel version?

edit:
post representative example of source data and expected result - share excel file on Onedrive, GoogleDrive or any similar then post link here

 

[aboly8000]

Hello
I'm using Excel 2016.
I use the following code for refreshall:


Private Sub Worksheet_Change (ByVal Target As Range)
Application.EnableEvents = False
ThisWorkbook.RefreshAll
Application.EnableEvents = True
End Sub


After each table change, the refreshall command is executed and the query table is displayed.
I want the query table to never be seen.

https://doc-14-6o-docs.googleuserco...3236077&hash=k24vve5jf35tfr02tbdsaph17t243bpb

 

[sandy666]

I said SHARE file and post a link to SHARED file

Access to doc-14-6o-docs.googleusercontent.com was denied

btw. do you want hide Query Table or hide columns in Query Table?

if hide Query Table
- Close&Load to...
- Connection only

 

[aboly8000]

http://uupload.ir/filelink/AwJgJ4mYwVFJ/rbzt_new_microsoft_excel_worksheet.zip

i have one pivot table on query table, so i cant remove or close query table.
I just want to not display the query table during refreshall

 

[sandy666]

try this

https://1drv.ms/x/s!AopTvf3RGAN5kzb3xscazGFmOWFS?e=xsGntt

 

[aboly8000]

Please tell me how you did it?