I create an XLS with about a dozen or so named ranges that are dynamic based
on formula built into each one. For example, I have a name range that is
based on a column having value of "X". I noticed that it takes about 10 secs
for the file to open. I wrote a macro to open the above XLS and import data
from another XLS and save as another file. Because it takes about 10 secs to
open the file, the process takes longer than I expect because I have about
~150 different data files I have to process. Turning the calculation to
"Manual" seems to help open the file faster but if the file is open by
someone else, will it be calculated automatically? If so, I think I am safe.
Second question, when is Excel define the name range? when I use it or does
it determine for all name ranges upon opening the file?

Thanks a bunch
M