R
Rachel
I have 9 mail merges that I perform daily. My form and data source
files are located on a network. Since I do these daily, I have a
working folder which contains all the daily files -- the Excel data is
updated daily, but the file names stay the same.
I've done these same merges for years using the various editions of MS
Word (actually it was originally Word Perfect, which was better then.)
In 2000 and '97, I did not have the SLOW OPEN problems. I now have
them in XP though nothing has changed. The locations of the files has
been the same forever. If I open just the data in Excel, there is no
wait -- it's instantaneous. I always used to open all 9 merge files
at once and it would take a few seconds for all the files to open.
Now it takes what seems like several minutes. It is a long wait, that
I just don't understand. I connected using DDE when these were in
2000. I connected to files in the same location they are now in. The
files are not large -- none of them. They're all between 11KB & 60KB
-- data & merge docs included. My computer does not run slow once
these are open or any other time for that matter (okay, unless I'm
REALLY killing it at the moment), but not when I have 12 Word docs
open along with their associated data files; even when those data
files are a part of a HUGE database. Shortly, I'm positive the
problem is not with my PC or the network -- since I have no waiting on
opening any other files.
So what is it that is making these files take FOREVER to open? By the
way, I have the same wait whether I open one merge doc at a time or
all of them at once.
I'm operating under Win 2000, build 5.00.2195 SP 3/ PIV -- 2.5 GH;
with 515+K Ram, a 40G harddrive with 30 Gig free.
Any clues or tips?
Tx,
Rachel
files are located on a network. Since I do these daily, I have a
working folder which contains all the daily files -- the Excel data is
updated daily, but the file names stay the same.
I've done these same merges for years using the various editions of MS
Word (actually it was originally Word Perfect, which was better then.)
In 2000 and '97, I did not have the SLOW OPEN problems. I now have
them in XP though nothing has changed. The locations of the files has
been the same forever. If I open just the data in Excel, there is no
wait -- it's instantaneous. I always used to open all 9 merge files
at once and it would take a few seconds for all the files to open.
Now it takes what seems like several minutes. It is a long wait, that
I just don't understand. I connected using DDE when these were in
2000. I connected to files in the same location they are now in. The
files are not large -- none of them. They're all between 11KB & 60KB
-- data & merge docs included. My computer does not run slow once
these are open or any other time for that matter (okay, unless I'm
REALLY killing it at the moment), but not when I have 12 Word docs
open along with their associated data files; even when those data
files are a part of a HUGE database. Shortly, I'm positive the
problem is not with my PC or the network -- since I have no waiting on
opening any other files.
So what is it that is making these files take FOREVER to open? By the
way, I have the same wait whether I open one merge doc at a time or
all of them at once.
I'm operating under Win 2000, build 5.00.2195 SP 3/ PIV -- 2.5 GH;
with 515+K Ram, a 40G harddrive with 30 Gig free.
Any clues or tips?
Tx,
Rachel