Surveys, 3.0/2007, and Excel 2003

There is a known, unfixed bug with the combination of using certain survey questions in WSS 2.0 or Sharepoint 2003 and trying to export them to Excel 2003 documented in MS KB 828809.

When doing the export, you may receive the following message from Excel:
This list has hidden columns or read-only columns that require data but for which no default value has been specified. Existing rows in this list may therefore be edited, but new rows cannot be inserted.

This same issue exists if you are using WSS 3.0 or MOSS 2007 and still trying to export the information using Excel 2003.  Once you try the export with Excel 2007, there are no issues.

Right now, I don’t have access to a 2.0/2003 environment…I would be curious to find out if exporting with Excel 2007 resolves the issue there too which would prove that the issue is with Excel 2003 and not Sharepoint.

Let me know in the comments if you test this out, know the answer, or I will post an update if I get the chance to test it.

Technorati Tags: SharePoint+2007, SharePoint+Surveys

Locking Out Outlook 2007 Beta Versions

I mentioned in a previous post that I would post an update on how to block the beta version of Outlook 2007 while still allowing the production version to connect.  I am late getting this out but wanted to post it anyway.  Using that post, the Outlook client versions you would need to block would be as follows:

 12.0.0-12.4518.1013

The 2007 RTM version of EMSDB32.DLL is 12.0.4518.1014 so this entry makes sure any beta versions cannot connect. 

Technorati Tags: Outlook+2007, Disable+MAPI+Client