Hi,
Currently I have a workbook that has formula that link to another workbook.
Problem is the formula result is not updated if not open the linked workbook.
How can I make it update without open the linked workbook?

I notice that if the linked formula is only a few of it, it will update even the linked workbook is not open.
But if there are many formula that link to another workbook, then it will not update.

Any advice?