Dear all saya ada problem nich mengenai refresh data vlookup. saya melakukan vlookup data ke file yang lain ( database). masalah yang timbul ketika setelah update database dan di simpan ( save ) dan ditutup, kemudian saya membuka file yang satunya lagi dengan rumus vlookup untuk mengambil data yang telah terupdate tadi, tetapi setelah dibuka tidak ada perubahan data sesuai yang diinginkan. di re-fresh pake F9 juga tidak berpengaruh. tapi ketika databasenya di buka bersamaan maka data vlookup otomatis berubah juga bagaimana caranya agar vlookup data tersebut bisa otomatis tanpa membuka file database terlebih dahulu. terimakasih adit
___________________________________________________________________________________ CONFIDENTIALITY NOTICE This message and its attachments (if any) may contain confidential, proprietary or legally privileged information and it is intended only for the use of the addressee named above. No confidentiality or privilegs waived or lost by any mistransmission. All reply messages and/or all attachments included, and transmitted incoming and/or outcoming from/to the Prysmian Company could be know from its. If you are not the intended recipient of this message you are here by notified that you must not use, disseminate, copy it in any form or take any action in reliance on it. If you have received this message in error, please, delete it (and any copies of it) and kindly inform the sender, of this e-mail, by replying or go to http://www.prysmian.com/ on "contact us".
