Force UDF in new workbook to refresh

**jakc** · 06-23-2015, 11:59 AM

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

**6StringJazzer** · 06-23-2015, 12:36 PM

Can you try double-clicking the cell containing the formula (or select it then hit F2), then hit ENTER? That should force the function to recalculate. How many cells these this UDF? What is the formula?

Changing it to Volatile might not be a great idea anyway, but why can't you change it--no access to the code? What does it do?

**jakc** · 06-24-2015, 03:50 AM

There are over 100 cells containing the UDF formulas which come from a 3rd party financial add-in, I can't mess with that.
When the workbook is opened via VBA the UDF results in #NAME? any attempt I have made to recalculate through VBA fails.

I have tried inserting a wait command after the calculate, and also limiting the calculate to the range, sheet, workbook but all to no avail
Here is a sample of the code which does open the file correctly.

Please Login or Register  to view this content.

**jakc** · 06-25-2015, 04:50 AM

Ok further investigation has narrowed this down to being a Thomson Reuter dll named 'EikonOfficeShim.dll' several other threads I have found indicate using app.run but I can't see a reference for dll's