Windows Error Fixer: August 2016

Thursday, August 25, 2016

How Can You Fix - Calculate Time Elapsed in Excel with If Condition?

Calculate Time Elapsed in Excel with If Condition

How do you get the date to calculate in Excel for the following situation:

Column E
Date Opened
(Static Date)

Column F
Target Date
(Static Date)

Column G
Date Completed
(Static Date)

Column H
Total Time
Calculation required (Expressed in Total Days) - Need to know:

Total number of days elapsed between Column E and Today's Date (Today's Date is In a hidden cell A34) OR, if a date is entered in Column G, it should instead calculate total number of days elapsed between Column E and Column G.

Really appreciate the help.

Ann

Solutions to the Problem Calculate Time Elapsed in Excel with If Condition

Download Error Fixer for Free Now

Hi,

Try this in cell H2

=IF(G2="",$A$34-E2,G2-E2)

Hope this helps.

Use the System File Checker tool to repair corrupted or missing system files:

Click Start.
Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
Type or copy paste the below command line into it without quotes:
"Sfc /scannow"

BUGCODE_USB_DRIVER bluescreen error

Hi,
I have a problem with blue screen errors since few months.
The error given is BUGCODE_USB_DRIVER.
Dont know why this happens.
And this happens randomly even when no USB devices are connected.
I am using Windows 7 ultimate on ACER Aspire 5745 Intel core i5 (1st gen) - 430M processor.
This has a 3GB DDR3 RAM with 320GB HDD.

This had started about 8 months back in November 2011 after i installed dosbox, a blue screen error had come which dint allow me to start my machine.
Dont know whether it happened because of dosbox.
After that I had formatted my machine and re-installed
Windows 7.
After which I used to get blue screen errors regularly but it used to restart and start functioning again.
I also got a new problem of not able to change my IP settings where the properties button of IPv4 was automatically disabled and could not
be solved even after re-installing the LAN drivers.
So I had again formatted my C drive and re-installed windows 7 yesterday but the problem of blue screen error still persists though the LAN drivers problem is solved.

Today I read a post on this webpage where u had given a solution on the basis of dmp file and so I am sending u my dmp file with this link:
https://www.dropbox.com/s/ofygq06wfx7rc8a/MEMORY.DMP

Hope this information is enough for you to solve the problem.
If anything else is required please feel free to ask, I will reply back.

Thanks in advance.

Solutions to the Problem BUGCODE_USB_DRIVER bluescreen error

Download SmartPCFixer to Fix It (Free)

Machine Throttling

Click the Start button.
In the Search box, type "regedit" (without quotes) and press Enter.
Look for the following registry key: "HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\ SQMClient\Windows\DisabledSessions".
On the right window pane, delete the subkey: "Machine Throttling".
Reboot your computer.

Another Safe way to Fix the Problem: BUGCODE_USB_DRIVER bluescreen error:

How to Fix BUGCODE_USB_DRIVER bluescreen error with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.

How to Fix - c:\Windows\SysWOW64\msxml4.dll is either not designed to run on Windows or it contains an error. How can I fix this??

c:\Windows\SysWOW64\msxml4.dll is either not designed to run on Windows or it contains an error. How can I fix this?

c:\Windows\SysWOW64\msxml4.dll is either not designed to run
on Windows or it contains an error.
How can I fix this?

Keys to the Problem c:\Windows\SysWOW64\msxml4.dll is either not designed to run on Windows or it contains an error. How can I fix this?

Download Error Fixer (Free)

Machine Throttling

Click the Start button.
In the Search box, type "regedit" (without quotes) and press Enter.
Look for the following registry key: "HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\ SQMClient\Windows\DisabledSessions".
On the right window pane, delete the subkey: "Machine Throttling".
Reboot your computer.

BSOD with Microsoft wireless keyboard 6000 v3.0 and mouse 6000 v2.0

Microsoft Wireless keyboard 6000 v 3.0/mouse 6000 v2.0

I have been having problems with my wireless keyboard and mouse on my new Windows 7 64 bit pc.
Frequently, the transceiver goes in and out.
Therefore I have to move the transceiver to another usb port.
The products start working fine then I get the BSOD and
have to restart my computer.
When I restart, there are no more problems for that session.

However, when I shut my pc down for a period of time and start up again later in the day, I get the BSOD after like 10 minutes in.
At that time, I have to start up my pc again.
Which again, I have no further issues for that session.
The mouse cursor stops
moving right before the BSOD.

The drivers on the mouse, keyboard and transceiver are up to date.
I have replaced the batteries.
I dont know what else to do.
Could someone please help me?

I cringe every time I see the BSOD and have to start after improper shutdown.
It is getting frustrating.
I had no prior problems with my wireless keyboard and mouse on my old pc (vista).

Any suggestions or comments would be greatly appreciated!

Anwsers to the Problem BSOD with Microsoft wireless keyboard 6000 v3.0 and mouse 6000 v2.0

Download Error Fixer for Free Now

No problem.

Were you able to get the errors off the Blue Screen?

If not, do the following:

Start > right-click Computer > Properties > Advanced system settings > select "Settings" under "Startup and Recovery" > then un-check "Automatically restart" under "System failure" > OK > OK

Then when you get a BSOD, record all the errors on the Blue Screen and if a driver is named on the screen.

Then restart the computer manually.

Also, you can try reading the minidump files yourself.

A handy application to do this is BlueScreenView:
http://www.nirsoft.net/utils/blue_screen_view.html

However, you may find using WinDbg of the Debugging Tools for Windows gives you more complete information.

You can download the Debugging Tools for Windows from the following link:
http://www.microsoft.com/whdc/devtools/debugging/default.mspx

There is a tutorial in the following link on setting up WinDbg, such as setting the symbol path and utilizing the !analyze -v command:
http://www.sevenforums.com/crash-lockup-debug-how/26584-2-intermediate-configuring-debugging-tools.html

To get a list of drivers loaded at the time of the crash run the lmtn command.

What you are basically looking for is if the problem leans toward hardware or software.

If the problem is software related then the driver causing the crash may show up in the error.

If the driver does show up in the error you can then deal with this problematic driver.

If the driver does not show up in the error there are further steps to try to weed it out.

Boot in Safe Mode:

Open Run command as previously described
Type MSConfig
Click on Boot tab
Tick Safe boot in Boot option
Select Network
Click Apply and OK
Reboot your system

Your system will boot in Safe mode with Networking. You may now try and open Windows Store and should not see any errors.

BSOD on dell 5520 with windows 7 ultimate, the error messages are BCCode 1a, BCCode 50,

I'm having a bluescreen problem for my dell 5520 with windows 7 ultimate,

the error messages are BCCode 1a, BCCode 50, please help me to get out of this..
my laptop configuration is 750hd, 6gb ram with intel 3g i5 processsor..

Keys to the Problem BSOD on dell 5520 with windows 7 ultimate, the error messages are BCCode 1a, BCCode 50,

Download Error Fixer for Free Now

We do need the actual DMP file as it contains the only record of the sequence of events leading up to the crash, what drivers were loaded, and what was responsible.

You may be able to get the DMP files without crashing by booting into safe mode (F8) with networking.

If you are overclocking stop. (chances are if you dont know if you are, you are not)

To enable us to assist you with your computer's BSOD symptoms, upload the contents of your "\Windows\Minidump" folder.

The procedure:

* Copy the contents of \Windows\Minidump to another (temporary) location somewhere on your machine.
* Zip up the copy.
* Attach the ZIP archive to your post using the "paperclip" (file attachments) button.
*Please upload them to a file sharing service like Skydrive or"Rapidshare" and put a link to them in your reply.

To ensure minidumps are enabled:

* Go to Start, in the Search Box type: sysdm.cpl, press Enter.
* Under the Advanced tab, click on the Startup and Recovery Settings...
button.
* Ensure that Automatically restart is unchecked.
* Under the Write Debugging Information header select Small memory dump (256 kB) in the dropdown box (the 256kb varies).
* Ensure that the Small Dump Directory is listed as %systemroot%\Minidump.
* OK your way out.
* Reboot if changes have been made.

Please also run MSinfo32 and upload the output as well.

To run MSinfo32 please go to start>run>MSinfo32
Go to "file" "save" and upload the saved file with the DMPS
(Instructions for XP, Vista, Win 7, Win 8)

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.

Another Safe way to Repair the Problem: BSOD on dell 5520 with windows 7 ultimate, the error messages are BCCode 1a, BCCode 50,:

How to Fix BSOD on dell 5520 with windows 7 ultimate, the error messages are BCCode 1a, BCCode 50, with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system. Open it, and it will perform a scan for your system. The errors will be shown in the list.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.

Troubleshooting:bluetooth problem pairing device Error

bluetooth problem pairing device

i have upgrade my acer v5 to windows 8.1 Enterprise all driver have been updated, but when i wanna pairing my phone with bluetooth than i just get message says the passkey isn't right.
can anyone help me?

Keys to the Problem bluetooth problem pairing device

Download SmartPCFixer for Free Now

Because of this bluetooth problem pairing device error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.

Lastly, this error bluetooth problem pairing device can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.

In order to resolve bluetooth problem pairing device error or repair the corrupted and damaged Windows files, you will need a bluetooth problem pairing device error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:

Start the computer and log in as administrator
Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
On the new confirmation window that appears, click Next
Restart your computer after the restoration has been completed

Browser choice update

Running window xp, home edition version 2002 service pack 3.
I have installed the update of the browser choice through the updates ..when
I have restarted the pc it didn’t not make an icon on the desktop, even though its been installed where I have checked in the history of updates.
pls could I know as to why I cant see the icon of the browser choice on my desktop?
Thank you for your help
allure

Solutions to the Problem Browser choice update

Download Error Fixer for Free Now

cf.
http://aumha.net/viewtopic.php?f=7&t=43572

~Robear Dyer (PA Bear) ~ MS MVP (IE, Mail, Security, Windows & Update Services) since 2002 ~ Disclaimer: MS MVPs neither represent nor work for Microsoft

Run CHKDSK

Go to the Start button.
In the Search box, type "cmd" (without quotes) and press Enter.
At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
Reboot your computer.

Another Safe way to Repair the Problem: Browser choice update:

How to Fix Browser choice update with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your computer. When you open SmartPCFixer, it will perform a scan.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.

How to Resolve - Boot Folder works but its on a non c: drive??

Boot Folder works but its on a non c: drive?

When I recently went to make a disc image of windows, it automatically included a drive (Y) in a 2nd partition after my c drive.
And I think it is because the Boot Folder is on the Y Drive - a couple files in the boot folder had todays date so I think
its active.
I dont know why its there or how it got there - but this is the one thing that scares the daylights out of me to mess with.

I think it needs to be on my C drive but I am not sure - (I hope then it would not ask me to backup the Y drive when I am tying to make a Windows image).- Also not sure how to move it and if Windows would know where to look.

Any expert direction in the matter would be appreciated.

- Can I Move It? How?
- Should I move it?
- Should it have been there in the first place or on the C drive?
- Would that make Windows backup include the whole Y drive because the boot folder being there?

Thanks in advance

the dave

Anwsers to the Problem Boot Folder works but its on a non c: drive?

Download SmartPCFixer for Free Now

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Update and run your antivirus software. Windows doesn't come with antivirus software, but Action Center can often monitor the antivirus software that you or your computer manufacturer have installed.

Another Safe way to Fix the Problem: Boot Folder works but its on a non c: drive?:

How to Fix Boot Folder works but its on a non c: drive? with SmartPCFixer?

1. Download SmartPCFixer . Install it on your system. Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.

c:\windows\syswow64\jscript.dll [Anwsered]

c:\windows\syswow64\jscript.dll

This what i get every time i start Aol, nothing seems to work, except unloading aol.
No matter that i install new aol still get same, have deleted all of old aol from all programs and file's yet still get this ?

Keys to the Problem c:\windows\syswow64\jscript.dll

Download SmartPCFixer for Free Now

Hi ccso301,

1.    Are you getting the error message when starting AOL browser or messenger?
2.    When was the last time it was working fine?
3.    Are you able to use other programs on the computer?

If you are using Mcafee security software provided by AOL on the computer I would suggest that you uninstall Mcafee completely from the computer using the below uninstaller and check if it works.
http://service.mcafee.com/FAQDocument.aspx?id=TS100507
Note:Antivirus software can help protect your computer against viruses and other security threats.
In most cases, you shouldn't disable your antivirus software.
If you have to temporarily disable it to install other software,
you should re-enable it as soon as you're done.
If you're connected to the Internet or a network while your antivirus software is disabled, your computer is vulnerable to attacks.
If you still face issue with AOL product I would suggest that you contact AOL for more information.
http://service.mcafee.com/CustomerService.aspx?lc=1033&sg=CS&pt=1

Hope this helps!
Halima S   - Microsoft Support.
Visit our  Microsoft Answers Feedback Forum and let us know what you think.

Tweak IE Options

Open Internet Explorer.
Go to "Tools > Internet Options > Advanced Tab".
Uncheck "Enable third-party browser extensions".
Click "Apply".
Reboot your computer.

Another Safe way to Repair the Problem: c:\windows\syswow64\jscript.dll:

How to Fix c:\windows\syswow64\jscript.dll with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed

Thursday, August 25, 2016

Calculate Time Elapsed in Excel with If Condition

Solutions to the Problem Calculate Time Elapsed in Excel with If Condition

Use the System File Checker tool to repair corrupted or missing system files:

Recommended Method to Fix the Problem: Calculate Time Elapsed in Excel with If Condition:

How to Fix Calculate Time Elapsed in Excel with If Condition with SmartPCFixer?

BUGCODE_USB_DRIVER bluescreen error

Solutions to the Problem BUGCODE_USB_DRIVER bluescreen error

Another Safe way to Fix the Problem: BUGCODE_USB_DRIVER bluescreen error:

How to Fix BUGCODE_USB_DRIVER bluescreen error with SmartPCFixer?

c:\Windows\SysWOW64\msxml4.dll is either not designed to run on Windows or it contains an error. How can I fix this?

Keys to the Problem c:\Windows\SysWOW64\msxml4.dll is either not designed to run on Windows or it contains an error. How can I fix this?

Recommended Method to Fix the Problem: c:\Windows\SysWOW64\msxml4.dll is either not designed to run on Windows or it contains an error. How can I fix this?:

How to Fix c:\Windows\SysWOW64\msxml4.dll is either not designed to run on Windows or it contains an error. How can I fix this? with SmartPCFixer?

BSOD with Microsoft wireless keyboard 6000 v3.0 and mouse 6000 v2.0

Anwsers to the Problem BSOD with Microsoft wireless keyboard 6000 v3.0 and mouse 6000 v2.0

Boot in Safe Mode:

Recommended Method to Repair the Problem: BSOD with Microsoft wireless keyboard 6000 v3.0 and mouse 6000 v2.0:

How to Fix BSOD with Microsoft wireless keyboard 6000 v3.0 and mouse 6000 v2.0 with SmartPCFixer?

BSOD on dell 5520 with windows 7 ultimate, the error messages are BCCode 1a, BCCode 50,

Keys to the Problem BSOD on dell 5520 with windows 7 ultimate, the error messages are BCCode 1a, BCCode 50,

Another Safe way to Repair the Problem: BSOD on dell 5520 with windows 7 ultimate, the error messages are BCCode 1a, BCCode 50,:

How to Fix BSOD on dell 5520 with windows 7 ultimate, the error messages are BCCode 1a, BCCode 50, with SmartPCFixer?

bluetooth problem pairing device

Keys to the Problem bluetooth problem pairing device

Recommended Method to Repair the Problem: bluetooth problem pairing device:

How to Fix bluetooth problem pairing device with SmartPCFixer?

Browser choice update

Solutions to the Problem Browser choice update

Another Safe way to Repair the Problem: Browser choice update:

How to Fix Browser choice update with SmartPCFixer?

Boot Folder works but its on a non c: drive?

Anwsers to the Problem Boot Folder works but its on a non c: drive?

Another Safe way to Fix the Problem: Boot Folder works but its on a non c: drive?:

How to Fix Boot Folder works but its on a non c: drive? with SmartPCFixer?

c:\windows\syswow64\jscript.dll

Keys to the Problem c:\windows\syswow64\jscript.dll

Another Safe way to Repair the Problem: c:\windows\syswow64\jscript.dll:

How to Fix c:\windows\syswow64\jscript.dll with SmartPCFixer?