how to stop auto show query table at refreshing

aboly8000

Board Regular
Joined
Sep 4, 2019
Messages
59
[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]
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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
 
Last edited:
Upvote 0
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
 
Upvote 0
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
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,040
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top