Hyperlink Formula slowing down spreadsheet

Hi,

Happy New Year to you all

Ok... I have a macro that creates a formula on a separate worksheet against lines when the index finds the specific reference in cell F34:

=HYPERLINK(INDEX(SI!$E:$E,MATCH(UNBILLED!$F34,SI!$A:$A,0),),"Cascade/How To")

Unfortunately there are thousands of lines and I am noticing that it is slowing down the whole workbook. (Noticed that my physical memory is going upto 99%?) Edit: This only happens when I copy a worksheet from another source and paste over the data in the vba workbook.

So I am really having a punt in assuming that it is the formula as I read somewhere that Formula's slow down workbooks and I was wondering if I can convert the formula to a text cell but keep the hyperlink in the background. I can't see anything else that can cause the issue as everything is just text and date cells

So instead of having =HYPERLINK(INDEX(SI!$E:$E,MATCH(UNBILLED!$F34,SI!$A:$A,0),),"Cascade/How To") in Z34 it will say "Cascade/How To" but the hyperlink still working?

Any help would be grateful?

First thing to try. Fix your column reference so that you only use range where there is data. If entire column is used as reference in MATCH function, it will iterate over each cell and will increase overhead.

Other things you can try are...
- Create hyperlink via VBA code
- Use code to jump to location (no hyperlink, but on double click or some other trigger).