Hi
Using VBA I am opening an workbook which contains 3rd party UDF's to extract data for my totals. However the UDF no longer calculates, I cannot change it to volitile.
forcing the range, sheet, workbook and application to calculate does not fix the issue.
I have tried opening the file with UpdateLinks:=3 and this also is not forcing the refresh.

Any ideas where to start?

thanks in advance for the scathing comments about my stupidity