Hello
I have a simple formula that gets the value in a cell in a closed workbook. The closed workbook is populated and updated by third party software periodically.
At the moment the formula only returns the updated value if I refresh the sheet or double click on the cell and press enter.
Is there a way to get it to show the updated value immediately without manual intervention?
Thank you
I have a simple formula that gets the value in a cell in a closed workbook. The closed workbook is populated and updated by third party software periodically.
At the moment the formula only returns the updated value if I refresh the sheet or double click on the cell and press enter.
Is there a way to get it to show the updated value immediately without manual intervention?
Thank you