Problem sharing workbook

Question

I am working with an Excel file and I want to share it.

I click on Share Workbook and check off the box that says "allow changes by more than one user at the same time".  Then I click OK.

Then it asks "This action will now save the workbook.  Do you want to continue?"  I click OK to continue.

Then I get a Minor Loss of Fidelity message saying some cells or styles in this workbook contain formatting that is not supported by the selected file format.  These formats will be converted to the closest format available.

When I click Continue, I get a message saying the workbook is no longer shared.

Why would this happen and how can I get it to remain shared?

Answer 1

Here is one discussion of the problem:

http://support.microsoft.com/kb/131553

here is a thread with one solution

http://community.spiceworks.com/topic/91655?page=1#entry-335695

Here was one othe suggestion

uninstalling KB 978382 worked ...

Known issues with this security update

• After you install this security update, you may receive an error message that resembles the following when you try to save a shared workbook: The file is no longer shared This problem can occur if the file is saved to a network location and then configured as a shared workbook. Microsoft is researching this problem and will post more information in this article when the information becomes available.
  To work around this problem, use either of the following methods:
  • To avoid this problem when you create a workbook that must be shared, turn on the shared workbook option before you save the workbook to a network share.
  • If the problem has already occurred, follow these steps:
    1. Open the shared workbook, and then save it to a local drive.
    2. Turn on the shared workbook option.
    3. Save the workbook on the network share.

---

If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire