We like to think that the transition from list to spreadsheet is almost seamless.  And I've delivered some great solutions that allow users to manipulate spreadsheets on their local hard-drive and then upload the data to a suitable list on the portal.

However, this time, I'm trying to get the spreadsheet import to work.

So I have this spreadsheet with field validation, hidden columns and conditional formatting and I try to point my import browse button to it and I get an error box that says:

Import to Windows SharePoint Services list
Object doesn't support this property or method

When I click OK, I get the spreadsheet and the Import to Windows SharePoint Services list dialog box where I can select a Range of Cells, a Table Range, or a Named Range.

When I select a range of cells, drag my mouse across the desired cells and click Import, after I get prompted for a login, I get this error:

Import to Windows SharePoint Services list
Method 'Post' of object 'IOWSPostData' failed

Turns out this was all my fault because I've installed the SharePoint Designer which is an Office 12 product.

This action created an Office12 Folder under C:\program files\microsoft office\.

The problem is the EXPTOOWS.XLA file and it's accompanying EXPTOOWS.DLL file that live in the \Office 12\1033 folder.  So I renamed these two files by adding a .12 extension to them and I copied the same files out of my

C:\program files\microsoft office\Office 11\1033 folder

and pasted them into my \Office 12\1033 folder

No more problem importing spreadsheets.

hth

-robot

 

---

Posted 04-15-2008 11:25 AM by SPRobot