Windows Vista SP1 without connection to Internet Solved

Today I have had an important problem with my Windows Vista SP1, with a simple solution:
netsh winsock reset


(source, that has saved my life, and Vista to be changed to XP is: Repair and Reset Windows Vista TCP/IP Winsock Catalog Corruption... Thank you!)

Form the post and the date of the post it seems to be an error of Vista and not of SP1.

the set of errors I have had include (free translations from Spanish) :
- the client DHCP was down
- unable to start Windows Socket interface
- error with the RPC service

The reparation mechanism of Vista doesn't work because it tries to repair the the DHCP client, which is not working but for other reason.

The real reason is that the TCP/IP stack Winsock settings get corrupted with wrong LSP (Layered Service Providers (?)). No idea what this means... but you can list the catalog of LSPs with: netsh winsock show catalog.

This has been one of these few times that I find a useful solution searching for a complex problem in Internet. Thanks again to the people of My Digital Life.

Excel: copy the exact content of cells

Here a couple of tips to copy the exact content/formula of a range of cells in Microsoft Excel. First some introduction and later the tricks

Some thoughts...
As you probably know, Excel has a lot of possibilities in terms of copy cells (copy only values, formula, create a reference to the other cell, transmute the content, etc).
But when you copy a formula in fact excel keeps the relative references (what is in general the expected behaviour)...
Excel has a different behaviour if you move the cells (Cut&Paste), then it moves the formula as it is without changing the references.

Trick 1
1. Select and copy (Ctrl+C) the range of cells you want to copy. (we call this area: range1)
2. Use an empty region of the sheet to paste (Ctrl+V) that content temporally. (we call this area: range2)
3. Select again the original region (range1) but this time move the cells to the region you want to copy the exact formulas. (Ctrl-X, Ctrl-V)
4. And now copy back the cell range in point 2. (what we called region2) back to the original region (range1).

... and you have it (just remove the temporal region range2).

Trick 2
This one use VBA macro script to copy the formulas:

With Sheets("Sheet1")
.Range("A11:D20").Formula = .Range("A1:D10").Formula
End With

(source: Excel User Tips)

Future Book

Thanks to a friend's blog I have discovered that the book "Market-Oriented Grid and Utility Computing" (in which I'm co-author of a chapter "Service Level Agreements in the Grid Environment", wow! :) ) is announced in Amazon.

My first book (sniff!). ;)

The book is expected in February, btw.