tag:blogger.com,1999:blog-85091198823614990982024-02-07T19:59:38.132-05:00raytech SharePoint BlogLearn from raytech experts about the technology of Microsoft SharePoint.raytechhttp://www.blogger.com/profile/05216891260074111328noreply@blogger.comBlogger30125tag:blogger.com,1999:blog-8509119882361499098.post-67108427487281360732010-02-09T07:26:00.002-05:002010-02-09T07:26:58.252-05:00Drag and Drop MS Outlookk Emails into a SharePoint LibraryIf you need to manually store emails in a MOSS or WSS library, you can drag and Drop items from your MS Outlook. Just open the document library with Windows Explorer from the Actions tab. Once opened, you can drag and drop into it Windows items (files) as well as MS Outlook emails. The emails are stored as MSG type files. <br />
<br />
<br />
If you try dragging Outlook Express items (EML type) you will get an error message.<br />
<br />
An alternate way is to define the library to support imcoming mails (there are many articles on teh subject). This enable storing EML files but in order to open them you first need to save the file in your hard drive.Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-64296870464348918372010-02-03T16:36:00.000-05:002010-02-03T16:36:44.266-05:00Hiding SharePoint Library or List Items from the Search Results PageSometimes it makes no sense to show a list's content in WSS or MOSS search results. To hide the list or library you access the Setting / Library or List settings / Advanced Settings page and change the Search attribute to No.<br />
<br />
<br />
However, be aware that new items won't appear in the search but existing items will continue showing in the search results. To completely clean the list or library you need to run a full crawl. This is done in the central administration area.Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com4tag:blogger.com,1999:blog-8509119882361499098.post-15344978350323966542009-12-25T06:54:00.001-05:002010-07-03T04:44:34.128-04:00Web Part Page Error prevents opening it for updateThis article has been moved to:<br />
<a href="http://excel.shilor.org/2010/07/web-part-page-error-prevents-opening-it.html">http://excel.shilor.org/2010/07/web-part-page-error-prevents-opening-it.html</a>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-28270055084899420332009-11-20T11:14:00.001-05:002010-07-03T04:42:31.380-04:00Access violation error messages on SharePoint ListsThis article has been moved to:<br />
<a href="http://excel.shilor.org/2010/07/access-violation-error-messages-on.html">http://excel.shilor.org/2010/07/access-violation-error-messages-on.html</a>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-83013176339041369682009-10-30T08:42:00.005-04:002009-11-10T07:45:50.273-05:00Indexing and Searching PDF Content in WSS 3.0Starting in V8, the PDF iFilter file is bundled with Adobe Reader. To get the iFilter, you need to install Adobe Reader (8.0 or higher) onto the WSS server that will be doing the indexing.<br />
<br />
<em>The procedure below wouldn’t work for 64 bit servers. You can find comments on this in </em><a href="http://workerthread.wordpress.com/2008/07/18/adobe-reader-9-available-works-fine-with-sharepoint/"><em>http://workerthread.wordpress.com/2008/07/18/adobe-reader-9-available-works-fine-with-sharepoint/</em></a><em> WSS needs to know what extension to use, so you need to change a few registry entries.</em><br />
<br />
In regedit:<br />
<br />
<ol><li><br />
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Search\Applications\{ANYGUID}\Gather\Search\Extensions\ExtensionList<br />
<br />
Find the highest number in the list and add the next value with PDF for the value.<br />
</li>
<li>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Search\Setup\ContentIndexCommon\Filters\Extension<br />
<br />
This is the list of file extensions with a class ID for the iFilter used to index the extension. If .pdf is not listed, add it. It should have a multistring value in which you need to add the CLSID for the iFilter added by Adobe Reader. For version 9 this file is called "AcroRDIF.dll." You can look up its CLSID by doing a Find under the CLSID key (under HKEY_CLASSES_ROOT\CLSID\).<br />
<br />
CLSID for 9 = {E8978DA6-047F-4E3D-9C78-CDBE46041603}.<br />
</li>
<li>Add its path to the environment variables of the server:<br />
Start Menu /right click My Computer / select Properties /go to the Advanced tab /click on the Environmental Variables button and scroll down the Path variable, select it and click on the Edit button and add the path ";C:\Program Files\Adobe\Reader 8.0\Reader" then click OK to apply and close.<br />
</li>
<li>Reboot the server. It may take some time until the PDF documents are indexed.<br />
<br />
You can also run the search service. Use run via stsadm -o spsearch... for WSS and SSP Full Crawl for MOSS.</li>
</ol>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-55983314192968005382009-10-28T12:52:00.004-04:002009-11-10T07:47:03.741-05:00Showing the PDF Icon in a SharePoint Document LibraryOut of the box, you won't see the PDF icon in WSS 3.0 document libraries as you see MS Office icons next to office documents.<br />
<ol><li>Download the small icon file from adobe. <a href="http://www.adobe.com/misc/linking.html#pdficon">http://www.adobe.com/misc/linking.html#pdficon</a></li>
<li>Save the icon in the c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\IMAGES folder.<br />
-<em>You can rename it to match the standard naming convention.</em></li>
<li>Open (in notepad) the DOCICON.XML file located in the c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\XML folder.</li>
<li>In ByExtension -->section add the tag >Mapping Key="pdf" Value="icpdf.gif" OpenControl=""/>-Change the direction of the first > (just left to Mapping) to make the markup work right.</li>
<li>Save.</li>
<li>Reset <span class="blsp-spelling-error" id="SPELLING_ERROR_0">IIS</span>.</li>
<li>You should now see all <span class="blsp-spelling-error" id="SPELLING_ERROR_1">PDF</span> documents with the correct icon.</li>
</ol>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com1tag:blogger.com,1999:blog-8509119882361499098.post-3276770137382049872009-10-17T14:05:00.003-04:002009-11-10T07:53:01.111-05:00How can we explain SharePoint?I always sympathize with SharePoint professionals when reading articles about their difficulties in answering the question: “What do you do for a living”? After thinking it over and over, I decided to rephrase the question. I asked myself, “What will eventually be the TLR (Three Letter Acronym) for SharePoint-like applications?<br />
<br />
I have never been satisfied with my own explanations of SharePoint, even with my latest strategy of asking the person about his or her IT knowledge before formulating my response. I see people nodding their heads, but in most cases I feel I didn’t convey the message well enough.<br />
<br />
Thinking about a TLR, the first thing that comes to mind is the equivalent ERP (Enterprise Resource Planning). The name is intuitively perceived as a package of related applications that support end-to-end the enterprises’ operations. But it took 10 to 15 years until this TLR became the standard everyone uses and understands. Previously, there had been MRP, Logistics, Shipping, Financial, HR and other disparate applications.<br />
<br />
So what do we package here? SharePoint supports several relatively independent processes. It combines what was previously Portal, EDM (Enterprise Document Management), ECM (Enterprise Content Management), WCM (Web Content Management), team collaboration, activity tracking and even connectivity extensions to backend systems. We will probably see more Social Network support coming soon. Since companies usually need more than one of these applications, why not use the same tool and save on maintenance?<br />
<br />
What can be a reasonable common denominator for all these processes? I think that the phrase “Knowledge Sharing” is pretty close to what they do. Prefix it with the E for Enterprise which is important, accurate - and also sells, and you get <strong>EKS – Enterprise Knowledge Sharing</strong>.<br />
<br />
Spread the word…Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-89308517202796561522009-10-05T11:31:00.004-04:002009-11-10T07:58:39.644-05:00MOSS and WSS 3.0 Installation on Windows Server 2008 R2If you want to install <span class="blsp-spelling-error" id="SPELLING_ERROR_0">SharePoint</span> 2007 on Windows Server 2008 R2, you need to take special actions because SP2, which supports this operation, is a prerequisite. If you try to install with SP1 you will receive an error message.<br />
<br />
The way to do this is to use a slipstream, something like concatenating several components together to meet the requirements.<br />
<br />
In its Team Blog, Microsoft published KB articles explaining the needed steps.<br />
<br />
The slipstream builds can be found here:<br />
<br />
Windows <span class="blsp-spelling-error" id="SPELLING_ERROR_1">SharePoint</span> Services 3.0 with SP2 (x86) <a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=EF93E453-75F1-45DF-8C6F-4565E8549C2A&displaylang=en">http://www.microsoft.com/downloads/details.aspx?FamilyId=EF93E453-75F1-45DF-8C6F-4565E8549C2A&<span class="blsp-spelling-error" id="SPELLING_ERROR_2">displaylang</span>=en</a><br />
Windows <span class="blsp-spelling-error" id="SPELLING_ERROR_3">SharePoint</span> Services 3.0 with SP2 (x64) <a href="http://www.microsoft.com/downloads/details.aspx?familyid=9FB41E51-CB03-4B47-B89A-396786492CBA&displaylang=en">http://www.microsoft.com/downloads/details.aspx?familyid=9FB41E51-CB03-4B47-B89A-396786492CBA&<span class="blsp-spelling-error" id="SPELLING_ERROR_4">displaylang</span>=en</a><br />
For <span class="blsp-spelling-error" id="SPELLING_ERROR_5">SharePoint</span> Server 2007, you can follow <a href="http://technet.microsoft.com/en-us/library/cc261890.aspx">Create an installation source that includes software updates (Office <span class="blsp-spelling-error" id="SPELLING_ERROR_6">SharePoint</span> Server 2007)</a> to create one. Or you can also read on. We will go through the complete steps to create a new slipstream build for <span class="blsp-spelling-error" id="SPELLING_ERROR_7">SharePoint</span> Server 2007.<br />
<br />
You can find the article here:<br />
<a href="http://blogs.msdn.com/sharepoint/archive/2009/10/02/install-sharepoint-server-2007-on-windows-server-2008-r2.aspx">http://blogs.msdn.com/sharepoint/archive/2009/10/02/install-sharepoint-server-2007-on-windows-server-2008-r2.aspx</a><br />
<br />
And one more tip: If this is a plain <span class="blsp-spelling-corrected" id="SPELLING_ERROR_8">vanilla</span> installation, and you have control over the server type, you need to use the X64. <span class="blsp-spelling-error" id="SPELLING_ERROR_9">SharePoint</span> 2010 will work on X64 only.Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-2549354600282428902009-09-19T04:42:00.015-04:002010-07-03T02:13:03.423-04:00Wrap the Title (name) of SharePoint List ColumnsThis post has been moved to here:<br />
<a href="http://excel.shilor.org/2010/07/wrap-title-name-of-sharepoint-list.html">http://excel.shilor.org/2010/07/wrap-title-name-of-sharepoint-list.html</a>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com2tag:blogger.com,1999:blog-8509119882361499098.post-82699343494564571942009-09-19T02:40:00.004-04:002010-07-03T04:38:53.498-04:00Workflows are carried over upon saving SharePoint lists as templatesThis article has been moved to:<br />
<a href="http://excel.shilor.org/2010/07/workflows-are-carried-over-upon-saving.html">http://excel.shilor.org/2010/07/workflows-are-carried-over-upon-saving.html</a>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-85035425101710844132009-09-11T01:23:00.005-04:002009-11-10T08:10:05.891-05:00Form Server Problems after SharePoint Site Collection RestoreAfter you restore a site collection, you may not be able to publish to a MOSS Form Server based site, and may receive the following error <span class="blsp-spelling-corrected" id="SPELLING_ERROR_0">message</span>:<br />
<br />
<strong>"This form template is browser-compatible, but it cannot be browser enabled on the selected site."</strong><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRmsXR1ASG3Bj6P1t-5sGI1bPAeFbUAnDQT3m5XoSWxxu9ttsi0O2eO656KQyZ6QpcVA3L2AjYcrf5p_9NZPCqcJEBUWJYu_m-QHGricBstZ0oFU0MGQaXzTRxnaL9e2liB5O219_kZW32/s1600-h/FormTemplateNotWorking.JPG"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5380078215760966818" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRmsXR1ASG3Bj6P1t-5sGI1bPAeFbUAnDQT3m5XoSWxxu9ttsi0O2eO656KQyZ6QpcVA3L2AjYcrf5p_9NZPCqcJEBUWJYu_m-QHGricBstZ0oFU0MGQaXzTRxnaL9e2liB5O219_kZW32/s400/FormTemplateNotWorking.JPG" style="cursor: hand; height: 307px; width: 400px;" /></a><br />
<br />
This error message is caused by several features that have been affected during the restore process. You will have to use the <span class="blsp-spelling-error" id="SPELLING_ERROR_1">stsadm</span>.<span class="blsp-spelling-error" id="SPELLING_ERROR_2">exe</span> from the command line to <span class="blsp-spelling-corrected" id="SPELLING_ERROR_3">deactivate</span> and reactivate the functions. (You need to use the force attribute to force the changes).<br />
<br />
The affected function list:<br />
<br />
<span class="blsp-spelling-error" id="SPELLING_ERROR_4">Premiumweb</span><br />
<span class="blsp-spelling-error" id="SPELLING_ERROR_5">Premiumsite</span><br />
<span class="blsp-spelling-error" id="SPELLING_ERROR_6">PremiumsiteStapling</span><br />
<span class="blsp-spelling-error" id="SPELLING_ERROR_7">PremiumWebApplication</span><br />
<span class="blsp-spelling-error" id="SPELLING_ERROR_8">ExcelServerWebApplication</span><br />
<span class="blsp-spelling-error" id="SPELLING_ERROR_9">ExcelServerSite</span><br />
<span class="blsp-spelling-error" id="SPELLING_ERROR_10">ExcelServer</span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRmsXR1ASG3Bj6P1t-5sGI1bPAeFbUAnDQT3m5XoSWxxu9ttsi0O2eO656KQyZ6QpcVA3L2AjYcrf5p_9NZPCqcJEBUWJYu_m-QHGricBstZ0oFU0MGQaXzTRxnaL9e2liB5O219_kZW32/s1600-h/FormTemplateNotWorking.JPG"></a><br />
<em><span style="font-size: 85%;">More on <span class="blsp-spelling-error" id="SPELLING_ERROR_11">stsadm</span>:</span></em><br />
<a href="http://www.wssdemo.com/Lists/stsadm/AllItems.aspx"><em><span style="font-size: 85%;">http://www.wssdemo.com/Lists/stsadm/AllItems.aspx</span></em></a><br />
<em><span style="font-size: 85%;"><br />
We thank Alex <span class="blsp-spelling-error" id="SPELLING_ERROR_12">Levitin</span> for this tip.</span></em>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-69428580929137587852009-08-28T07:29:00.004-04:002010-07-03T04:35:20.477-04:00Office and SharePoint Metadata SynchronizationThis article has been moved to:<br />
<a href="http://excel.shilor.org/2010/07/office-and-sharepoint-metadata.html">http://excel.shilor.org/2010/07/office-and-sharepoint-metadata.html</a>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-45019427064663620782009-08-24T15:57:00.003-04:002009-11-10T08:12:39.734-05:00Fixing static links upon migration from SharePoint 2003 to 2007I have a post in <a href="http://excel.shilor.org/2009/08/fixing-static-links-upon-migration-from.html">http://excel.shilor.org/2009/08/fixing-static-links-upon-migration-from.html</a> explaining how to make vertical changes to static links that wouldn't work after migrating to 2007 version because the new links are different.<br />
<br />
The steps are:<br />
<br />
<ul><li>Export the list from <span class="blsp-spelling-error" id="SPELLING_ERROR_0">SharePoint</span> to Excel.</li>
<li>Apply a formula that extracts the URL from its 'friendly name', which requires using a <span class="blsp-spelling-error" id="SPELLING_ERROR_1">UDF</span> (User Defined Function) macro.</li>
<li>Apply the 'Copy' and 'Paste special' as values to replace the URL formulas with values. Use 'Replace all' to get the new URLs.<br />
**It is assumed that you know how to do that.</li>
<li>Apply the 'HYPERLINK' formula to create the new links.</li>
<li>Copy the new links back to the <span class="blsp-spelling-error" id="SPELLING_ERROR_2">SharePoint</span> list.</li>
</ul>A detailed explanation is in the other post.Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-47131081573640211912009-08-18T06:44:00.005-04:002009-11-10T08:13:59.762-05:00SharePoint 2010 Sneak PeekMicrosoft has just released 3 short clips for Users, IT Professionals, and Developers to get the feeling of what SharePoint 2010 will look like.<br />
<br />
The user experience will be dramatically improved for all 3 target audiences.<br />
<br />
Here is the link to preview the upcoming SharePoint 2010 release, expected in Q1 2010.<br />
<br />
<a href="http://sharepoint.microsoft.com/2010/Sneak_Peek/Pages/default.aspx">http://sharepoint.microsoft.com/2010/Sneak_Peek/Pages/default.aspx</a>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-26229016827281093992009-08-12T17:19:00.005-04:002010-07-03T04:29:09.389-04:00How to limit a SharePoint user to view his list items only.This article has been moved to:<br />
<a href="http://excel.shilor.org/2010/07/how-to-limit-sharepoint-user-to-view.html">http://excel.shilor.org/2010/07/how-to-limit-sharepoint-user-to-view.html</a>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com1tag:blogger.com,1999:blog-8509119882361499098.post-25551029344424868322009-07-27T14:08:00.006-04:002009-11-10T08:19:24.015-05:00Using Excel in Multi-User Applications (SharePoint)<em><span style="font-family: arial; font-size: 85%;">The article was first published on </span></em><a href="http://excel.shilor.org/"><em><span style="font-family: arial; font-size: 85%;">http://excel.shilor.org</span></em></a><em><span style="font-family: arial; font-size: 85%;">. You can read the article with its associated images in: </span></em><a href="http://excel.shilor.org/2009/07/using-excel-in-multi-user-applications.html"><em><span style="font-family: arial; font-size: 85%;">http://excel.shilor.org/2009/07/using-excel-in-multi-user-applications.html</span></em></a><br />
<br />
<span style="font-family: georgia;">In a previous post I suggested using Excel in collaboration with SharePoint. I will demonstrate this concept in the following simple scenario.</span><br />
<br />
<em><span style="font-size: 85%;">For this solution your organization should have WSS 3.0 or MOSS. It is assumed that you know something about Excel Pivot Tables, Names, and Charts.</span></em><br />
<span style="font-family: georgia;">Let's assume that you work in a multi-plant manufacturing environment. Plants assign people to track their daily waste data in a SharePoint list. The list may have the following columns:</span><br />
<ul><li><span style="font-family: georgia;">Plant (Lansing, Detroit) </span></li>
<li><span style="font-family: georgia;">Machine-Type (Printer-A, Printer-B) </span></li>
<li><span style="font-family: georgia;">Date </span></li>
<li><span style="font-family: georgia;">Waste-Lb</span></li>
</ul><span style="font-family: georgia;">Any SharePoint List lets you export its data to Excel (2003 or later).</span><br />
<ol><li><span style="font-family: georgia;">Navigate to the list</span></li>
<li><span style="font-family: georgia;">In Actions, select Export to Spreadsheet.</span></li>
<li><span style="font-family: georgia;">In the Pop up window click Open.<br />
-For Excel 2007 click Enable in the Security Notice window.<br />
-You may need to enter your user and password which should have access to the list.</span></li>
<li><span style="font-family: georgia;">The list will open in your default Excel program.<br />
-from here you can name the list and refer to it from a Pivot Table, Chart, or any other model.</span></li>
<li><span style="font-family: georgia;">To refresh the list with the up-to-date data, just select any List's cell and click the 'Refresh' icon in Excel 2007 or right-click the cell, select List / Discard changes and Refresh List.</span></li>
</ol><span style="font-family: georgia;">Anytime you refresh the list, the name you assigned will be correctly adjusted to the new range. Upon refreshing the Pivot Table for example, you will view the new numbers.</span>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-9766283250983071772009-07-22T05:04:00.002-04:002009-11-10T08:20:05.952-05:00June Cumulative Update Packages Ready for DownloadMicrosoft publishes a cumulative update each couple of months or so. Here is the link to <a href="http://blogs.msdn.com/sharepoint/archive/2009/07/20/june-cumulative-update-packages-ready-for-download.aspx">June Cumulative Update</a>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-45281834554976085092009-07-11T00:42:00.003-04:002009-11-10T08:20:46.324-05:00Get SharePoint Designer training on your desktopYou can find a few free training options on the Microsoft <span class="blsp-spelling-error" id="SPELLING_ERROR_0">SharePoint</span> <span class="blsp-spelling-corrected" id="SPELLING_ERROR_1">Designer</span> (<span class="blsp-spelling-error" id="SPELLING_ERROR_2">SPD</span>) site. The following link is a download (a pretty big one) with 20 videos explaining most of <span class="blsp-spelling-error" id="SPELLING_ERROR_3">SPD</span> basic <span class="blsp-spelling-corrected" id="SPELLING_ERROR_4">capabilities</span>:<br />
<br />
<a href="http://office.microsoft.com/en-us/sharepointdesigner/HA102632321033.aspx">http://office.microsoft.com/en-us/sharepointdesigner/HA102632321033.aspx</a><br />
<br />
Enjoy!Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-44271363916634781902009-07-01T12:48:00.005-04:002010-07-03T04:25:29.099-04:00How to Lookup two or more source columns in SharePointThis article has been moved to:<br />
<a href="http://excel.shilor.org/2010/07/how-to-lookup-two-or-more-source.html">http://excel.shilor.org/2010/07/how-to-lookup-two-or-more-source.html</a>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-59701727827933242112009-06-12T14:04:00.007-04:002010-07-03T04:00:05.406-04:00Remove Disabled AD Accounts from MOSSThis article has been moved to:<br />
<a href="http://excel.shilor.org/2010/07/you-would-think-that-whenever-ad.html">http://excel.shilor.org/2010/07/you-would-think-that-whenever-ad.html</a><br />
<br />
<span style="font-family: "Arial", "sans-serif"; font-size: 11px; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-bidi; mso-bidi-language: HE; mso-bidi-theme-font: minor-bidi; mso-fareast-language: EN-US; mso-no-proof: yes;"><shapetype coordsize="21600,21600" filled="f" id="_x0000_t75" path="m@4@5l@4@11@9@11@9@5xe" preferrelative="t" spt="75" stroked="f"><stroke joinstyle="miter"></stroke><formulas><f eqn="if lineDrawn pixelLineWidth 0"></f><f eqn="sum @0 1 0"></f><f eqn="sum 0 0 @1"></f><f eqn="prod @2 1 2"></f><f eqn="prod @3 21600 pixelWidth"></f><f eqn="prod @3 21600 pixelHeight"></f><f eqn="sum @0 0 1"></f><f eqn="prod @6 1 2"></f><f eqn="prod @7 21600 pixelWidth"></f><f eqn="sum @8 21600 0"></f><f eqn="prod @7 21600 pixelHeight"></f><f eqn="sum @10 21600 0"></f></formulas><path connecttype="rect" extrusionok="f" gradientshapeok="t"></path><lock aspectratio="t" ext="edit"></lock></shapetype></span>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com2tag:blogger.com,1999:blog-8509119882361499098.post-32159869423276288242009-06-06T02:47:00.005-04:002010-07-03T03:51:30.968-04:00Cannot get the list schema column property from the SharePoint list<div>This article has been moved to:</div><div><a href="http://excel.shilor.org/2010/07/cannot-get-list-schema-column-property.html">http://excel.shilor.org/2010/07/cannot-get-list-schema-column-property.html</a></div><div> </div>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com2tag:blogger.com,1999:blog-8509119882361499098.post-20820951120071873892009-06-04T04:00:00.005-04:002010-07-03T03:46:21.166-04:00Permissions on a SharePoint List ColumnThis article has been moved to:<br />
<a href="http://excel.shilor.org/2010/07/permissions-on-sharepoint-list-column.html">http://excel.shilor.org/2010/07/permissions-on-sharepoint-list-column.html</a>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-11720397767860291182009-05-22T12:53:00.003-04:002010-07-03T03:39:13.023-04:00Incorrect search results when using the This Site or This List optionsThis article has been moved to:<br />
<a href="http://excel.shilor.org/2010/07/incorrect-search-results-when-using.html">http://excel.shilor.org/2010/07/incorrect-search-results-when-using.html</a>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-36231426805897992012009-05-22T05:44:00.003-04:002009-11-10T08:35:25.357-05:00MOSS and WSS 3.0 SP2If you are not yet aware of it, there is a new service pack 2 from Microsoft available for download. To learn and download <a href="http://support.microsoft.com/default.aspx/kb/953334">click here</a>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com0tag:blogger.com,1999:blog-8509119882361499098.post-17711848638513810312009-05-15T16:00:00.009-04:002010-07-03T03:35:56.622-04:00Update SharePoint Lists from Excel 2007<div></div><div>This article has been moved to:</div><div><a href="http://excel.shilor.org/2009/07/unlike-excel-2003-2007-version-doesnt.html">http://excel.shilor.org/2009/07/unlike-excel-2003-2007-version-doesnt.html</a></div><div> </div>Anonymoushttp://www.blogger.com/profile/02675509598836068269noreply@blogger.com2