I have an app where two sessions of Excel are running. Session A is running a labor intensive effort to collect data from an internet source. Session B contains all of the other supportive software to take the input from A and perform work on the numbers without partition A slowing down partition B. Partition A is then running without being made visible on the screen and without any interruptions.
In order to see into partition A without accessing it I have created a viewing window for the purpose of determining how the output of A is going. To create the window, I copied the necessary cells in A and pasted the link in B. The link produces an array formula of the type, and carries a status ofHTML Code:. For whatever reason the array only partially updates and sometimes does not update at all.HTML Code:
Can anyone help me to get this window to update?
Bookmarks