|
Microsoft Office SharePoint Server (MOSS 2007) and Windows SharePoint Services 3.0 (WSS 3.0) > Questions and Answers
|
|
10/18/2009Just arrived in sunny Las Vegas to see what is new in SharePoint 2010. I will keep you posted with an ocasional video blog from the conference. Stay tuned! 3/9/2008
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.
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. 12/7/2007
So what is Show-Me-Office and SharePoint about? Well, I am an information worker and tech coach at heart. I started my career about 16 years ago as a management analyst and hated doing paper work. I started using the power of the desk top...hmm...well let's say the possible power of the desk top since I was using a 286 PC. But I digress; the purpose of this site is for me to communicate with others who want to use Office to make their lives easier during the work day with a goal of leaving the office at a reasonable hour so that you can actually have a balanced life.
In the next few days I will put up a link that will allow you to ask questions. I am planning on responding not with just text but with audio and video snippets that show you the answer to your questions. I will answer you in plain English. No techno babble to make myself sound smart and you scratch your head. I promise!
In this video I discuss how to set up Excel services and upload your Excel workbook to SharePoint.
Kevin asked for a demo of auditing and a description of some of the benefits it can provide. In the video I created for this answer, I get into some details about how auditing will give you key information for tracking documents and user actions in a document library.
Auditing Video
Ken asked a question about being able to print the metadata displayed for document libraries and lists. In the answer I give three ways to print the metadata in a clean format.
Printing Meta Data |
|
|
|
|