Worksheet_SelectionChange not working in Excel 2016

  • I have a file that takes the data from a row and puts it into a chart, if you select a different row you get a different chart.
    This works well in Excel 2007, we are changing to 2016 and the code is not working.
    I have looked through many posts but can't get the answer that works.
    I have tried

    Code
    1. Application.EnableEvents=True

    ...does not help.
    This is what I use:

    Code
    1. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    2. If ActiveCell.Row > 2 And ActiveCell.Row < 500 Then _
    3. ActiveSheet.Calculate
    4. End Sub


    Any suggestions?

  • Re: Worksheet_SelectionChange not working in Excel 2016


    I'm sorry about the code tags, I am very new to this.
    When I click on a cell the chart does not update as it does in Excel 2007

  • Re: Worksheet_SelectionChange not working in Excel 2016


    If you open the file in Excel 2007 and click on row 4 or 5 the chart will populate.
    If you open the file in Excel 2016 it does not work.


    Thanks for the help!

    Files