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: ,

About J.D. Wade

Senior SharePoint Consultant, husband, active in community theatre, love watching movies, have been described as “quirky”, aka “KB Man”
This entry was posted in Microsoft Office, Microsoft Office SharePoint Server 2007 (MOSS 2007), Microsoft SharePoint, Office 2003, Office 2007, Windows SharePoint Services 3.0 (WSS 3.0) and tagged . Bookmark the permalink.

3 Responses to Surveys, 3.0/2007, and Excel 2003

  1. Tatiana says:

    I do not know about Excel 07 since I have to use Excel 03. I have this problem with Excel 03. Is there any solution to solve that problem?

  2. J.D. Wade says:

    Tatiana,

    Unfortunately, this is a known, unfixed bug and the only work around is to use Excel 2007.

  3. Valli says:

    Thanks a lot. This helped.

Join the discussion by leaving a comment

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