Windows Forum

Ask something
Discussion Locked

Explorer slows down saving of Excel files

0 helpful
1 reply

by clindell

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Anyone ever experience this? I did a bit of searching and read a few other posts with similar info without a solution to the problem.

The user can browse to the Excel file in Windows Explorer and then open it from the mapped network share. The user then makes changes to it and when is is saved takes 15 about seconds as opposed to 2 seconds with Windows Explorer closed.

Why the longer time saving with Windows Explorer open?

Thanks

1 reply

by rdpeters

This is just a theory, but it "feels like" Windows doesn't use the open copy Explorer from within Excel -- it opens a NEW one, which must then obtain your entire network's file tree, which accounts for the delay.
I used to get these (up to 30 second) delays all the time, no matter where I had originally activated Excel from -- Start button, Icon, or Explorer. My behavior was to browse for the location, starting with "File-Save As - [browse]" then hitting the down arrow in the check box to start browsing from the head of the file tree.
Trouble was: that search included the WHOLE LAN, and we were on a small 802.11B network -- too small for that kind of browsing.
solution (for me) was to stop hitting the down arrow. Instead, I now hit the "up on level" button to get to My computer, select the right drive (usually D:), and start browsing downwards from there, to find a place to put this thing.

This discussion is closed to new replies.