Thursday, 31 March 2016

How to Resolve - Advance Filter in Excel 2007 is locking up?

Advance Filter in Excel 2007 is locking up

I have a large database - (76K+ records and growing) and am having trouble running the Advanced Filter.  It often locks up.  Most of the time I have to save and close the spreadsheet every time I change my critera and want to run another filter.   Sometimes
it won't run at all.
 
I've been told I need a more powerful PC and I've also been told that Excel 2010 solves this problem.
 
Unfortunately, I work for state government and neither of the options are currently available to me.
 
Does anyone have any suggestions to solve my problem?

Solutions to the Problem Advance Filter in Excel 2007 is locking up

Download SmartPCFixer for Free Now

Does the issue occur with all Excel files or a particular file?
 
Try creating a test database and check if issue persists.
You may also try re-saving the file using the Save as option on a different location and then check how it works.
 
You may also check how Excel works in safe mode.
To do that, close Excel.
Click on Start – All Programs – Accessories – Run, and in the open box type in excel /safe and hit ok.
(Note: There is a space between Excel and /). Once Excel is open, click on File ->Open and open the file causing the issue.
 
If Excel works in the safe mode, try disabling the Add-ins associated with Excel and check.
Refer to the section “A COM add-in is causing problems“ from the following article:
http://support.microsoft.com/kb/919196

Cleaning your computer, components, and peripherals help keep everything in good working condition and helps prevent germs from spreading. You can't image how dirty the inside of your computer case can get. All the dust and dirt is going to prevent proper air flow and may even prevent the fan from working.

Recommended Method to Repair the Problem: Advance Filter in Excel 2007 is locking up:

How to Fix Advance Filter in Excel 2007 is locking up with SmartPCFixer?

1. Download Error Fixer. Install it on your computer.

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


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Solution to Error: adding a page border to my document,[Solved] After installing 'ezcap digital ATSC TV stick' using key gen, get blue screen error \"DRIVER_IRQL_NOT_LESS_OR_EQUAL\",Troubleshooting:Adobe Reader question (not working)....In the right place? Error,Troubleshoot:Adding superscript button to quick access toolbar Error,Solution to Error: adobe flash player keeps flashing at the bottom of my screen,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

Adding cells based on different criteria [Solved]

Adding cells based on different criteria

Hi,
 
I have a spreadsheet were I have to count or add a number of cells based on certain conditions.
For example, I have on I14:I16 a list were I can choose "Yes, No, or N/A" on either cell.
When either option is selected, J14:J16 auto populates with "8%, 0%,
or blank" ("") from the following formula I pasted =IF(I14=$R$3,8.33%,IF(I14=$R$4,0%, IF(I14=$R$5,"")))
 
On Cell J17 I have entered the following formula =IF(SUM(J14:J16)>=0,SUM(J14:J16),25%)
were I'm basically asking to sum J14:J16 if and only if there is a present value greater or equal to 0 and if there isn't a value (Null) I then want the end result to be "25%" Below is an example of my spredsheet
 


Result
Score

Yes 
8%

No
0%

N/A
 

 
8%

 
As you can see the formula does recognize there are values present; therefore, it adds the values, but when "N/A" is seleted in all three cells it gives me 0% instead of 25%.
Example below.


Result
Score

N/A
 

N/A
 

N/A
 

 
0%

 
Can someone please help with my formula.
Is there another formula I can use?
 
Thanks

Anwsers to the Problem Adding cells based on different criteria

Download Error Fixer (Free)

You could use
=IF(COUNTIF(I14:I16,$R$5)<3,SUM(J14:J16),25%)
I.e.
if not all three cells I14:I16 contain N/A, return the sum of J14:J16, otherwise 25%.

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.
  • Restart your computer.

Recommended Method to Repair the Problem: Adding cells based on different criteria:

How to Fix Adding cells based on different criteria with SmartPCFixer?

1. Download SmartPCFixer. Install it on your computer.

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

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


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Troubleshooting:After I didn't plug my battery in in time I lost one file which I was just working on and it's not in recycle bin and it doesn't come up when I try to search for it Error,Troubleshooting:Adding controls to Word documents,Troubleshoot:adding numbers contained in different cells Error,Troubleshooter of Error: adobe flash player 11 beta for ie9 64 bit any problems?,How to Fix - After clean installing Windows 7 from Vista, i am unable to connect to the internet.?,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

How Can I Fix - Aero is not working and windows startup with error " windows cannot connect to the sens server"?

Aero is not working and windows startup with error " windows cannot connect to the sens server"

Original title: Aero issues and error message
Hi, i have windows 7 and its been running fine for over a year.
Recently Aero will not work and a "windows cannot connect to the sens server" message apears when it boots.
i created a guest account so i have been starting this account on boot up which has
aero disables and the error message.
Then i switch user accounts to mine and windows runs fine.
So whichever account boots first has the problems.
Please Help as my hair is nearly all pulled out !

Keys to the Problem Aero is not working and windows startup with error " windows cannot connect to the sens server"

Download SmartPCFixer to Fix It (Free)

Hi,
Method 1:
Once you face this issue you can check in the Task Manager if there is a program running attached to it.

a.
Right click on Task bar and click on Task Manager.
b.
In the Windows Task Manager Window go to "Processes" and check if there is any program associated with those folders.

Method 2: 
You can also run the Microsoft Security scanner and check if any infections are causing the issue.
http://windows.microsoft.com/en-US/windows/products/security-essentials
Note.
If any infections are detected then there is a chance that the infected data may be deleted.
Method 3:
Try performing SFC scan on the computer.
 
a.    Click “Start”, click All “Programs”, click “Accessories”, right-click “Command Prompt”, and then click “Run as administrator”.
If you are prompted for  an administrator password or for a confirmation, type the password,
or click  “Allow”
b.    Type the following command, and then press ENTER:  “sfc /scannow” (without the quotes)  

 [The sfc /scannow command scans all protected system files and replaces incorrect versions with correct Microsoft versions.]
Check the below mentioned link for further guidance on SFC scan –
 
http://support.microsoft.com/kb/929833 
Method 4:
If you are unable to resolve the issue, then I suggest you to check in a clean boot state and try renaming the folder.
Clean boot helps you determine if any third party application may be the cause of the issue.
If you are able to determine, if any third party application is causing the issue then you can uninstall the application.
How to troubleshoot a problem by performing a clean boot in Windows Vista or in Windows 7
http://support.microsoft.com/kb/929135
Note: Do not forget to return the computer to normal after completing the troubleshooting by following the steps under step 7.

  • Download the Microsoft Windows ISO (installation device) from the following website:
  • http://www.microsoft.com/en-us/software-download/windows10
  • Users must select the appropriate ISO, either 32 bit or 64 bit, depending upon their individual computer.
  • Extract the ISO file to a separate USB device or burn the program to a compact disc.
  • Run the Microsoft Windows 10 upgrade directly from the software that you have thus created.

Another Safe way to Repair the Problem: Aero is not working and windows startup with error " windows cannot connect to the sens server":

How to Fix Aero is not working and windows startup with error " windows cannot connect to the sens server" with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Open it, and it will scan your system. 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 done, the speed of your computer will be much higher than before and the errors have been fixed.


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Troubleshooting:After auto sleep shutdown, computer won't start back up Error,How to Fix - Adobe Audition 2.0 Windows 7 compatibility?,Adding and deleting Cals and user from Microsoft sever 2008 R2 [Anwsered],Troubleshoot:adding page number in word 2007 Error,add sheets [Anwsered],a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

After an update, all Office files opening with 2010 Starter, not Office 2007

After an update, all Office files opening with 2010 Starter, not Office 2007

Yesterday my Microsoft Excel 2007 was working just fine.  I have Microsoft Starter 2010 on my computer but isn't ever used and all my files are automatically opened using the 2007 version.  Last night my computer did an automatic update and now suddenly
everything is being opened with the Starter 2010.  Knowing NOTHING about computers, I went ahead and unistalled EVERYTHING Microsoft 2010 Trial-related hoping that would work.  It didn't.  And now I can't open any of my excel files!  I try to tell it to select
Excel 2007 but it isn't listed as a program anywhere.  Right now I'm able to open Excel 2007 from my startup and open these files but when I double-click on them, it doesn't know how to open it.  Please help!

Keys to the Problem After an update, all Office files opening with 2010 Starter, not Office 2007

Download Error Fixer (Free)

With Excel open(from your startup) click on the Office Button>Excel Options>Resources.
 
Run Diagnostics from there.
 
See if that helps.
 
You may also re-register Excel 2007 if you choose.
 
Start>Run    "C:\Program Files\Microsoft Office\Office12\Excel.exe" /regserver
 
Note the space before the /regserver
 
You may have to use  /unregserver first but give it a try.
 
 
Gord

Note: It is recommended that you back up your files and folders before attempting this step:

  • Move the mouse cursor over to the upper right side of the screen.
  • A menu will pop up on the left. Click on the "Settings" feature on the menu.
  • On the Settings window, click on the "Change PC settings."
  • Now, left click on the "Update and recovery" feature.
  • For the next step, left click on the "Recovery" feature.
  • There is an option here saying "Refresh your PC without affecting your files." There, left click on the "Get started" button.
  • Now, follow the instructions on the screen to finish the Refresh process.
  • After the Refresh process has finished restart your Windows 8.1 or Windows 8 device.
  • Check again to see if the error After an update, all Office files opening with 2010 Starter, not Office 2007 has been fixed.

If you do not possess the technical expertise required to accomplish this yourself or do not feel comfortable doing so, download and install a powerful automated tool to get the job done.

Recommended Method to Fix the Problem: After an update, all Office files opening with 2010 Starter, not Office 2007:

How to Fix After an update, all Office files opening with 2010 Starter, not Office 2007 with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your computer. 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. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Troubleshooter of Error: Adding and removing bluetooth COM ports changes wallpaper,[Solved] Aero Peek minimizing windows,ADDRESS LABELS FROM EXCEL SPREADSHEET [Anwsered],Troubleshoot:Adding superscript button to quick access toolbar Error,address bar history wont delete Tech Support,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

How to Fix Error - After backup, message appears- files skipped notepad file 0x80070002?

After backup, message appears- files skipped notepad file 0x80070002

after backup message appears some files skipped notepad file 0x80070002
[Moved from Internet Explorer / edited for clarity]

Solutions to the Problem After backup, message appears- files skipped notepad file 0x80070002

Download SmartPCFixer to Fix It (Free)

Hi,
 
1. What is the complete error message?
2. Have you made any changes to the computer prior to the issue?
 
The Error code relates to unsuccessful back up of certain locations, which would be because the data was moved from its original location when the original backup was setup.
If the backup destination isn't available when Windows Backup tries to create
your backup, you get an error message.
You can change the backup destination and remove the locations as it would search for the previous locations when the automatic backup was setup.
 
You can also try the steps in the below article that will give you information on troubleshooting issues when you get the error ‘The backup completed but some files were skipped’:
http://support.microsoft.com/kb/979281

Hope this helps.

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 Repair the Problem: After backup, message appears- files skipped notepad file 0x80070002:

How to Fix After backup, message appears- files skipped notepad file 0x80070002 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 which need to be fixed.

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


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Solution to Error: add year to a specific date cell based on chosing one value from a Drop down list cell.,Troubleshoot:adobe flash 13 crashes with C runtime error on W7pro,Fast Solution to Problem: address bar.HOW DO i delete sites,After getting a Blue Screen error, I cannot start XP Mode, get error \"The virtual machine could not be registered because the configuration file does not exist\" Tech Support,Troubleshooting:Add printer to mini-tool bar in Word 2010 Starter Edition,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

How to Fix Problem - After Explorer auto update can not retrieve my email. Get white screen.?

After Explorer auto update can not retrieve my email. Get white screen.

Have stopped using Explorer because of this.  Am now using Firefox.

Anwsers to the Problem After Explorer auto update can not retrieve my email. Get white screen.

Download SmartPCFixer to Fix It (Free)

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.
  • Restart your computer.

Another Safe way to Repair the Problem: After Explorer auto update can not retrieve my email. Get white screen.:

How to Fix After Explorer auto update can not retrieve my email. Get white screen. with SmartPCFixer?

1. Click the button to download Error Fixer . 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 which need to be repaired.

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


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: How to Resolve - advanced system care will not run, says it's missing rtl120.bpl?,Troubleshoot:After hiding columns when i am trying to print, left side of hiding line goes to saperate page then right side of hiding line, why? Error,Solution to Problem: Adobe Flash Player problems With Internet Explorer,How to Fix Problem - Aero Not Working! Used to Work on the PC...?,Solution to Error: After being left running without a monitor, windows 7 pro stops responding to a monitor and terminal and remote desktop,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

after i updated my hp laserjet 1020 driver it doesnt connect to microsoft office 2010 anymore Tech Support

after i updated my hp laserjet 1020 driver it doesnt connect to microsoft office 2010 anymore

i accidentally hit an optional update from windows live update for my hp printer laser jet 1020.
from that day on my Microsoft office 2010 can not connect to my printer.  but i can print with my printer other stuff like photos, web pages,.....

it just doesn't connect to my Microsoft office 2010 all of a sudden.
i even used different troubleshooters, downloaded latest printer driver but still nothing.
any idea how to fix that?
im starting to think i should uninstall my Microsoft office and reinstall it again.

Solutions to the Problem after i updated my hp laserjet 1020 driver it doesnt connect to microsoft office 2010 anymore

Download Error Fixer (Free)

Note: It is recommended that you back up your files and folders before attempting this step:

  • Move the mouse cursor over to the upper right side of the screen.
  • A menu will pop up on the left. Click on the "Settings" feature on the menu.
  • On the Settings window, click on the "Change PC settings."
  • Now, left click on the "Update and recovery" feature.
  • For the next step, left click on the "Recovery" feature.
  • There is an option here saying "Refresh your PC without affecting your files." There, left click on the "Get started" button.
  • Now, follow the instructions on the screen to finish the Refresh process.
  • After the Refresh process has finished restart your Windows 8.1 or Windows 8 device.
  • Check again to see if the error after i updated my hp laserjet 1020 driver it doesnt connect to microsoft office 2010 anymore has been fixed.

If you do not possess the technical expertise required to accomplish this yourself or do not feel comfortable doing so, download and install a powerful automated tool to get the job done.

Another Safe way to Repair the Problem: after i updated my hp laserjet 1020 driver it doesnt connect to microsoft office 2010 anymore:

How to Fix after i updated my hp laserjet 1020 driver it doesnt connect to microsoft office 2010 anymore with SmartPCFixer?

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

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

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


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Adding Default Colors Tech Support,Aero Crashes Installing Program on windows 7 RC1 [Anwsered],Troubleshooting:Administrator does not have permission Error,How Can I Fix - adjustment of brightness not working on sony vaio?,ADDRESS LABELS FROM EXCEL SPREADSHEET [Anwsered],a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

Fast Solution to Error: Address Bar. unable to remove All history...only some. Have tried using Registry Key etc.

Address Bar. unable to remove All history...only some. Have tried using Registry Key etc.

Have used the Hkey_current user\software\microsoft\internet explorer\ typed URLs  but it doesn't show the URL's of the sites I want to remove.

Keys to the Problem Address Bar. unable to remove All history...only some. Have tried using Registry Key etc.

Download Error Fixer for Free Now

the address bar I want to clean is the bar located on the task bar, lower right, and activated by mousing over the taskbar and then checking it,

Hi Ed,
I don't think you can clear selected history items from this Address Bar (on the Taskbar.) You will probably have to verify that "Preserve favorites website data" is unchecked and clear all History.
Don

Manually editing the Windows registry

Caution: Unless you an advanced PC user, please do not edit the Windows registry manually.

Because of this risk, we highly recommend using a trusted registry cleaner such as SmartPCFixer Using a registry cleaner automates the process of finding invalid registry entries, missing file references (like the one causing your MACHINE_CHECK_EXCEPTION error), and broken links within the registry. A backup is automatically created before each scan, with the ability to undo any changes in a single click, protecting you against the possibility of PC damage. The best part is that repairing registry errors can also dramatically improve system speed and performance.

  • Click the Start button.
  • Type "command" in the search box... DO NOT hit ENTER yet!
  • While holding CTRL-Shift on your keyboard, hit ENTER.
  • You will be prompted with a permission dialog box.
  • Click Yes.
  • A black box will open with a blinking cursor.
  • Type "regedit" and hit ENTER.
  • In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
  • From the File menu, choose Export.
  • In the Save In list, select the folder where you want to save the Windows Operating System backup key.
  • In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
  • In the Export Range box, be sure that "Selected branch" is selected.
  • Click Save.
  • The file is then saved with a .reg file extension.
  • You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.

The next steps in manually editing your registry will not be discussed in this article due to the high risk of damaging your system. If you would like to learn more about manual registry editing, please see the links below.

Another Safe way to Repair the Problem: Address Bar. unable to remove All history...only some. Have tried using Registry Key etc.:

How to Fix Address Bar. unable to remove All history...only some. Have tried using Registry Key etc. with SmartPCFixer?

1. Download Error Fixer . Install it on your computer.  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 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.


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Fast Solution to Error: After doing an update for Adobe, now my Internet Explorer icon is missing,Troubleshoot:After changing network settings, there are two greyed out "desktop" files on my desktop and I cannot delete them,How to Fix Error - after deleting some file, HP dock is missing?,Troubleshoot:Adobe Flash Player replacement Q?????? Error,[Solved] Adobe Photoshop CS on Windows 7 - personalization information,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

How Can I Fix - adjustment of brightness not working on sony vaio?

adjustment of brightness not working on sony vaio

initially my laptop has brightness adjustment on vaio worked very well in windows 8 after few days i upated to 8.1 , then also intially worked but now brightness adjustment is not working at all 
my vaio model no:svf15318snb
please help me to solve this issue

Anwsers to the Problem adjustment of brightness not working on sony vaio

Download Error Fixer (Free)

Hi,
Just in case you would have missed those threads before posting:
http://answers.microsoft.com/en-us/windows/forum/windows8_1-hardware/sony-vaio-laptop-upgrade-to-windows-81-brightness/f915bf10-bb69-4246-95ee-46adf2bb41f7http://www.designstudioschool.com/vaio-windows-upgrade-brightness-issue-t253415.html
there are many others here and there on the Net...
Hope this helps
Cheers
Lz.

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: adjustment of brightness not working on sony vaio:

How to Fix adjustment of brightness not working on sony vaio 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.


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: [Anwsered] adobe flashplayer not working with internet explorer 9,Fast Solution to Problem: Adobe Flash Player is not running in IE10.,[Anwsered] Adobe reader icon has taken over all my programs,Tech Support: Advice for 450/456 Hard Disk Partition,How to Fix Error - after deleting some file, HP dock is missing?,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded