office 2007 failed to open passworded office 2010 document

You know there are times when something happened in the microsoft office environment.
like this error happenend when you save the document in office 2010 and put a password on the document.
When you try to open it in office 2007 it failed to open.
And the thing the solution is the same when you save passworded document in 2007 and try to open it in in office 2003.
using this hot fix: http://support.microsoft.com/kb/954572

This hotfix fixes the following issues that were not previously documented in a Microsoft Knowledge Base article:

• In Windows Explorer, you right-click a text file, you click Open With, and then you click Microsoft Excel 2007. When Excel 2007 opens, the UTF-8 characters in the file are not interpreted correctly.
  Note This problem does not occur when you click Open on the File menu in Excel 2007.
  
• When you use the NETWORKDAYS function in Excel 2007, Excel 2007 may crash. This problem occurs when the NETWORKDAYS function uses a closed workbook as part of a parameter.
  
• You delete category labels in Excel 2007 Service Pack 1 (SP1), and then you save the file in the .xls format. When you open the file in Excel 2007 without SP1 or in Excel 2003, the category labels are not deleted as expected.
  
• When you try to edit a page number in Print Preview in Excel 2007, Excel 2007 may crash.
  
• When you run the GET.CHART.ITEM macro to retrieve the position of any charts on a chart sheet, incorrect chart point data is returned.
  
• In Excel 2007, a shared workbook is saved in the Excel 97-2003 format and is protected by a password. When you try to open the shared workbook by using Excel 2003, you receive the following error message even though you enter the correct password:
  Excel cannot open this file. The encryption type used is not available, contact the author of the file. More encryption types are available using the High Encryption Pack.
• Incorrect chart point data is returned on a chart sheet or on a worksheet in Excel 2007. This issue occurs when you run the GET.CHART.ITEM macro to retrieve the position of a Pie of Pie chart or a Bar of Pie chart.You cannot resize a drop-down list by using a Microsoft Visual Basic for Applications (VBA) script in Excel 2007.
• The Edit Links dialog box can be taller than the screen, with many links, and there is no way to scroll the list.

remember to install it in the pc that uses office 2007, and you need to install the service pack 3 for office 2007. you can download it here: http://www.microsoft.com/en-us/download/details.aspx?id=27838

preventing chkdsk to work on start up

Now there are sometimes annoying thing where after improper shutdown, like hot restart or shutdown, or power down, the windows start by the option of checking the disk.
Or in my experience happened sometimes in multiple OS computer, like when I shutdown normally from windows 7 then starting in windows XP sometimes this thing happened.
The windows does checkdisk to logical drive that has been marked dirty. you can check if the drive is dirty by using this command line:

fsutil dirty query [drive name]:

example:

fsutil dirty query c: d: e:

the above command is used when you want to check if drive c:, d: and e: are dirty.
to change the dirty status of the logical drive you can use the command:

fsutil dirty set

now that only work once, if you want it to be permanent, you can use the command line:

chkntfs /x [drive name]:

just be careful when using this, since even when the drive ntfs is bad, the windows wont repair it on start up. you can do it manually btw.

Formatting silicon power usb drive (toshiba)

now there is some puzzle on how to format a protected usb drive, this is without any hardware switch for write protected and write able status of flash drive.
my first experience is with this toshiba 8gb flash drive. it was write protected, I could not write it, so I tried to just format it, but windows cannot format it, it said write protected.
I tried to find the switch but found none. so I search google and found a guide here:

http://www.saveblogger.com/2011/12/cara-format-flashdisk-write-protected.html

so I follow it’s guide:

DNS list

DNS Server Indonesia :

Indosat

• 202.155.0.10
• 202.155.0.15
• 202.155.0.20
• 202.155.0.25
• 202.155.46.66
• 202.155.46.77
• 202.155.30.227

Telkom

Installing windows live in WIndows Server

Now still with windows live, here I stumble another problem. I use email with windows server. and you know what? Windows live doesn’t support windows server, go figure…
and also since I use remote desktop, windows live mail won’t open if you remote desktop open the windows live mail if in another connection you already open windows live mail.

Back to the main issue, wlsetup.exe file will refuse to install if refuse to install, showing this window:

if you click the show detail button, you’ll see the problem is the OS check:

ora-12560 “TNS Protocol Adapter Error” when installing database

Have you find this error, there are many cause of this error, but if this is happened when installing database then this is probably because either the service is stopped or because you connected to computer remotely using remote desktop connection.

windows live mail error 0x8e5e0713

This is the error I got in one of my client computers:

The error “Windows Live Mail could not be started. Closing Windows Live Mail. Your calendar contains corrupt data that is forcing Windows Live Mail to close. (0x8E5E0713)”
after trying like the solution on error about contact by deleting contact folder (in this I delete the calendar folder), is still not working. So I search on the net and the solution is actually simple, it is because the user access is not allowing the user to access the folder.

DEP on EXPLORER.EXE

It has been plagued the computer for several years, the strange thing is that we cannot predict on what windows installation this Data Execution Prevention on Windows Explorer happened. some pop up some don’t.
Firstly we tough that is because we didn’t update the windows, so we do, but the thing happened again.
so curious we browse for information in microsoft (http://windows.microsoft.com/en-US/windows-vista/Data-Execution-Prevention-frequently-asked-questions)
here is what they said:
” DEP is a security feature that can help prevent damage to your computer from viruses and other security threats. DEP can help protect your computer by monitoring programs to make sure they use system memory safely. If a program tries running (also known as executing) code from memory in an incorrect way, DEP closes the program ”

Hiding Control Panel Components

This is another group policy setting. You can hide the control panel component.
first, open the group policy, this time we can use the command prompt, just type gpedit.msc.
now go to USER CONFIGURATION > ADMINISTRATIVE TEMPLATES > CONTROL PANEL.
here You’ll find hide specified control panel applets.

Common error in windows live mail

Now, we have another problem here in the office. our email client have been changed to windows live mail from outlook express 6. Because like we all know, oe 6 still have bugs that are still not being repaired by m$. Those two fatal one are like the maximum size of an oe folder that cannot exceed 2097 xxx something kb (2 gb), if the folder reached that state it will corrupt the folder and you cannot see again the email in that folder. to remedy that you must extract manually the dbx file that the oe folder correspondent it to, you can see my previous article “undbx” about how to do it.