How to clear the Windows SharePoint 2010 Services configuration cache

There were many common issues that could occur in WSS v3 and MOSS that would require you to clear the configuration cache on your servers. While less common, these issues can still turn up occasionally on SharePoint Server 2010 (And Foundation). While the resolution for these issues might be the same, the steps are a bit different. The main thing to note is that the Configuration Cache is located in a different directory on Windows Server 2008 then it was in Windows Server 2003. The new path for the Configuration Cache under Windows Server 2008 is: %SystemDrive%ProgramDataMicrosoftSharePointConfig The overall steps remain largely the same:

  1. Stop the Timer service. To do this, follow these steps:
    • Click Start, point to Administrative Tools, and then click Services.
    • Right-click SharePoint 2010 Timer, and then click Stop.
    • Close the Services console.
  2. On the computer that is running Microsoft SharePoint Server 2010 and on which the Central Administration site is hosted, click Start, click Run, type explorer, and then press ENTER.
  3. In Windows Explorer, locate and then double-click the following folder:
  4. %SystemDrive%ProgramDataMicrosoftSharePointConfigGUID
  5. Notes
    • The %SystemDrive% system variable specifies the letter of the drive on which Windows is installed. By default, Windows is installed on drive C.
    • The GUID placeholder specifies the GUID folder. There may be more than one of these.
    • The ProgramData folder may be hidden. To view the hidden folder, follow these steps:
      • On the Tools menu, click Folder Options.
      • Click the View tab.
      • In the Advanced settings list, click Show hidden files and foldersunder Hidden files and folders, and then click OK.
      • You can also simply type this directly in the path if you do not want to show hidden files and folders.
  6. Back up the Cache.ini file. (Make a copy of it. DO NOT DELETE THIS FILE, Only the XML files in the next step)
  7. Delete all the XML configuration files in the GUID folder (DO NOTE DELETE THE FOLDER). Do this so that you can verify that the GUID folders content is replaced by new XML configuration files when the cache is rebuilt.
    Note When you empty the configuration cache in the GUID folder, make sure that youdo NOT delete the GUID folder and the Cache.ini file that is located in the GUID folder.
  8. Double-click the Cache.ini file.
  9. On the Edit menu, click Select All.
  10. On the Edit menu, click Delete.
  11. Type 1, and then click Save on the File menu. (Basically when you are done, the only text in the config.ini file should be the number 1)
  12. On the File menu, click Exit.
  13. Start the Timer service. To do this, follow these steps:
    • Click Start, point to Administrative Tools, and then click Services.
    • Right-click SharePoint 2010 Timer, and then click Start.
    • Close the Services console.
  14. Note The file system cache is re-created after you perform this procedure. Make sure that you perform this procedure on all servers in the server farm.
  15. Make sure that the Cache.ini file in the GUID folder now contains its previous value. For example, make sure that the value of the Cache.ini file is not 1.
  16. Check in the GUID folder to make sure that the xml files are repopulating. This may take a bit of time.

Excel Workbook Publishing, SharePoint 2010 Excel Services

In Microsoft Excel 2010, you can publish a workbook to a Microsoft SharePoint Services 2010 site so that other users can view its data in a web browser without having Excel installed on their computers. In addition, by setting some publish options, you can emphasize specific parts of your workbook in the browser. A great way to utilize this feature is by displaying an Excel chart on a SharePoint page to help your organization make agile business decisions.
This article shows you how to publish a workbook from the Excel 2010 desktop program, and does not cover connecting a workbook or workbook data to an Excel Web Access web part on a SharePoint page.
When you publish a workbook to a SharePoint server, the entire contents of the workbook are saved to the server and can be viewed and worked with if you open the workbook in the Excel desktop program. If Office Web Apps are deployed on the SharePoint server, viewing and working with your data in the web browser can be very much like working with your data in the Excel desktop program. In fact, simultaneous editing of a workbook is possible in the browser grid when Office Web Apps are deployed. When you view a workbook in the browser, if the Edit in Browser button is visible, this means that Office Web Apps are available.

PREPARE THE WORKBOOK
Before you publish the workbook, you have the opportunity (in the Publish Options dialog box) to select the worksheets or items that you want visible in the browser when editing has not been enabled by clicking the Edit in Browser button. Just remember that although you can select what is viewable in this mode, the entire contents of the workbook are still saved to the SharePoint server.
If you want to include entire worksheets as an item in addition to other items, such as charts or PivotTables, define the entire worksheet as a named range. Select the entire worksheet, and then define a named range. This named range will then appear as an available item in the Publish Options dialog box when you are ready to publish.
If you want to allow users to provide a parameter to a formula when viewing a worksheet in a browser, set a cell as a defined name. You can then add that defined name as a parameter on the Parameters tab in the Publish Options dialog box.

PUBLISH THE WORKBOOK

  1. Save & Send.
  2. Save to SharePoint.
    Note : If the Save to SharePoint command is unavailable, you can still save the workbook to a SharePoint site by using the Save As command. The Publish Options dialog box will not be available. You can also directly upload the workbook from a SharePoint library. Users can view and edit the contents of the workbook in the browser by going directly to the site where the workbook is saved.
  3. If you want to select individual worksheets or items to publish in the workbook, click the Publish Options button. Otherwise, if you want to publish the entire workbook, skip directly to step 4.
    On the Show tab, do the following:
    • To show the entire workbook in the browser, select Entire Workbook in the list box.
    • To show only specific worksheets in the browser, select Sheets in the list box, and then clear the check boxes for the sheets that you do not want to make visible.
      Note:  By default, all sheets are selected. To quickly make all sheets viewable again after you clear some of the check boxes, you can select the All Sheets check box.
    • To show only specific items in the browser (such as named ranges, charts, tables, or PivotTables), select Items in the Workbook in the list box, and then select the check boxes of the items that you want to show.
      Note:  If you select items that have the same name (such as a chart and its underlying table of data), only one of these items will be available in the browser. To show all the items, you must make sure that each item in the workbook has a unique name. You can rename tables on the Design tab in the Properties group, rename PivotTables on the Options tab in the Pivot Table group, and rename charts or PivotCharts on the Layout tab in the Properties group. Duplicate items, such as named ranges, can be renamed on them Formulas tab in the Defined Names group.
    • On the Parameters tab, add any defined names that you want to use to specify cells that are editable when users view the workbook in the browser. Then click OK to close the dialog box.
  4. Choose a location in which to publish your workbook. There may already be saved server locations under Current LocationRecent Locations, or Locations from which you can choose. If there are no such locations, or you want to save to a new location, under Locations, double-click Browse for a location.
  5. In the dialog box, enter the web address for the SharePoint site, and then browse to the site or library in which you want to save your workbook.
  6. If you haven’t already selected individual worksheets or items or set parameters, click the Publish Options button.
  7. In the File name box, accept the suggested name for the workbook, or type a new name if you want.
  8. To display the workbook contents in a browser window immediately after the publish operation has completed, make sure the Open with Excel in the browser check box is selected.
  9. Click Save.

How to create a Chart on a SharePoint 2010 site

The Microsoft Office SharePoint Enterprise 2010 is a collaborative application that can be used by multiple users connected to the same server. On an established SharePoint website for a server, you can upload files and edit other users’ work. You can also add new Web parts to files, such as adding a chart Web part containing data from another file stored on your computer. Adding a chart to a SharePoint Enterprise page can be helpful when you want to visually express data to other users connected to the SharePoint website.

  1. Log into SharePoint site.
  2. Navigate to the site where you want to create a Chart.
  3. Select an existing page that you want to add the chart.
  4. Click the Insert tab and then click Web Part.
  5. Click the Business Data option from the Web Parts group. Click the Chart Web Part option and then click the Add button.
  6. Click Save & Close.
  7. Data and Appearance option and then click the Connect Chart to Data option.
  8. Select your data source type, such as a Excel workbook that has been published to Excel Services or other data source type, and then click Next.
  9. Select the file containing the data and then click the Next button two more times. ClickFinish and the chart with your data will appear on the page.

How to create an Enterprise wiki

An Enterprise wiki helps users capture and publish knowledge that can be shared across the enterprise. When an organization needs an easy content editing experience in a single location for co-authoring content, conducting discussions, and managing projects, consider creating an Enterprise wiki.

      1. To create an Enterprise wiki by using Central Administration

Verify that you have the following administrative credentials:

      • To use Central Administration, the user account that is performing this procedure must be a member of the Farm Administrators group.

NOTE: You can also create an Enterprise wiki as a sub-site of another site by clicking New Site on the Site Actions menu.

        • In the Web Application section, click the Web Application drop-down list to select the Web application where you want to create the Enterprise wiki.

        • In the Title and Description section, type a title in the Title box and, optionally, type a description in the Descriptionbox.

        • In the Web Site Address section, select / to create the Enterprise wiki at the root of the Web application, or select/sites/ to create the Enterprise wiki site at a specific path. If you select /sites/, you must also type the site name.

        • In the Template Selection section, click the Publishing tab, and then click Enterprise Wiki.

        • In the Primary Site Collection Administrator section, type the user name for the user who will be the site collection administrator.

        • In the Secondary Site Collection Administrator section, type the user name for the secondary administrator of the site collection.

        • Designating a secondary site collection administrator is a best practice to ensure that someone can manage the site collection when a primary site collection administrator is not present.

        • If you are using quotas to manage storage for site collections, in the Quota Template section, click a template in the Select a quota template list.

        • Click OK.

      1. Create an Enterprise wiki by using Windows PowerShell

Verify that you meet the following minimum requirements:

    • See Add-SPShellAdmin.
    • On the Start menu, click All Programs.

    • Click Microsoft SharePoint 2010 Products.

    • Click SharePoint 2010 Management Shell.

    • From the Windows PowerShell command prompt window (that is, PS C:>), type the following commands:

      1. To display all the site templates, type the following command:Get-SPWebTemplate
      2. To create a variable that contains the name of the Enterprise wiki template, type the following command:$wikitemp = Get-SPWebTemplate “ENTERWIKI#0”
      3. To create an Enterprise wiki site, type the following command:

        New-SPSite http://yoursite.com/Wiki -OwnerAlias <domainuser> 

        -Template $wikitemp

        Where <domainuser> is the user name of the site owner.