98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Update links
Update links
Resolved · Low Priority · Version 2003
Wed 16 Jul 2008, 16:52Delegate Alan said...
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?
Thu 17 Jul 2008, 12:17Trainer Martin said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Checking if a calculation adheres to Order of PrecedenceWhen writing formulas you must make sure that results will be calculated as you intended. |
