Hello all.

I have code that loops through all excel files in a specific folder, opens
specific excel sheets (one at a time), refreshes the data from an Access DB,
saves the excel file, closes the excel file and loops to the next file.

All the files are set up exactly the same and draw data from the same
database. On 3 of the files I receive the following error:

"This action will cancel a pending refresh data command. Continue?"

The message comes up while executing the .RefreshAll command.

Any thoughts on how to correct this and what may be causing it would be
appreciated.

I am using Excel 2000.

Thanks.