excel computer course london - excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

excel computer course london - Excel

resolvedResolved · Low Priority · Version Standard

replyReply Tue 13 Nov 2007, 09:18Delegate Thomas said...

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

For upcoming training course dates see: Pricing & availability

replyReply Thu 15 Nov 2007, 10:09Trainer Pete said...

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:

Activating the formula bar with the keyboard in Excel 2010

The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard