Solved: External data problem

[clif]

There is external data from the web in my excel. Some of the data may not be refresh successfully. So the warning ask you to confirm whether to continue other external data. How to get rid of the warning and let the refresh external data without pressing any button. Thanks!

[Scooter172]

There is external data from the web in my excel. Some of the data may not be refresh successfully. So the warning ask you to confirm whether to continue other external data. How to get rid of the warning and let the refresh external data without pressing any button. Thanks!

I use a shared workbook to query a non shared work book to get a web query, then it copies and pastes to my working book. Is the work book you adding data too shared? Could you give me an idea of what type of data you query?

SS