Kathy Hughes, MVP

All MindsharpBlogs

SharePoint Encounters

My Links

Archives

Blog Stats

Asia Pacific SharePoint Training

Cats

Citrix

Personal

Resources

SharePoint Training

MOSS survey rating scale exporting to Excel 2003/2007

A customer recently approached me about an issue she was having in exporting her MOSS surveys to Excel, specifically when the survey included the field type “rating scale”. When exporting to Excel 2003 a dialogue with the message “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” will appear and rating scale columns will fail to be included in the exported Excel 2003 spreadsheet. This is currently an issue with Excel 2003 and there is a KB article relating to this issue here:- http://support.microsoft.com/kb/828809. Exporting the same to Excel 2007 is successful.

 

posted on Monday, December 10, 2007 7:31 AM

Feedback

No comments posted yet.

Comments on this post are closed.
Title  
Name  
Url
CAPTCHA
Protected by Clearscreen.SharpHIPEnter the code you see:
Comments