Excel query does not refresh when I use the entry form to enter data in a table

%3CLINGO-SUB%20id%3D%22lingo-sub-3086229%22%20slang%3D%22en-US%22%3EExcel%20query%20does%20not%20refresh%20when%20I%20use%20the%20entry%20form%20to%20enter%20data%20in%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3086229%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20Excel%20refresh%20query%20when%20I%20use%20entry%20form.%3C%2FP%3E%3CP%3EIf%20I%20enter%20the%20data%20directly%20to%20the%20table%20the%20following%20code%20work%20fine%2C%20but%20when%20I%20use%20the%20entry%20form%20does%20to%20refresh%20automatic.%3C%2FP%3E%3CP%3EPrivate%20Sub%20Worksheet_Change(ByVal%20Target%20As%20Range)%3C%2FP%3E%3CP%3EThisWorkbook.RefreshAll%3CBR%20%2F%3EEnd%20Sub%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3086229%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I need help with Excel refresh query when I use entry form.

If I enter the data directly to the table the following code work fine, but when I use the entry form does to refresh automatic.

Private Sub Worksheet_Change(ByVal Target As Range)

ThisWorkbook.RefreshAll
End Sub

0 Replies