I have encountered a problem which seemed to have no solution. I was using my laptop earlier online then turned it off. After returning a few hours later I then restarted my system to find that there were no wireless networks to be detected. I found this odd considering I was in a hotel where each floor has it's own wireless network. Normally I would find anywhere between 5-10 networks.
I started to go through everything. I tried the trouble shooter. It told me "Windows Wireless service is not enabled would you like to enable it" or something along those lines. Of course I'd click yes however it would return an error saying it couldn't.
So next I went to the search bar in vista and typed in services.msc and found that the WLAN service was set to "automatic" but wouldn't start. I tried multiple times and kept getting a windows error. To google, and here, I went.
After several hours of searching and reading through some 15+ forums I had tried tons of solutions. Apparently this is something that happens quite often with vista. I wanted to make this post so anyone experiencing this could easily find the solution instead of trying a half dozen other "solutions" that did nothing.
My research led to two solutions.
1. You have a computer virus. Use multiple online programs to find which one you have. After you have found it, cleaned, and removed it use your windows disk to repair windows.
IF YOU DON'T HAVE A VIRUS HAVE NO FEAR. THERE IS NO NEED TO INSTALL ANY PATCHES, RUN ANY "UNAUTHENTIC FIXES" OR GO HUNTING FOR THAT WINDOWS REPAIR DISK!!!!
2. Click on the "start" button then in the search line type 'CMD' minus the quotes. Do not hit enter. With CMD in the search box hold down Ctrl-Shift and press the Enter key. This will bring up a command prompt elevated to Administrative level. Next type the command 'sfc /scannow'. Your system will start doing a self diagnosis. The diagnosis can take up to 10min. At the end you will get a message of everything it has found. Once it is completed go back to the search bar and type 'services.msc'. Once the services window opens scroll down to WLAN Autoconfig, select it, and manually start the service. YOU WILL NOT HAVE TO MANUALLY DO THIS AGAIN UNLESS VISTA CAUSES THIS ERROR IN THE FUTURE!!!
I tried several fixes from download .rar patches off websites to doing regedit. This has fixed it and I have restarted my system multiple times to check. I only hope I can save someone the trouble I went through.
I'm having trouble with my windows 7 right now, it's an ultimate version, I just shut it off last night and opened it up this morning. Everything seems to be normal util I loged in to my user. The old things happend after that, only the black screen showed up and an window pop up which shows "my computer" the mouse can be moved regularly.
I tried several ways to get it back to normal:
reboot.
reboot and login to safe mode.
change the resolution and multiple monitor settings.
uninstall and reinstall the graphic driver.
ctrl+alt+del will allow me go to the regular screen which I could go to the task manager, switch user, lock the pc, signoff, change pass word, and reboot or restart etc.
I ended the "dwm.exe" in process which would not work.
That window seems like the only hope I could access the computer which pop up everytime I reboot.
I can use that pop up window to go online and go control panel and all that, I can also run all the program just like normal. Everythings sames normal besides I cannot get the normal screen, no starup, no destop icons, no quick lunch. I could change my background picture, but I cannot use right click on the background.
I think I might of just reset all registry permmissions
another error for this solution is
Software Licensing Service will not start
If you have acces to the Start button:
1) Click the Start button
2) Type: cmd in the Start Search field
3) At the top the Start window, you will see cmd.exe
4) Right Click cmd.exe and select Run as Administrator
5) Type: net start slsvc
If you do not have access to the Start button:
1) Click the option Access computer with reduced functionality
2) A Browser will open, type: %windir%\system32 into the address field
3) Find the file cmd.exe
4) Right Click on the cmd.exe and select Run as Administrator
5) Type: net start slsvc
or
All you have to do is to go to C:\windows\, right click system32 folder and clear the read only chech box. It will work.
Microsoft Office Word 2007 introduces a newly designed default template for creating documents.
You might experience any of the following line spacing issues:
Increased spacing between paragraphs.
More space than expected between lines in a paragraph.
Unexpected spacing on a page.
All future documents will open with the Word 2003 default style set and fonts.
Note If you want to use the updated Word 2007 formatting, switch to the Word 2007 style set and the Office font set. You can switch back to your custom default settings later by clicking Reset to Quick Styles from Template (in the Styles group, click Change Styles, point to Style Sets, and then click Reset to Quick Styles from Template).
Hi, I have dell laptop with windows xp home. It is not booting up even in safe mode. In safe mode it hangs after displaying loading driver isapnp.sys file. In other modes, it displays blank screen. I tried replacing the sys file from installation CD but no use. I run chkdsk command from recovery console, but no use. I tried repairing the xp using the installation CD. It did copy set of files and restarted after copying. But no use and hangs at the same isapnp.sys files. No error is shown.
isapnp.sys is normally the last driver of "system reserved" group, then xp loads "boot bus extender" group. some virus could have injected a driver belonging to this group: if your antivirus catched it or something weird happened, your xp should hang just at that point.
you have to work offline (with a live cd as ubcd4win or mounting your harddisk on a working pc, not as the bootable one obviously), check if there is something strange in windows\system32\drivers, e.g. a file .sys 0Kb long with an unusual name, then find its name in registry (it could have a bit weird registry entry too)
beware of doing a backup (exporting in a reg file) before deleting those entries. besides that, this type of viruses usually load something else, at least as autorun (e.g. under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run), so you've to check the registry for other suspect entries in known places (and/or doing an offline scan with an update antivirus)
Another critical symptom caused by this malware: This malware modifies the Userinit area in the registry (replacing the userinit.exe with wsaupdater.exe) and Ad-Aware (with a particular definition update) removes the wsaupdater.exe file from the system, thus causing the Logon - Logoff loop. That is, when you login to Windows, the \'loading personal settings\" verbose will appear, but suddenly it will logoff. This issue was documented clearly by Lavasoftusa in it\'s Lavahelp Knowledgebase.
You might see slight variations on the corrupt key, just restore to the correct value.
Additonally if the above does not work check the file is actually present, sometimes antivirus and malware scans will remove the file because of infection/corruption.
It is advised to run SFC after this procedure.
I also want to add this to the solutions for installing windows 7, it happened to me, I would get all the way up to the splash screen for the Windows 7 before you get windows install button. However, I didn't have a floppy in the computer(no one does anymore) though it was enabled in the bios and apparently the installer was looking for the floppy and just hangs, so disable it in bios and you will come up with no problems.
=(A1 - 25569)*86400
Where A1 is a cell set to display as a date. Set the cell with the above formula to display as a plain numder, and I think it will display the timestamp value.
Based on this page about the reverse transformation.
=(A1 / 86400) + 25569
This method does not seem to be correct
If we assume the date in Excel is in A1 cell formatted as Date and the Unix timestamp should be in a A2 cell formatted as number the formula in A2 should be:
= (A1 * 86400) - 2209075200
where:
86400 is the number of seconds in the day 2209075200 is the number of seconds between 1900-01-01 and 1970-01-01 which are the base dates for Excel and Unix timestamps.
The above is true for Windows. On Mac the base date in Excel is 1904-01-01 and the seconds number should be corrected to: 2082844800
Summary: You may be looking for a way to have a formula determine if a particular cell has anything in it. Here's how you can find the information. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)
There are times when it is helpful to know if a cell contains something—it doesn't really matter what it contains, just so it contains something. In these instances there are two ways you can approach the problem.
The first solution is to simply use the LEN function to determine if there is a length to what is contained in a cell. For instance, let's say you wanted to check if there was a value in cell F1. You could use the following:
=IF(LEN(F1)>0,"Found something there","Nothing is there")
If there is nothing in cell F1, then the length will be equal to zero. If there is something in the cell, even a number, then the length will be greater than zero.
The second solution is a variation on the LEN approach. All you need to do is check to see if there is anything in the cell. This may sound odd, but it is easier when you see the formula. For example, the following will check to see if there is anything in cell B4:
=IF(B4<>"","Found something there","Nothing is there")
The test in this formula is True if there is anything in the cell. If the cell is empty, then the test fails.
Another solution you can use is the ISBLANK worksheet function. This function returns True if the target cell is blank, and False if it contains anything.
As an example, let's suppose you want to check if the user has entered something in cell D7. You can use the following to make the determination:
=IF(ISBLANK(D7),"Input values missing",D7)
In this case the cell containing this formula would contain the same value as in D7, provided something was there. If there is nothing in D7, then the cell contains the text "Input values missing."
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2112) applies to Microsoft Excel versions: 97
2000 2002 2003 2007