How to Use Excel to Publish to SharePoint Servers

By eHow Computers Editor

Rate: (0 Ratings)

Publishing Excel spreadsheets on SharePoint is an asset to many companies in business today. Posting vital information to your website the fastest, may result in immediate profits. As long as you have permission to save files on the SharePoint server, you can effortlessly publish spreadsheet, as if saving to your personal computer.

Instructions

Difficulty: Moderate

Things You’ll Need:

  • MS excel version 12.0 or greater
  • Server access
  • Internet connection

Step1
Open Excel and create a spreadsheet. Once you're ready to publish it, select "Publish to Office Server" under the "File" menu.
Step2
Enter the path to the SharePoint server. Create a name for your spreadsheet file. If you wish to replace a spreadsheet that already exists on the SharePoint server, use the same file name for the new spreadsheet.
Step3
Click the "Publish" button. View a preview of the spreadsheet in your Web browser as soon as it's published.
Step4
Explore the options available in the "Publish to Office Server" dialog box to find ways to publish only certain sheets, sections and cells from your spreadsheet.

Tips & Warnings

  • Publishing a spreadsheet to SharePoint doesn't mean that you have to publish the entire spreadsheet.
  • If unchecked the box called "Open this workbook in your browser", you won't automatically see a preview of the spreadsheet.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article:  How to Use Excel to Publish to SharePoint Servers

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads