Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel computer course london - excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer course london - Excel

excel computer course london - Excel

ResolvedVersion Standard

Thomas has attended:
Excel Introduction course

Excel

Not sure if this is strictly Excel but thought I'd try my luck!

I have an link on my intranet site to an Excel spreadsheet thats on my desktop.

I'm trying to get the intranet site to auto update every time I make a change to the spreadsheet on my desktop. At the moment I'm having to upload it as a new link every time I make a change.

Can anybody help please?

Tommy

RE: Excel

Hi Tommy, Thank you for your post, to answer your question; 1. Did you save the original file as an Interactive Web Page? 2. Did you click the option to update the Web Page every time the original is changed and saved?
If you wish to find these options; save your original spreadsheet as a Web Page - File, Save as Web Page, in the dialog boxes that open make sure you consider the two options above and then Publish your Spreadsheet. Hope that helps, regards Pete.

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.