Introduction

If you maintain data in a spreadsheet the columns and data can be imported to SharePoint. The imported data becomes a list. The steps are outlined below for SharePoint Foundation 2010 and Excel 2007.

Application Used

1. SharePoint 2010 Foundation

2. Microsoft Excel 2007

Steps

· Select Site Actions > More Options

· Select Import Spreadsheet and click Create

· Enter Name and optionally Description for the list

· Click Browse and select the spreadsheet to be imported onto SharePoint.

· Click Import (Your browser should support ActiveX for the import operation)

· Import to Windows SharePoint Services List is displayed

· Select the Range Type. For this example, Range of Cells is selected

· Select Range of cells to be imported

· Click Import

Errors

Do you get this error?

Solution

Modify EXPTOOWS, which is an Excel Add In file. This article has instructions with screen print to walk you through the changes required. Before making the changes .  .

1. Make  a copy of  EXPTOOWS.XLA

2. Double-click to open EXPTOOWS.XLA file. You get a blank page. Press Alt + F11 to open in code view

3. Comment out the lines not required by using  ’/

This imports the spreadsheet as a SharePoint list. Modify the view as required. The first row of the spreadsheet will be imported as columns in the SharePoint list

Housekeeping

· Remove blank rows before importing the spreadsheet as blank rows are taken as an item in the SharePoint list

· Before importing sort the columns in the desired order in the spreadsheet, to avoid doing the sort later in the SharePoint list.

· As filtered columns are not considered while importing, do not filter in the spreadsheet before import. It can be done from SharePoint.

These topics will be covered Sharepoint Learning and Certification life Cycle

for the Microsoft SharePoint 2010

• Course Name
• Course Number
• Exam Number
• Certification

Introduction

In this small article we can explore user creation in Active Directory and adding a user to a SharePoint site. in 3 Steps

Step 1: Open Server Manager

Open the Server Manager application from the desktop or through the Start menu.

Start Menu > Programs > Administrative Tools > Server Manager.

In the appearing application choose the following node: Server Manager > Roles > ADDS > (domain) > Users.

Step 2: Create New User inside ADDS.

You can right click on the Users item and choose the New > User menu item.

In the appearing dialog, enter the following details:

Click on the Next button and you will get the following Password dialog.

Enter the password and uncheck the Change Password option. Click the Next button to continue.

Now click the Finish button and the user will get created.

Step 3: Add the User to the SharePoint site.

Now sign in to the SharePoint site with administrative privileges. Choose the Site Actions > Site Permissions option to get the following screen:

I am adding the new user into the Members group. Click on the Members item and in the arriving page, use the New > Add Users menu.

In the appearing dialog box, enter the user name, resolve it, and click the OK button.

Now the user is added to the list and you are ready to test the New User.