G
Guest
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.
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.