Monday, June 6, 2011

Cannot save a "Share workbook option" excel on the network drive

Instead of  the problem caused by KB 978382 (Security Update for MS Office Excel 2007).

The problem will be caused by the enabled "share workbook option" file is using different version office (e.g. 2003 and 2007) to save to the same file

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:
  • Open the shared workbook, and then save it to a local drive.
  • Turn on the shared workbook option.
  • Save the workbook on the network share.



Reference:

http://community.spiceworks.com/topic/92271-excel-2007-network-sharing-issue-this-file-is-no-longer-shared

http://office.microsoft.com/en-us/excel/HP100968331033.aspx#ShareWorkbook

Print Friendly and PDF
Share/Bookmark

No comments:

Post a Comment