Excel 2007-2010 - Password Removal

To remove a password from a password protected Excel document, do the following:

  1. Change the file extension to .zip from .xlsx.
  2. Extract the whole content of zip file.
  3. Search for xml format of targeted sheet. It is in "xl\worksheets" directory (eg: sheet1.xml).
  4. Open the xml file of targeted sheet in a text editor (notepad++)
  5. Search for "sheetProtection" word in that xml file and remove it (remove the whole thing from <sheetProtection ... to />
  6. Save this edited xml file and re-add everything to the zip archive.
  7. Finally, change the extension from .zip to .xlsx.

 

Windows Server Backup - error 0x81000101

WindowsQ: Windows Server Backup keeps saying it has failed to backup. It gives me this error 0x81000101. What does this mean and why?

A: Sometimes Windows Server Backup failed to backup the data. Windows Server Backup is timing out during shadow copy creation since it is taking more than 10 minutes. Here is the resolution:

  1. Run regedit.exe and navigate to
    HKEY_LOCAL_MACHINESoftwareMicrosoftWindows NTCurrentVersionSPP”.

  2. Create a new Registry Value of type DWORD with name “CreateTimeout”.

  3. Change value to 12000000(2*10*60*1000 = 20 mins) in decimal

Windows Scheduled tasks result codes

windowsThis is good to have as a reference - common failure codes for scheduled tasks:

0 or 0x0: The operation completed successfully.
1 or 0x1: Scheduled task ran, but the application returned an error.
2 or 0x2: File not found.
10 or 0xa: The environment is incorrect.
0x41300: Task is ready to run at its next scheduled time.
0x41301: Task is currently running.
0x41302: Task is disabled.
0x41303: Task has not yet run.
0x41304: There are no more runs scheduled for this task.
0x41306: Task is terminated.
0x8004130F: Credentials became corrupted (*)
0x8004131F: An instance of this task is already running.
0x80070002: similar to file not available (2147942402)
0x8007010B: Action 'start in' directory can not be found.
0x800704DD: The service is not available (is 'Run only when an user is logged on' checked?)
0xC000013A: The application terminated as a result of a CTRL+C.
0xC06D007E: Unknown software exception.

Scan disk for errors - utility

windowsOne built in tool that is lacking in Windows since MS DOS is an ability to do surface scans. A really nice utility application that can do exactly that (among other things): HD Tune. Available as a free version or as a paid one with additional features.

Features:

 

  • Check health status of all connected drives at once
  • Detailed S.M.A.R.T information
  • Run S.M.A.R.T self-test
  • Device statistics
  • Temperature statistics

Download from here: http://www.hdtune.com/

No need to thank us.