Thursday, July 31, 2008

Not able to Create a New Document in Document Library

Issue:- Not able to create a New Document in Document Library.

Error:- "The exception unknown software exception (0xc06d007f) occured in the application at location 0x7c812a5b."

Environment:- Office 2003 and Office 2007 product together.

Resolution:- http://support.microsoft.com/kb/938888

Wednesday, July 30, 2008

Export to Spreadsheet

Issue / Error:- “Cannot get the list Schema column property from the SharePoint List”
When does is occur? :– While exporting a list to Excel Spreadsheet.
Environment :- Office 2003
Resolution :- Known bug. Can be resolved by Post Service Pack 1 release http://support.microsoft.com/kb/941422/en-us

Workaround:-
Upgrade to office 2007 OR
a. Change all the Date columns in the List to use “Date Only” format.

b. Using a machine which has Office 2007 installed, Export the list to Spreadsheet.
c. Create a new Blank “Import Spreadsheet” List.
d. Import the old Exported List back.
e. Now you will be able to export the list to spreadsheet in Office 2003 also.

Note: Do not change the format back to “Date & Time”

How to Re-produce the issue?

1. Create a SharePoint List with “Date and Time” Column keeping the format as “Date Only”
2. On Office 2003 machine Export the list to Spreadsheet, it will work without any issues.
3. Change the Date Column Format to “Date & Time”
4. Now again try to export the list to spreadsheet, it will not work, you will get the error “Cannot get the list Schema column property from the SharePoint List”, but the same list will get exported without any issues in Office 2007 setup.

Note: Even if you change the Date format back to “Date Only”, the issue will still persist; it does not resolve the error.