Excel Office 2019 'Table highlighting is disabled because this page uses internet explorer compatibility mode' problem

1. Introduction
2. Excel Quary problem
3. Follow up Excel Quary Problem
4. Follow up Excel 2019 Windows 10 problem solving.

1. Introduction

The 'Table highlighting is disabled because this page uses internet explorer compatibility mode' problem, is an old problem.
To understand do a search with: 'Table highlighting is disabled because this page uses internet explorer compatibility mode''.
You get the following results:

2. The Excel 2019 Query problem

This paragraph is under construction
The purpose of the application to retrieve data from the Web.
There are two ways to perform a Query: Manual or Automatic using Visual Basic.

In the Manual mode select from Excel (Office 2019) program BeursMap13.6.xlsm (Example).
From the Main Operasting display select: Tab 6 i.e., Tab Data.
Select Box 1 Collect Data, Select From the web. A special box 'From the web' will be displayed.
Enter URL https://www.nicvroom.be/ and select 'OK'
Select WebDisplay After that the URL will be displayed. This functionality is working
You can also try the following example:
Enter URL https://www.google.com/finance/quote/BAC:NYSE?sa=X&ved=2ahUKEwjdh4HMu9L2AhUwMuwKHURBCVMQ3ecFegQIAxAi and select 'OK'
Execution of this example shows the following responds: (Web View) Het markeren van de tabel is uitgeschakeld omdat deze pagina de compatibiliteitsmodus van Internet Explorer gebruikt.
Table highlighting is disabled because this page uses Internet Explorer compatibility mode.
Using Google, you can enter: https://www.google.com/finance/quote/BAC:NYSE?sa=X&ved=2ahUKEwjdh4HMu9L2AhUwMuwKHURBCVMQ3ecFegQIAxAi That works and shows the share price of Bank of America.
This is the best reply: "Table highlighting is disabled because this page uses internet explorer compatibility mode" error in Excel 365 https://answers.microsoft.com/en-us/msoffice/forum/all/table-highlighting-is-disabled-because-this-page/43ebb196-b7bd-4cba-8b80-e5bbbb525238

In the automatic mode the test Visual Basic Program Map11.xlsm is used.
The next shows the details

Sub EuroNext_Macro()

Dim DataCH(20) As String
Dim trace As Integer

    trace = 1   'trace
    ioerr = 0
    On Error GoTo Errortrap
    
    ipos = 1
    DataCH(1) = "https://www.nicvroom.be"
    DataCH(2) = "https://live.euronext.com/en/product/stock-options/ABN-DAMS"
    l = Len(DataCH(ipos))
    
    If trace = 1 Then Debug.Print "EuroNext_Macro " + " ipos " + Str(ipos) + " l " + Str(l)
        If l < 2 Then Exit Sub

     Debug.Print "1"
     With ActiveWorkbook.Connections("Verbinding139")
        .Name = "Verbinding139"
        .Description = ""
    End With
    Debug.Print "2"
    Text$ = " Hallo "
    If trace = 1 Then Debug.Print "Euronext_Macro Text$ " + Text$
    Range("A1:A300").Select

    With Selection.QueryTable
        .Connection = "URL;" + DataCH(ipos)
        .WebSelectionType = xlEntirePage
        .WebFormatting = xlWebFormattingNone
        .WebPreFormattedTextToColumns = True
        .WebConsecutiveDelimitersAsOne = True
        .WebSingleBlockTextImport = False
        .WebDisableDateRecognition = False
        .WebDisableRedirections = False
        .Refresh BackgroundQuery:=False
    End With
    
    Range("A1").Select
    
    On Error GoTo 0
    Exit Sub
    
Errortrap:
    ioerr = Err.Number
    Debug.Print "EuroNext_Macro ioerr"; ioerr
    DISDIRERR blad$
    ierr = ioerr
    On Error GoTo 0
End Sub

Normally this program worked as expected.
Roughly one month ago, this changed. Executing the program, showed error 1004.

3. Follow up Excel 2019 .

In order to see the current state of the Quary problem, from the Main Operating display select: Help Tab. Select Feedback Tab.
At the right sight you get a box with: 1) To give a compliment, 2)Report problem 3) Make a suggestion.
Select: Make a suggestion. This will show the form: https://feedbackportal.microsoft.com/feedback/forum/c23f3b77-f01b-ec11-b6e7-0022481f8472 The pages show more than 5000+ feedback discussions, but is worthless if you want to have any serious discussion about a problem. Specific if other users have observed the same problem.

Select: My Feedback
This will show https://feedbackportal.microsoft.com/feedback/mycontent/">
and two boxes with:

one box with information of 17 days ago:

Excel 2019 Query: Table highlighting is disabled because this page uses internet explorer's compatibility mode

This feedback is related to my feedback of 24 August 2023: Excel 2019 Query Error.
I have found this document:
https://answers.microsoft.com/en-us/msoffice/forum/all/table-highlighting-is-disabled-because-this-page/43ebb196-b7bd-4cba-8b80-e5bbbb525238

A second box with information 24 days ago:

Excel 2019 Query Error.
For more than 3 Years I run the following piece of software: Sheets("EuroNext").Select Debug.Print "NickMacro 2 " + Str(Err.Number) * With[…]

Excel 2019 Query Error.
For more than 3 Years I run the following piece of software:
Sheets("EuroNext").Select
Debug.Print "NickMacro 2 " + Str(Err.Number) *
With ActiveWorkbook.Connections("Verbinding159")

No information about the status of this problem. No suggestion. Nothing.
Nobody cares. What went wrong?

4. Follow up Excel 2019 Windows 10 problem solving.

If you try with google: "How do you solve Excel 2019 Windows 10 problems " you get the following answers:

https://support.microsoft.com/en-us/office/fixes-or-workarounds-for-recent-issues-in-excel-for-windows-49d932ce-0240-49cf-94df-1587d9d97093

Fixes or workarounds for recent issues in Excel for Windows
The page starts with the text: "Last updated: November 2022"
That is not very promissing.
Excelforum.com
Maybe this is the route to follow: https://www.excelforum.com/

Feedback

None

Created: 1 September 2023

Back to my home page Contents of This Document