Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
File opens and saves slowly
1 view
Skip to first unread message
stev...@comcast.net
Dec 17, 2003, 10:23:18 AM12/17/03
to
I sent a workbook to a customer a while back. It wasn't large (470K) and the
only code was a couple of print range macros. A couple of weeks ago he asked
me modify a few formulas. Now he claims it takes 12 seconds to open the
file and it also saves slowly. I don't have the same problem. My file opens
in less than a second. He said the file is on his local hard drive and Excel
is open (with macro protection off) when the tries to open the file. I sent
him a new copy and he has the same problem. I am puzzled. Can anyone shed
some light on why this is happening?
only code was a couple of print range macros. A couple of weeks ago he asked
me modify a few formulas. Now he claims it takes 12 seconds to open the
file and it also saves slowly. I don't have the same problem. My file opens
in less than a second. He said the file is on his local hard drive and Excel
is open (with macro protection off) when the tries to open the file. I sent
him a new copy and he has the same problem. I am puzzled. Can anyone shed
some light on why this is happening?
Thanks
Steve
Dave Peterson
Dec 17, 2003, 11:39:04 AM12/17/03
to
One thing that may help:
tell him to clean up his windows Temp folder.
If the customer is using xl2002, you can search google for "slow saves excel
2002" and find a few hits.
You may want to take a look at these two sites
(Charles Williams and David McRitchie):
http://www.decisionmodels.com
http://www.mvps.org/dmcritchie/excel/slowresp.htm
They have some tips for working with slow workbooks.
--
Dave Peterson
ec3...@msn.com
stev...@comcast.net
Dec 17, 2003, 1:39:44 PM12/17/03
to
Dave,
Thanks for the wealth of information.
Steve
"Dave Peterson" <ec3...@msn.com> wrote in message
news:3FE086A8...@msn.com...
0 new messages