Senin, 26 Oktober 2020

Kolom Microsoft Excel berubah menjadi Angka

 Hai,

Sudah lama ternyata tidak membuat tulisan di blog ini. Sampai akhirnya blog ini mulai seperti mati suri.

Sebagai tulisan pertama gue setelah hiatus, gue mau share kejadian tadi di kantor.

Tadi pagi ada sesebapak atasan yang manggil gue untuk dilakukan pengecekan terhadap aplikasi Microsoft Excel beliau. Keluhannya adalah formula Excelnya error dan karena beliau juga ga fasih bahasa indonesia dan gue pun ga fasih bahasa bapak itu, akhirnya kita diskusi dengan bahasa bahu. wkwkwk.....

Setelah dicek, ternyata error yang dimaksud adalah sebagai berikut :


Terlihat bahwa Formula penjumlahan yang ditampilkan menggunakan format R1C1 Style.

Langsung ga pake lama, gue lakuin ini :

  1. Buka Tab File, Pilih Options.
  2. Di menu Options, pilih Tab Formula
  3.  Pada menu Working with Formulas, matikan ceklis pada pilihan R1C1 reference style.


dan Voila,, Microsoft Excelnya kembali normal dengan tampilan seperti biasa.


CMIIW

Read More »

Kamis, 27 Juni 2019

IBM Thinkpad Secure Drive Red Blinking

I have a task from my user about his Thinkpad secure drive. The Secure Drive is look like the picture below.


His Secure Drive always show blinking red repeatedly, and he cannot input the password to unlocke well. From first impression, this conditions means the secure drive come into locked mode. and i think it's cause by he always put the worng password over and over again.

To get into unlocked mode, i do the following action :

1. Disconnect the secure hard drive from your computer.
2. Hold 5 while reconnecting the secure hard drive to your computer. The status LED alternately flashes in red and in green.

3. Press 5278879 and Press OK. The status LED turns red, indicating that the secure hard drive is unlocked for additional password attempts.


For further informastion, it can read at this documents.


CMIIW

Read More »

Rabu, 10 Januari 2018

Tidak bisa Install Printer di Windows 10 - The hash for the file is not present in the specified catalog file.

Gue mengalami masalah ketika melakukan instalasi driver printer yang sudah cukup lama di OS Microsoft Windows 10, dimana ketika proses instalasi mencapai installing printer, selalu tampil semacam EULA dari windows yang menginformasikan adanya perubahan di sistem. ketika gue tekan pilihan "YES", selalu tampil pesan seperti ini :

Windows encountered a problem installing the driver software for your device.Windows found driver software for your device but encoutered an error while attempting to install it.The hash for the file is not present in the specified catalog file. The file is likely corrupt or the victim of tampering.

Setelah dilakukan ujicoba secara brutal, gue menemukan kesimpulan bahwa masalah ini terjadi karena Windows mencegah instalasi aplikasi yang tidak terpercaya (dalam hal ini driver printer sudah cukup tua). Fitur ini sudah ada sebenarnya sejak windows 8, yang bernama "Device Driver Signing", dan setelah gue cari-cari di beberapa forum komunitas IT, gue temukan solusinya dibawah ini.


  1. Tekan tombol "Start"
  2. Ketikkan “startup”.
  3. Pilih “Change advanced startup settings“.
  4. Pilih “Restart now” pada bagian “Advanced startup” 
  5. Kemudian komputer akan restart, dan menampilkan menu "advanced startup"
  6. Pilih “Troubleshoot“.
  7. Pilih “Advanced Options“.
  8. Pilih “Startup Options“.
  9. Pilih “Restart“.
  10. Komputer akan kembali restart, dan akan menampilkan menu lebih lanjut
  11. Setelah menu tampil, pilih angka "7" untuk memilih “Disable driver signing enforcement“.
Setelah gue lakukan hal diatas, printer tersebut sudah sukses diinstall di notebook baru ini. Dan sudah siap tempur di user.
Read More »

Selasa, 16 Mei 2017

Fatal error C0000034 applying update operation xxx of .....

Dampak dari serangan masif ransomware yang bernama WannaCrypt, membuat gue harus berangkat pagi-pagi ke kantor untuk melakukan instalasi patch pada komputer user yang berbasis Micrososft Windows.

Dari sekian banyak komputer berupa desktop dan laptop, ada sebuah kendala yang menurut gue cukup unik sehingga perlu gue catat agar tidak lupa kalau terjadi kembali. Kendala tersebut adalah munculnya pesan "Fatal error C0000034 applying update operation ................" yang terjadi saat windows restart setelah selesai melakukan update.

Setelah gue lakukan pencarian, gue menemukan kasus serupa yang diajukan disebuah forum milik Microsoft. Langsung aja gue kutip dari situs tersebut cara penanganannya.

When applying SP1 for windows 7 there is a specific error that can happen during reboot. If you get this error “Fatal Error C0000034 Applying Update Operation 282 of...”, follow the steps below to fix the SP1 installation
1. Reboot your computer while it’s starting up.
2. When your computer starts up again, choose the option “Launch Startup Repair”"If you do not have this module installed in the OS, you'll need a Win7 install disc that is the same architecture (i.e. 32 or 64-bit) as the OS installed. Just boot to the CD and go from there."
3.When the Startup repair starts, click cancel.
4. After you click cancel it will show a box. Click “Don’t Send”, then click the link “View advanced options for recovery and support”
5. In the new window click Command Prompt at the bottom.
6. In Command Prompt type this and press enter: %windir%\system32\notepad.exe
7. Notepad will open. In notepad go to File - Open.
8. Change the type of files notepad views from .txt to All Files
9. Now in Notepad, go to C:\Windows\winsxs\ (or whichever drive Windows is installed on)
10. In that folder, find pending.xml and make a copy of it"Just copy and paste it in the same folder, this is just in case something happens to the original so you don't lose it."
11. Now open the original pending.xml"It will usually take a while to load because it's a huge file."
12. Press CNTRL+F and search for the following exactly: 0000000000000000.cdf-ms
"That's sixteen (16) zeroes ;)"
13. Delete the following text (yours may be a little different):


"NOTE: Your PC might not have all 3 sections of code (, , ). Just make sure you delete section “Checkpoint” and whatever other sections have “000000000000000.cdf-ms”. They will be right next to eachother."
14. Save the file, close notepad, close command prompt, restart your computer.

Sumber : di sini


Read More »

Jumat, 12 Mei 2017

Enable RPC HTTP di Microsoft Outlook 2016

I have a task from user that he complained about his Microsoft Outlook cannot be use while out of office. After checking his notebook, i found that he installed Microsoft Office 2016 from Office 365. And finally found this issue caused by his Microsoft Outlook not properly setup.

From googling, i found microsoft support released a documentation that MS. Exhcange  2016 is using MAPI over HTTP not like previous version that using RPC over HTTP.
and i get suggestion to do the following :

1. Open Registry editor Windows
2. Search the following key 
"HKEY_CURRENT_USER\Software\Microsoft\Exchange"
3. At the right pane, will show you DWORD "MapiHttpDisabled", Right click at that DWORD and select modify.
4. Change the value from "1" into "0".
5. Close Regedit
6. Open the Microsoft Outlook.

CMIIW
Read More »

Newsletter