Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Tuesday, June 21, 2016 – Permalink –

Update Excel o the Web

Auto Republish


You can save an Excel file as a Web page and makes it easy to update data in a worksheet that has already been saved to the Web.

Here is how to save an Excel file as a Web page and set it up it for automatic updates:
  1. Click Save As Web page from the File menu. (click the Office logo in 2007+)

  2. In the Save As dialog box, click the Publish button. (click Publish, Create Document Workspace in 2007+)

  3. Use the drop down arrow beside Choose to select what you want to publish.

  4. In the File name field, enter a file name.

  5. Place a check beside Auto Republish every time this worksheet is saved. This way the data will be updated each time you make changes to the worksheet.

  6. Select Open published page in Web browser to view the data in your Web browser after you click Publish.

  7. Click Publish.
Lockergnome.com:
 Save Excel as Web Page

DevX.com:
 Four Ways to Use Excel on the Web

Penn State:
 Interactive Excel on the Web


See all Topics

Labels: , , , ,


<Doug Klippert@ 3:03 AM

Comments: Post a Comment