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:

Comments

Post a Comment

Popular posts from this blog

Working with double quotes (") in VB.Net

String manipulation in VB2005 is fairly simple. However, things can get a little tricky with the double quote character. How do you look for it in a string? How can you insert into a string? How do you remove it from a string? These are questions that may lead to confusion if you don't know what you're looking for. Ironically enough, in VB the double quote can also be used as an escape character when searching for it in a string. For example: Dim strTest As String strTest = """123""" 'Displays "123" (double quotes appear in the final result) strTest = """""123""" 'Displays ""123" (double quotes appear in the final result) strTest = "test\""test" 'Displays test\"test strTest = "test""test" 'Displays test"test In cases where you want to insert a double quote character, simply reference it unicode character designation, ch
Read more

Using VB Script to display part of an IP address

Q: How can I use VB Script to display the first 3 octets in a TCP/IP address? A: Since IP addresses are not fixed length, you will have to count the number of separators before you can extract the octets. With that said, listed below is the sample VB Script code. strIP = inputbox("Enter an IP Address for testing to extract the first 3 Octets:") intLastDecimal = 1 For intCounter = 1 to 3 intLastDecimal = InStr(intLastDecimal, strIP, ".") + 1 Next iNewLength = intLastDecimal-2 strNewIP = Left(strIP, iNewLength ) MsgBox "strNewIP=" & strNewIP To run this code, simply copy and paste it into a flat file and name it with a .VBS extension. For more resources on VB Scripting, please visit the following links: http://msdn2.microsoft.com/en-us/library/3ca8tfek.aspx http://msdn2.microsoft.com/en-us/library/ms974570.aspx http://www.w3schools.com/vbscript/vbscript_ref_functions.asp
Read more

Sep '19 Announcements

Listed below are announcements of developer events local and regional to the Cleveland area.  In addtion there are links to job openings and videos of past presentations. Local Events: Oct 1: ONSQL-Cleveland ( https://www.meetup.com/Ohio-North-SQL-Server-User-Group-Cleveland/ ) Oct 16: Hudson Software Craftsmanship Group ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ ) Oct 24: Cleveland C#/VB.Net User Group ( https://www.meetup.com/Cleveland-C-VB-Net-User-Group/ ) Regional Events: Oct 1: ONSQL-Cleveland ( https://www.meetup.com/Ohio-North-SQL-Server-User-Group-Cleveland/ ) Oct 16: Hudson Software Craftsmanship Group ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ ) Oct 24: Cleveland C#/VB.Net User Group ( https://www.meetup.com/Cleveland-C-VB-Net-User-Group/ ) Job Openings: TekSystems:  https://www.teksystems.com/it-jobs Inedo:  https://inedo.com/company/career-culture Video: Please subscribe to  https://www.youtube.com/channel/UCU4ffaIzhsvMr_cCt9kjQMw  t
Read more