Cell based on other cell value isn't being updated

[ns_k]

Hello!
I've written simple code in Metatrader 5 that creates OLE automation object (Excel file) and sends real time tickers value to a Named Range in Excel file. So far, so good. But I noticed that when I write a formula on for a cell2 _that belongs to another sheet e.x. sheet2_ the cell2 is not being updated when sheet2 is active and sheet1 is not active. The only way update works is when cell2 belongs to the same sheet as the NamedRange cell. OLE values seem only being updated when the sheet your cell belong to is active. What could be wrong here and could anyone suggest a solution?
Thank you!