forcing DSGRID Excel formula to calculate while a VBA macro is running

hugobrown1

Hi Community

Im use VBA  macros to open many files with DSgrid formula in them, I need them to update their values when they a re opened by the macro. As I'm looping through many files I do not want a manual step that involves stopping the VBA. Is this possible? Below is a screen shot of my formula.

many thanks

Hugo

Jirapongse

@hugobrown1

Thank you for reaching out to us.

This forum is dedicated to software developers using LSEG APIs.

For questions about DSGRID in Excel, please contact the product support team directly via MyAccount.