Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Excel 2010 sharing workbooks

Posted on 2010-08-25
3
1,399 Views
Last Modified: 2012-07-16
Hello, We're experiencing problems with sharing Workbooks in Excel 2007 when too many users try to access a workbook at the same time.  Is Excel 2010 any better at coping with sharing Spreadsheets than Excel 2007. Thanks
0
Comment
Question by:JohnDoody
  • 3
3 Comments
 
LVL 45

Accepted Solution

by:
patrickab earned 250 total points
ID: 33519421
JohnDoody,

You won't like the answer that I'm about to give, but it is the ONLY answer that can be given:

"Excel does not handle 'Shared' workbooks reliably. They are often corrupted at random and apparently without cause. Clearly there is a cause but it has not yet been isolated and fixed by MS. There is nothing you can do to avoid shared workbooks corrupting. The ONLY thing that can be done is to make them single user.

To help you with the single user file system try adopting this approach instead. It does work rather well so it's worth doing. First make the file(s) single user. Second edit everyone's user profile in Excel - Tools/Options/General/UserName and in there put the person's name and telephone extension number. Then whenever you attempt to open a file that someone else is using, a dialogue box will pop-up telling you who is the current user - and it tells you their telephone extension number! The new user can opt to either call the current user or open the file as read-only.

I realise it seems odd that MS would have an unreliable feature in Excel but I'm afraid that's the way it is. If you must have simultaneous access then it would be wise to use a proper database.

For Office 2007:  Office Button > Excel Options >Popular tab >User name"

Patrick
0
 
LVL 45

Assisted Solution

by:patrickab
patrickab earned 250 total points
ID: 33519518
>Is Excel 2010 any better at coping with sharing Spreadsheets than Excel 2007.

I'm afraid it isn't.
0
 
LVL 45

Expert Comment

by:patrickab
ID: 33521523
JohnDoody - Thanks for the grade & points - Patrick
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
copy same as above data 18 38
Turn date into age 17 33
Excel formula - data format 5 22
Add Attendee Macro need not halt for Acknowledgement 12 23
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

837 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