Worksheet Crashes

Giganews Newsgroups
Subject: Worksheet Crashes
Posted by:  Paul Williams (anonymo…@discussions.microsoft.com)
Date: Thu, 16 Oct 2003

I have created a macro using ontime to go to a pivottable
(which is running from an external odbc data source)
refresh the data and return to another sheet. After 20
times of the macro running it fails to refresh the data
and the workbook crashes (all was running fine up to this
point). I have run the macro with On Error Resume and
after 20 times it just misses out the refresh and carries
on with the rest of the macro and does not crash. Is there
any hidden setting anywhere where it is only allowing 20
refreshes per session as after crashing or closing I can
re-open and run again for another 20. My data source was
set up using Microsoft Query.

Replies