I have two worksheets in an excel file in which I can't paste copied data within the worksheet. I click on the next cell after copy and the rotating dashes disappear or when I right-click the paste function is grayed out and nothing happens. Each of the two worksheets have data from loaded tables refreshed by power queries. I added a searchable list to each of these tables to create named range drop down list on each worksheet. Could this be the issue?

I have have narrowed down the specific issue today. The issue is when I created the searchable list for multiple cells I need to go into VBA for the worksheet and put in the following:

Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.Calculate End Sub

This will auto calculate the worksheet each time a cell is selected within the worksheet and refresh the search list so that it is not stuck on the last search from another cell in the workbook. I am not certain but believe what is needed is to modify the VBA code to auto calculate for the specific cells or range that have the searchable drop down list. However, I do not know the code to make this happen. Any suggestions? I hope this is clear.

I have two worksheets in an excel file in which I can't paste copied data within the worksheet. I click on the next cell after copy and the rotating dashes disappear or when I right-click the paste function is grayed out and nothing happens. Each of the two worksheets have data from loaded tables refreshed by power queries. I added a searchable list to each of these tables to create named range drop down list on each worksheet. Could this be the issue?

I have have narrowed down the specific issue today. The issue is when I created the searchable list for multiple cells I need to go into VBA for the worksheet and put in the following:

Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.Calculate End Sub

This will auto calculate the worksheet each time a cell is selected within the worksheet and refresh the search list (as if you manually clicked "Calculate Now" on the Formulas bar) so that it is not stuck on the last search from another cell in the workbook. I am not certain but believe what is needed is to modify the VBA code to auto calculate for the specific cells or range that are specifically using the searchable drop down list. However, I do not know the code to make this happen. Any suggestions? I hope this is clear.

I have two worksheets in an excel file in which I can't paste copied data within the worksheet. I click on the next cell after copy and the rotating dashes disappear or when I right-click the paste function is grayed out. Each of the two worksheets have data from loaded tables refreshed by power queries. I added a searchable list to each of these tables to create named range drop down list on each worksheet. Could this be the issue?

I have two worksheets in an excel file in which I can't paste copied data within the worksheet. I click on the next cell after copy and the rotating dashes disappear or when I right-click the paste function is grayed out and nothing happens. Each of the two worksheets have data from loaded tables refreshed by power queries. I added a searchable list to each of these tables to create named range drop down list on each worksheet. Could this be the issue?

I have have narrowed down the specific issue today. The issue is when I created the searchable list for multiple cells I need to go into VBA for the worksheet and put in the following:

Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.Calculate End Sub

This will auto calculate the worksheet each time a cell is selected within the worksheet and refresh the search list so that it is not stuck on the last search from another cell in the workbook. I am not certain but believe what is needed is to modify the VBA code to auto calculate for the specific cells or range that have the searchable drop down list. However, I do not know the code to make this happen. Any suggestions? I hope this is clear.