Failed to get value of the “Approval Status”

The full error message reads “Failed to get value of the “Approval Status” column from the “Moderation Status” field type control”. This error has started occuring on document libraries containg web part pages that were upgraded from SPS 2003. The Hidden property on the Approval Status field has somehow been set to false. The Hidden property should be True.

I found this fix. Download a utility called SharePoint Manager 2007 from this site.
Run the application on a SharePoint server.
Go to View – Object Model and make sure “Full” is selected.
Browse to the library in the treeview.
Open the list of Fields and select the Approval Status field.
Change the Hidden property to True.
If the property is already set to True then change it to false and save it. Then change it back to True and save again.

Datasheet View Issues and Library Not Registered

A follow-on to a previous post on issues with the datasheet view and other issues related to conflicts with Office 2007 and 2003. We ran across another error where the datasheet view would display with no records and a javascript error. The javascript error reported “Library not registered”.

The fix is to do the following:

– Open Word
– Click the Office button (Top-left in the window)
– Click Word Options
– Click Resources
– Click the Diagnose button
– Click through the wizard until it’s finished
– Close all browser windows

That’s fixed all of our issues…