We have a few users who are sharing a rather large excel file (70 megs) via a network drive. If they save the file after each tiny modification, then there are no problems. But if they try to do a bunch (as little as 10), Excel hangs when they try to save it. Plus, the file becomes locked, so the other needs to rename the file and re-save his work. I've tried to search for this issue, but have had little to no luck.
The network drive is on a local network server (Win Server 2k3, gigabit networking) with plenty of free space, so that shouldn't be the issue. I'm kind of at a loss as to where to go from here. Is this a bug with Excel? Is it just something we're going to have to live with? Or is there something else that I/We are overlooking?
Thanks in advance...