>SharePoint Issues caused by Excel Shared feature (Document Information Panel freezes)

>We recently launched a new application at a client which used custom Excel templates. These templates were associated to a content type so that they could control the relating metadata within Excel.

However users has the following problems:-

  • when a user tried to edit the document properties the document information panel was frozen.
  • Users could not merge/merge-center cells.

After a lot of Google searches and trying things different things out I worked out that it was to do with Shared workbooks. Shared workbooks allow multiple users to edit a workbook at the sametime, however to do this they seem to lock changes to the document properties and also the structure of the document. This does make sense but caused me and the client a lot of headaches.

So to fix this do the following:-

  • Open Excel Workbook
  • Choose the Review tab
  • Click the ‘Share Workbook’ button
  • Untick “Allow changes by more than one user at a time…..”
  • Click OK
  • Save the excel workbook.

Now your document information panel will be unfrozen.

Hope that saves someone some time!

Thoughts? Comments about this post? Please leave them here..

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s