Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Error in Viewing the Survey

  Asked By: Brendon Summers         Date: Sep 22, 2004      Category: Sharepoint      Views: 233
 

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.

Tagged:          

 

3 Answers Found

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

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

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

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.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].