I am new to VBA so I do not know fully how Excel handles UDF
I have about 33 UDFs that are used for analysing waves, non of them are volatile. I have calculations across 10 worksheets on one workbook with a few thousand cells being used in each worksheet
My issue is that I can type in any cell that is empty with no cells referencing it and when I enter the data in the cell, excel seems to be calculating stuff and this can slow down the use of the worksheet by a few seconds after typing in any cell.
I have tried using the watch window and I can see that all my UDFs seem to do something even though I am typing in non dependant cells
I was hoping someone could help explain why UDFs would seem to calculate when typing in any cell and how to stop it. I want it to stay on automatically calculate but I only want the UDFs to work when a cell they're referencing changes
Any help on this would be very much appreciated, thanks!
Bookmarks