MS Office – SharePoint

installvisio.jpg

An Office 2003 installation on your computer is corrupted and setup cannot continue. Remove or repair the Office 2003 product and re-run setup

My reply was marked as the answer on the MSDN forums, kindly check out the link below if you are facing such an issue.

http://social.technet.microsoft.com/Forums/en-US/visiogeneral/thread/bfb94f8e-d6e5-4078-a404-61bcd9b5d1b3/#135ab0d1-0fb1-4448-976c-c76b73b4cf3c 

tc.jpg

Excel 2010 tracking changes made to a worksheet

Excel provides a change tracking tool that makes it easier for groups of people to work together. Change tracking makes sure that the changes made by different people are carefully logged, giving you the power to inspect each person’s changes individually and reverse them if you choose. It’s a little like keeping several versions of the same worksheet in a single spreadsheet file.

Switching On Change Tracking To turn on change tracking, follow these steps:

1. Select Review➝Track Changes➝Highlight Changes. The Highlight Changes dialog box appears.

2. Turn on the “Track changes while editing” checkbox. When you turn on change tracking, you also automatically More >

pwd.jpg

Excel 2010 protect workbook by applying Password

Just a small security tip for applying Passwords to the Excel 2010 workbooks in just one step and making them secure.

The security can be applied in 2 layers:

1) Password required to open the workbook, so if the user doesn’t have a password they can’t even view the workbook.

2) Password required to edit the workbook, in which you will be asked to enter a password incase you want to edit the spreadsheet.

It is up to your discretion whether you want to apply both of the above mentioned security levels or just one of them. So both type of security can be More >

Capture.jpg

SharePoint 2010 import the .cmp file content

Firstly you need to understand how to export data of a deleted site to .cmp file from the following article:

http://geekdeck.com/sharepoint-2010-recover-data-of-deleted-site-from-content-database/

Now once you have data in the .cmp file format you just need to import it to a new site so that your old content gets back to life.

Create a new site collection with blank template to restore the data of your deleted site collection

Open the SharePoint 2010 Management Shell by clicking Start > All Programs > Microsoft SharePoint 2010 Products > SharePoint 2010 Management Shell. Type in the following and press enter (change the paths with their actual values).

Import-SPWeb -identity More >

image.png

SharePoint 2010 Recover Data of Deleted site from Content Database

1) Open the Central Administration

2) Click the Backup and Restore link in the Quick Launch

3) Under the Granular Backup heading, click Recover data from an unattached content database

4) On the Unattached Content Database Data Recovery page, specify:

Database Server Name

Database Name

Choose Browse Content in Choose Operation section

5) On the browse content page change the site collection and choose the collection whose data you want to recover. Then specify the specific site and which data parts (lists) you want to recover.

6) Once you’re done with that you need to specify the path for share folder and click the start export.

7) This will More >

image.png

Create SharePoint 2010 Site Template

First create any site which you would like to be used a template open it in SharePoint designer 2010, make changes accordingly now you just need to save it as a reusable package (.wsp) which is a SharePoint template extension and future sites created would be using this.

The following steps will show you how to create template from a SharePoint site:-

1. In SharePoint Designer 2010, click the SharePoint Designer Lab Site link in the navigation pane to open the Summary View for the site.

2. In the Ribbon, click Save as Template. A new browser window will open and you will More >

languagepack.jpg

Office 2010, The language of this installation package is not supported by your system

You might come across this if you’re running Microsoft Office 2010 from an already extracted setup. To overcome this run the setup from the original setup file, the one single file which you’ve downloaded and have not extracted yet.

entermsofficekey.jpg

Microsoft Office 2010, Change Product Key

Last night I was installing Microsoft Office on my machine after the installation when i tried activating it there was some error with the key i supplied in it was something like that they key has been activated maximum number of times so now I had to change the Product key.

I found number of articles related to this, firstly all of them were targeting to Office 2003, 2007 and other versions but there was nothing about MS Office 2010. Moreover the way around for this was very complex playing around with the Registry etc.

If you face the same problem with More >

sessionstate.jpg

SharePoint 2010, this report failed to load because session state is not turned on.

The error usually comes when you install SharePoint 2010 in stand alone mode because if you do so the default behavior is that session state for access reports is not enabled and you need to do so. You generally come across this error while creating Contact, Asset and other type of Web Databases.

Enabling Session State for SharePoint 2010 Access Reports:

1) Open SharePoint 2010 Management Shell

2) Type in the following command PS C:\Users\sp> enable-SPSessionStateService

3) You should get the following response:-

cmdlet Enable-SPSessionStateService at command pipeline position 1 Supply values for the following parameters:

4) Type in the Database Name as accessreports (DatabaseName: accessreports) More >

image.png

Windows 7, SharePoint Server 2010 Prerequisites

Please make sure that you’re running Window 7 Professional or higher and its a 64-bit version

Firstly you need to implement steps given in the following article: http://geekdeck.com/windows-7-x64-sharepoint-2010-error-this-product-requires-windows-server-2008-x64/

Once you have modified the config file, you need to take care of the following and ensure that they should be installed as there are many times when clicking the Install Software Prerequisites option doesn’t work on Windows 7 hence you manually need to take care of the following steps:

  • Microsoft FilterPack 2.0 Beta. (you will find this in your SharePoint setup folder):
    SetupFolder\PrerequisiteInstallerFiles\FilterPack\FilterPack.msi
  • Microsoft Sync Framework
  • SQL Server Native Client
  • Windows Identity Foundation (Windows6.1-KB974405-x64.msu)
  • Chart Controls
  • SQL Server Analysis More >