Setting Trusted Locations in MOSS 2007

Listed below are click-by-click instructions for creating a document library, making it a trusted location, and using it to display an Excel 2007 spreadsheet via Excel 2007 web part.

Create Document Library (with Excel as the default type)
1. Open the Home page to your site collection (i.e. http://moss101/Pages/Default.aspx)
2. Click “View All Site Content”
3. Click "Create"
4. Click "Document Library"
5. Specify all the settings for the library, using Excel 2003 as the default type. For the sake of this example, the document library will be called “Warehouse Documents”.
6. A document library called "Warehouse Documents" is now created, accessible at http://moss101/Warehouse%20Documents/Forms/AllItems.aspx


Make it a trusted location
1. Click "Central Administration"
2. Click "Shared Services Administration"
3. Click the Shared Service (i.e. "SharedServices1(Default)" )
4. Click "open Shared Service Administration"
5. Click "Trusted File Locations", located under "Excel Services Settings"
6. Click "Add Trusted File Location"
7. Paste URL of document library (http://moss101/Warehouse%20Documents/Forms/AllItems.aspx)

Upload sample spreadsheet
1. Maneuver to the Document Library (http://moss101/Warehouse%20Documents/Forms/AllItems.aspx) and click upload
2. Upload an Excel document in .XLSX format. Note: Document must be in Excel 2007 format (.XSLX) to work with the EWS web parts. Otherwise the web part will produce an error message similar to the one below:

The workbook that you selected cannot be opened.


The workbook may be in an unsupported file format, or it may be corrupt.




Add Excel Web part
1. Open the Home page to your site collection (i.e. http://moss101/Pages/Default.aspx) .
2. Click “Site Actions” in the upper right hand corner of the page
3. Click “Edit Page”.
4. Click “Add a Web Part” in the desired zone.
5. From the pop-up box, select “Excel Web Access” web part and click “Add”. The web part will then appear in the selected web part zone as seen below:



6. Within the web part, click the link “Click here to open the tool pane” to configure the web part.
7. In the settings pane, use the ellipsis button (button with 3 dots) to maneuver to the document library created previously.
8. From the document library, select a spreadsheet in Excel 2007 format. Selecting any other format will result in the following error message:

SQL Server 2000 End-of-Life Support

For those with projects utilizing SQL Server 2000, Microsoft issued End of Life dates for support.

• Mainstream Support End of Life - April 8, 2008
• Extended Support End of Life - April 9, 2013
  End of "free" support
  Hot fixes (non-security related) will require an extended hot fix support agreement to be purchased
  Microsoft will not support warranty support, new features, or design changes
  Security updates will continue to be provided
  
  Microsoft Support Lifecycle: http://support.microsoft.com/lifecycle/
  MS SQL 2000 Lifecycle: http://support.microsoft.com/lifecycle/?LN=en-us&p1=2852&x=9&y=11
  
  
  With the retirement of SQL Server 2000 around the corner, this brings up an interesting question for MCAD/MCSD candidates: Will this impact certification Exam 70–229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition? When will the exam be retired?
  
  Given Microsoft is still promoting the MCDBA certification on their site, I'm guessing 70-229 is safe for the moment. The exam is not currently scheduled for retirement at this point (http://www.microsoft.com/learning/mcpexams/status/examstoretire.mspx) nor is it on the "Discontinued Microsoft Certification exams" list (http://www.microsoft.com/learning/mcpexams/status/examsretired.mspx).
  
  For more info, visit the following links:
  http://www.microsoft.com/learning/mcpexams/status/retired.mspx
  http://blogs.msdn.com/trika/archive/2007/07/03/lifecycle-of-new-generation-certifications.aspx
  http://blogs.msdn.com/trika/archive/2007/06/14/windows-server-2008-certification-paths.aspx
  http://www.microsoft.com/learning/mcp/mcdba/upgrade/default.mspx
  
  For specific questions, e-mail them to mcphelp@microsoft.com

Classic UI Tabs for Office 2007

Office 2007 presented users with a new easy to UI, utilizing the new ribbon interface. However, not all users are comfortable with the new UI. A new ribbon customizer tool is available for Office 2007 providing a similar look and feel as previous versions of Office. To preview the ribbon customizer, go to http://pschmid.net/office2007/ribboncustomizer/featuretourpart3.php. A trial download version is also available.

Debugging Stored Procedure in Visual Studio 2005

This is an interesting article on debugging stored procedures, showing click-by-click directions. To view the full article, click here. In addition, another link was posted on this blog previously at
http://clevelanddotnet.blogspot.com/2007/05/follow-up-questions.html.