Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
excel capability in a list
- Thread starter ChumpyS
- Start date
Thomas2000
Technical User
Hello,
If you are running Office 2003 Professional you can use the Datasheet view in a list and utilize some features from Excel. You can easily import lists from Excel into SharePoint.
If you set the list to be edited in Datasheet view you can open up a taskpane which will allow you to:
- Export and link to Excel
- Print with Excel
- Chart with Excel
- Create Excel PivotTable Report
The above works with Office 2003, I am not sure you will be able to utilize or see the list properly with another version of the Office suite.
Cheers,
Thomas
If you are running Office 2003 Professional you can use the Datasheet view in a list and utilize some features from Excel. You can easily import lists from Excel into SharePoint.
If you set the list to be edited in Datasheet view you can open up a taskpane which will allow you to:
- Export and link to Excel
- Print with Excel
- Chart with Excel
- Create Excel PivotTable Report
The above works with Office 2003, I am not sure you will be able to utilize or see the list properly with another version of the Office suite.
Cheers,
Thomas
- Status
Similar threads
- Locked
- Question