Questions and Answers

 

This error popped up for me a few weeks back. I was in a hurry and let it go until today. I thought it was a WSS 3.0 / MOSS 2007 issue. In reality it is a problem with the method Excel 2007 is using to send the spreadsheet information to WSS 3.0. It is using an old method of sending data ("the old post method of a previous WSS 1.0 version). Instead Excel 2007 needs to be forced to use the web service WSS 3.0 provides to SharePoint. This fix does that.

 

From the following blog post (http://www.tek-tips.com/viewthread.cfm?qid=1330234&page=1):

 

To make this change, open the Excel Add-In EXPTOOWS.XLA locate in C:\Program Files\Microsoft Office\Office12\1033 by default. Press Alt+F11 to display the Visual Basic code editor and search (Ctrl+F) for the line lVer = Application.SharePointVersion(URL). Comment out that line with a single quote and add the line lVer=2 so your Initialize() method should now look like this:

Sub Initialize(List, Title, URL, QuickLaunch)

strQuickLaunch = QuickLaunch

aTarget(iPublishURL) = URL

aTarget(iPublishListName) = List

aTarget(iPublishListDesc) = Title

'lVer = Application.SharePointVersion(URL)

lVer = 2

End Sub

=============================

Back to me again. Make sure when you save this file, you save it as an Excel Add In file type. If you save it from the code editor you will see the option to save as Excel Add In.