Pakai :
Excel Options
Formulas
Calculation options
Automatic
Herry
________________________________
From: "r...@ld" <admk....@bukopin.co.id>
To: Belajar Excel <belajar-excel@yahoogroups.com>
Sent: Wednesday, March 24, 2010 15:59:38
Subject: [belajar-excel] Hasil Penjumlahan Tidak Otomatis
Selamat sore
Mohon pencerahan dari rekan-rekan semua
Saya menggunakan Office 2007,
Permasalahan yang sering saya temui adalah jika saya merubah data
pada salah satu cell, dimana perubahan cell tersebut mempengaruhi hasil pada
cell yang lain,
namun data hasil perubahan tersebut tidak secara otomatis berubah.
perubahan terjadi (hasil perhitungan) jika saya menekan F2 data cell hasil atau
Ctrl+S (Save)
contohnya :
A1 + B1 = C1
1 + 1 = 2
perubahan pada A1 menjadi 2
maka seharusnya C1 otomatis menjadi 3 (2 + 1 = 3)
namun seringkali terjadi harus di save atau tekan F2 pada cell C1
mohon bantuannya bagaimana supaya hal tersebut bisa teratasi tanpa F2 atau
Ctrl+S
atas bantuannya diucapkan terima kasih
Roy Manikome
"Orang Manado"
------------ --------- --------- --------- --------- --------- ---------
--------- --------- -------
DISCLAIMER:
The information enclosed in this email (and any attachments) may be legally
privileged and/or confidential and is intended only for the use of the
addressee(s) .
No addressee should forward, print, copy, or otherwise reproduce this message
in any
manner that would allow it to be viewed by any individual not originally listed
as a recipient. If the reader of this message is not the intended recipient,
you are hereby
notified that any unauthorized disclosure, dissemination, distribution, copying
or the taking of any action in reliance on the information herein is strictly
prohibited.
If you have received this communication in error, please immediately notify the
sender
and delete this message. Unless it is made by the authorized person, any views
expressed
in this message are those of the individual sender and may not necessarily
reflect
the views of PT Bank Bukopin Tbk.
------------ --------- --------- --------- --------- --------- ---------
--------- --------- -------
New Email names for you!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/
