Thread: Refreshing an array formula

Hi,

I need to refresh an array formula in a cell that would normally be refreshed by double clicking the cell (connected to an external data source).... but without actually double clicking the cell.

Is there a function available in Excel to do this?

Thanks!

You could add some toimed procedure to recalculate the whole workbook, say every 5 seconds.

I've tried that but unfortunately the cell doesn't actually refresh the data pulled from the array unless the cell is actually double clicked.