Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Error in Viewing the Survey

  Asked By: Brendon    Date: Sep 22    Category: Sharepoint    Views: 1459

I got this error while trying to "export to a spreadsheet".
Can anyone help me out to fix this error.

============Microsoft 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.
I even tried from the other machine which has got the Office 2003
Service Pack 1 installed...still receiving the same error.



3 Answers Found

Answer #1    Answered By: Preston Moreno     Answered On: Sep 22

Sounds like the list  you are working with is the problem. Can you export  to
Excel using another list?

I'm only speculating but I suspect that some list items were added to the
list, then the list was altered to include new required fields, then
additional items were added to the list.

The export code may not know how to deal with the initially added list items
that do not have any values for the new required fields. I didn't get a
chance to test this theory.

Answer #2    Answered By: Rickey Strickland     Answered On: Sep 22

As exactly as per you theory, we created a list  & then tried to
modify the contents of the list/added few for survey  questions.
Is there any steps to solve this issue?

Is there any other ways/steps/methods for exporting the database to
other application(s)like Access 2003.

Answer #3    Answered By: Jonathan Thompson     Answered On: Sep 22

Sure, you can edit the rows  that were created before you added the new
required field(s) to have a value instead other than null.

Didn't find what you were looking for? Find more on Error in Viewing the Survey Or get search suggestion and latest updates.