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

update links

ResolvedVersion 2003

Alan has attended:
Excel Advanced course

Update links

If someone emails a file to you containing vlookups etc, that prompts a message to update or not update, which should you select to ensure you get the correct data?

RE: Update links

Morning Alan,

If you want the correct date then you need to choose Update. The only issue you might have with this though is where the file you getting the information from is stored. If for example the file is stored on a department network drive then you should be ok, but if it is stored on there own personal drive then you have no access so it will not update. The best way to check is to go to Edit / Links and this will tell you where the file is getting the information from.

Hope this helps
Martin

Excel tip:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

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.11 secs.