Someone at MrExcel found the solution for me on the OzGrid site, so simple

ActiveSheet.Calculate

"DDonnachie" wrote:

Hi folks,

Here is my problem today.
I have a workbook that uses external data and can take upto 20 secs to
recalculate all the formulas and data. I was wondering if it was possible to
either refresh specific cells or even a specific sheet. I was planning to
turn off the autocalc function, refresh everything every 5 or 15 minutes and
refresh specific cells between the complete refresh. I believe the main hold
up in the refresh is the retrieval of external data, which is why I would
like to limit this to every 5 minutes or so.

Any help gratefully recieved.