>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!

>I look at other people’s blogs and a lot of them look better than mine. Finally I have bitten the bullet and delved into the template and made a few changes.

One of the first things is that I have updated the amount of screen that the website uses, so hopefully now things will fit on the screen better. I will be updating some of the posts as they look a little strange with huge amounts of white space between lines.

Also the archive posts have been ordered in reverse.

I will be looking at tidying things up further as I see fit but if you have any other suggestions just add a comment.

Thanks