Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • DownloadDownload
  • PrintPrint
Share this Page URL
Help

8. Integrating PM Tools > Creating a Custom List from an Existing Excel Spreads...

Creating a Custom List from an Existing Excel Spreadsheet

If you have existing Excel files with project-related information, you don’t have to recreate them in SharePoint. You can take an existing Excel spreadsheet and import it to SharePoint as a custom list.

To do this, click Site Actions?More Options. Under List, click Import Spreadsheet and click Create (see Figure 8-6), then fill in the Name and Description of the spreadsheet, and browse for the file you’d like to import.

Importing an Excel spreadsheet as a custom list

Figure 8-6. Importing an Excel spreadsheet as a custom list

The beauty of doing this is that instead of emailing or sharing an Excel file, the project team can work on it collaboratively in SharePoint. This means that the user doesn’t even need Microsoft Excel in order to interact with the project information.


  

You are currently reading a PREVIEW of this book.

                                                                                        

Get instant access to over
$1 million worth of books and videos.

  

Start a Free Trial