Excel 2003 Office File Validation (OFV) opens workbooks slower across the network

You can use the EnableOnLoad registry entry to configure how you want Excel to handle opening workbooks for the OFV. By default, the EnableOnLoad entry is not present in the Windows registry. To add the EnableOnLoad entry to the Windows registry, follow these steps:

1.Exit Excel.

2.Click Start, click Run, type regedit, and then click OK.

3.Locate and then click to select the following registry key:


4.After you select the key that is specified in step 3, point to New on the Edit menu, and then click Key.

5.Type Excel, and then press ENTER.

6.Select Excel, point to New on the Edit menu, and then click Key.

7.Type Security, and then press ENTER.

8.Select Security, point to New on the Edit menu, and then click Key.

9.Type FileValidation, and then press ENTER.

10.Select FileValidation, point to New on the Edit menu, and then click DWORD Value.

11.Type EnableOnLoad, and then press ENTER.

Note: The default value is 0 which disables the validation.

12.On the File menu, click Exit to quit Registry Editor.

To Create My Computer Shortcut When Deleted and on Classic view XP

Step 1.

Create New Shortcut

Step 2

Copy paste this line and paste on the location :

explorer ::{20D04FE0-3AEA-1069-A2D8-08002B30309D}

Click finish. The New My Computer Icon is created.

Apologize with Skill

“What do I say when it’s all over … And sorry seems to be the hardest word.” — Elton John
Mistakes happen.  People fall down.  What’s important is how you get back up.  This is really geared towards leaders and pro-active repair, but I think the frame below is useful in many everyday situations.  It’s powerful because you’re owning your mistake, you’re acknowledging it, and you’re finding a way forward.  What you resist persists, and dwelling doesn’t help.
In the book, Power Thinking: How the Way You Think Can Change the Way You Lead , John N. Mangieri, Ph.D., and Cathy Collins Block, Ph. D., write about proactively repairing when things go wrong, as a more effective way to think and act.
4 Steps to Practice Repair
Mangieri and Block share the following steps for proactive repair:
  1. Find out what went wrong.
  2. Apologize for negative outcomes that your decision or behavior caused.
  3. Explain why you made the decision (or took the initial, ineffective action.)
  4. State what you want to achieve in the future with a new decision or action.
I think an important addition is empathic listening — listen until the other person feels heard, and don’t get defensive.
When do you use these steps? According to Mangieri and Block, “as soon as a leader’s self-respect diminishes, indicating that a decision or behavior just enacted was not effective or proper.”
Mangieri and Block say that it’s about acknowledging what went wrong, and co-creating the future:
Repair occurs whenever it is necessary to enact a thoughtful action to remedy the damage or ill will that a past decision or action created.  Repair begins by acknowledging the negative consequence your actions caused (by saying, for example, “I am aware that my decision angered and frustrated many of you”).  Then you state that you want to avoid such detrimental effects in the future.  Openly ask for others to offer suggestions that can ensure that such decisions or action will not occur again, and state an action that you are going to take to ensure that it does not.
From what I’ve seen, even if you fumble with the words, if it’s from the heart, that’s what matters.
In the end, the most important thing is — it’s got to come from the right place.
Source from : http://sourcesofinsight.com/apologize-with-skill

Re-create the Show Desktop Icon

To re-create the Show desktop icon yourself, follow these steps:
  1. Click Start, click Run, type notepad in the Open box, and then click OK.
  2. Carefully copy and then paste the following text into the Notepad window:
  3. On the File menu, click Save As, and then save the file to your desktop as "Show desktop.scf". The Show desktop icon is created on your desktop.
  4. Click and then drag the Show desktop icon to your Quick Launch toolbar.

To Get User's IP Address ASP.Net C#

            // Get request.
     HttpRequest request = base.Request;

     // Get UserHostAddress property.
     string address = request.UserHostAddress;

Time Changes What’s Important

“The key is in not spending time, but in investing it.” — Stephen R. Covey  
One of the main reasons To Do lists, backlogs, and lists of all the things you need to get done rots over time is because time changes what’s important.
That’s a good thing.
Because time changes what’s important, it’s a do a reset and a re-think on what your next best thing to do is.  Before you just grab things from your lists or from your backlog, ask yourself a few questions:
  1. Is this still relevant?
  2. Is this still important?
  3. Is this my next best thing to do?
This is a quick way to step back and take a look from the balcony.  By asking if this is still relevant or still important, you can let things slough off and free yourself up for doing stuff that matters.  Letting stuff slough off makes space for the great stuff.
By asking if this is your next best thing to do you’re asking a question about windows of opportunity.   It’s true that a stitch in time saves nine, and you really can miss the boat for some things.  By paying attention to your windows of opportunity, you can get time on your side.


The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine?

The error occured in an asp.net application while trying to upload data from an excel file to a database.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.


Downladed the 2007 Office System Driver: Data Connectivity Components and installed on the hosted server and the issue was sorted.

The 2007 Office System Driver: Data Connectivity Components could be downlaoded from the following link http://www.microsoft.com/downloads/en/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en


Google Changes Search Algorithm

Google Changes Search Algorithm

Unprotect a Protected Excel Workbook

To unprotect a protected workbook all you have to do is to run this macro on the protected workbook. It really worked on me.

Happy Endings !

Sub PasswordBreaker()
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub
Copyright © My Beat