Sunday, July 24, 2011

The operation failed since no adapter is in the state permissible for this operation.

This particular error and many others similar to this are related to Winsock corruption which is a part of TCP/IP. Microsoft has given detailed instructions on detecting the corruption and the methods to recover from it. Providing the link, hope it helps

http://support.microsoft.com/kb/811259

Friday, July 8, 2011

Excel 2003 files open slow on Network share

Recently one of the users was having this issue on his XP Professional machine with Office 2003 installed. When he tried accessing excel files on the network, they would take quiet a lot of time to open. This is the way i diagnosed/solved it.
1. The excel files on local pc would open fine, which suggested that the installation was fine, but still did a repair which did not solve the issue.
2. After some searching. i reached an article and the solution over there worked. Heres the explaination.

The reason why it opens slow is because of an Add-in called OFV ( office file validation ). What it does is that, before opening the file, OFV reads it to make sure its trustworthy. Now, when this is done over the network, the process takes time, and hence it takes longer to open the file. Disabling OFV solves the problem. Steps to do it.
1. Start-> Run-> Regedit.
2. HKEY_CURRENT_USER\Software\Microsoft\Office\11.0
3. After you select the key point to New on the Edit menu, and then click Key.
4. Type Excel, and then press ENTER.
5. Select Excel, point to New on the Edit menu, and then click Key.
6. Type Security, and then press ENTER. ( You might already be having the key security, if so skip the steps 3-6 and proceed to step 7 to create the key in Security )
7. Select Security, point to New on the Edit menu, and then click Key.
8. Type FileValidation, and then press ENTER.
9. Select FileValidation, point to New on the Edit menu, and then click DWORD Value.
10. Type EnableOnLoad, and then press ENTER.
Note: The default value is 0 which disables the validation.
11. On the File menu, click Exit to quit Registry Editor.

Now try accessing a network Excel file, which should open normally ( faster than before ).

Sources : http://support.microsoft.com/kb/2570623
http://pariswells.com/blog/fixes/excel-2003-slow-opening-from-network-share

Thursday, July 7, 2011

This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator.

When opening a link ( website/email link ) from outlook in Windows Vista, the error stated in the title comes up. If the default browser is internet explorer, it is not enough and the default browser has to be specified at another place. The following has to be done to solve the issue.
1. Click Start-> Program Defaults
2. Set Program Access and Computer defaults.
3. Drop down the Custom option.
4. In choose a default browser click on: "Internet Explorer".

Now the link should open in Internet Explorer.


compile error in hidden module: autoexecnew in word/excel

The error "compile error in hidden module: autoexecnew" shows up when word/excel is opened and the error "compile error in hidden module: distmon" shows up when its closed. This is because "pdfmaker.dot" and "pdfmaker.xla" are in the microsoft office startup and microsoft excel startup folder respectively. To remove this follow the steps:
Delete pdfmaker.dot ( for word )
1. Search the file and delete.
2. Locate the file in C:\Program Files\Microsoft Office\Office11\Startup
3. C:\Documents and Settings\User Name\Application Data\Microsoft\word\Startup


Delete pdfmaker.xla ( for excel )
1. Search the file and delete.
2. Locate the file in C:\Program Files\Microsoft Office\Office11\Xlstart
3. C:\Documents and Settings\User Name\Application Data\Microsoft\Excel\Xlstart


These files can be either in both or at one location. Once they are deleted, the error will no longer show up.

Friday, July 1, 2011

Blank screen after "Press any key to boot from CD"

Recently while trying to install Windows Xp professional on an old computer, i got into this strange problem, where nothing happened after i tried booting from the CD. I mean, the computer would be ON, but it would not run the normal blue screen where it inspects the hardware before installation starts.
So, after going through a few forums, i got to know that if the Hard disk had previously installed Linux on it, this could happen.
The solution to this is to Wipe clean the hard Disk. There is a utility "Darik's Boot and Nuke" which does the job perfectly. The link is http://www.dban.org/
Download the iso image, burn it on a CD, boot from the CD and clean the Hard Disk.
Definitely solved the problem for me.