Shared Excel Workbook

Posted on 2013-11-21
Medium Priority
Last Modified: 2013-11-21
We have several Excel workbooks that are stored on network drives within the office.
We have sharing turned on each of these workbooks.
Multiple users access these files, leave them open all day, edit, etc.
The files freeze often, stop responding, don't open, hang, etc.  (All other Excel documents that are not shared perform normally)

We experience a host of issues and need to know
A.  Is there a better way?
B.  Are we missing how to set-up these shared workbooks. Should we alter settings?

We are using Office 2010 although several of the files are in 2003 version.
Question by:Robert Mohr
  • 2
  • 2
LVL 13

Accepted Solution

Sean earned 2000 total points
ID: 39665913
unfortunately excel is not the best at sharing.  I would look into setting up a sharepoint site or something that is better at handling multiple users. Sounds like you are doing things correctly but if the document is large then you are putting a good amount of stress on the hardware/network that you are using and this can cause the freezing and delays you are talking about. I would give sharepoint a look as they have a lot of great excel substitutes. The only down side is the limit of excel functions but give it a look.

Author Comment

by:Robert Mohr
ID: 39665939
That was my next thought too.  I will take a look.  Fortunately these documents are stripped down so not a lot of formatting.  I will get back to this if I find it's a solution.
LVL 13

Expert Comment

ID: 39665945
Okay great let me know if you have any other questions.

Author Closing Comment

by:Robert Mohr
ID: 39666644
I'm actually going to look at Office Web App and SkyDrive.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article will show you step-by-step instructions to build your own NTP CentOS server.  The network diagram shows the best practice to setup the NTP server farm for redundancy.  This article also serves as your NTP server documentation.
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question