Excel slow respond

[mychi11]

I am using an index match function in another sheet. It will not appear unless I refresh on the matching cell (A4) in this case
=IFNA(INDEX(Master!$E$2:$E$4966,MATCH('CY NO'!$A4,Master!$AL$2:$AL$4966,0)),"")

 

[Michael M]

Ok replace Calculate with Application.CalculateFull

 

[mychi11]

Application.CalculateFull

This doesn't work

 

[Michael M]

Ony thing I can suggest is to add this and run it
It simply replaces the + signs in all formulas with itself, so in reality does nothing, but apparently it is a solution in 2016

Sub InternalRefresh() 
Cells.Replace What:="=", Replacement:="=", LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
 End Sub

 

[mychi11]

Hi Michael,

where do u suggest me to paste the code. I tried pasting in the master sheet. It didn't work too.

 

[Michael M]

In the module where the sheet needs to be refreshed

 

[mychi11]

the solution doesnt work still. Anyway, thank you so much for your help