I am trying to consolidate many workbooks...about 250, using ASAP
utility...all of these workbooks contain just a few lines of data...at the
most 40 at the least 1.

I'm wondering if there is a way for me to do this without having to open
them up one by one and hitting disable auto refresh....?

Any help would be appriciated! Happy Happy Day!
--
Jules