Thursday, March 31, 2016

Tech Support: Add or Remove Programs

Add or Remove Programs

I get a list of programs in Add or Remove, but when I click on one I no longer get the option to remove.
HP Help said it may be due to a recently down loaded Windows Update.

Anwsers to the Problem Add or Remove Programs

Download SmartPCFixer for Free Now

Manually editing the Windows registry

Manually editing the Windows registry to remove invalid MACHINE_CHECK_EXCEPTION keys is not recommended unless you are PC service professional. Incorrectly editing your registry can stop your PC from functioning and create irreversible damage to your operating system. In fact, one misplaced comma can prevent your PC from booting entirely!


Caution: Unless you an advanced PC user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

To manually repair your Windows registry, first you need to create a backup by exporting a portion of the registry related to MACHINE_CHECK_EXCEPTION (eg. Windows Operating System):

  • 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.

Another Safe way to Fix the Problem: Add or Remove Programs:

How to Fix Add or Remove Programs with SmartPCFixer?

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

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

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, 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: Tech Support: Advice for 450/456 Hard Disk Partition,Solution to Error: adobe flash player is not recognized by my computer.,Troubleshooter of Error: After I install map point 2010 I get an error message "Your registry settings for this application were not copied correctly". How can I fix this?,How to Fix Error - Adding\/Saving Multilevel \"List in Current Documents\" to the \"List Library\"?,Troubleshooter of Error: Administrator profile will not load in Win 7 and all suggested repairs not working HELP!,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

Adobe Flash Player Freezing Windows 7-problems

Adobe Flash Player Freezing Windows 7-problems

I have recently installed windows 7 on my HP pavillion Notebook.
And started having this problem about 3 weeks after.
I will go to a website and the video will freeze and the browser will become unresponsive.
When this happens, all programs that run a
video (like a game) or windows media player will not respond when open.
So i uninstall adobe completely and restart my computer.
Reinstall (have used different sources) and restart.
I will then be able to view videos (but the problem will return sometimes
in a hour some times in a couple of days) and I will have to restart the whole process again.
(i have tried clear my cache same problem)

Keys to the Problem Adobe Flash Player Freezing Windows 7-problems

Download Error Fixer (Free)

MattMay1001,

Below is a link to the correct video drivers for your system and 64-bit OS:
http://h10025.www1.hp.com/ewfrf/wc/softwareDownloadIndex?softwareitem=ob-76077-1&lc=en&dlc=en&cc=hk&product=3979336&os=4063&lang=en

Hope that helps!

Cody C
Microsoft Answers Support Engineer
Visit our
Microsoft Answers Feedback Forum and let us know what you think.

To install drivers and other optional updates

  1. To install optional updates, you need to review and then select them from the list of updates that Windows finds for your computer. Optional updates are not installed automatically.
  2. Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
  3. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
  4. If any updates are found, click View available updates.
  5. Select the optional updates that you want, and then click Install. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

Recommended Method to Repair the Problem: Adobe Flash Player Freezing Windows 7-problems:

How to Fix Adobe Flash Player Freezing Windows 7-problems 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 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 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 Problem: additional monitors not working after 8.1 upgrade,Tech Support: After abolut 1 minute of idle time the window closes and I have to go back ands open the window I was using,Solution to Problem: adobe premier elements corrupts WMV files,How to Resolve - after a power failure vista will not boot nor can I boot from cd as drivers will not load?,Troubleshoot:Adobe 9 Pro activation,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 a Windows Update (XP) my dial-up internet connection hangs up

After a Windows Update (XP) my dial-up internet connection hangs up

Earlier this past summer after letting one of my netbook computers do an "update" to Windows my dial-up connection to the internet hangs up.  I didn't troubleshoot it at the time since I had another XP netbook that had not been updated and it continued to
work.  Unfortunately the next time I had a high speed connection available I let it update that netbook also, and now it  hangs up on the dial-up connection.  In both cases I use the same modem.  I have connected that modem to a Windows 7 computer and it dials
and connects to the internet and works just fine.  It is something to do with the Windows Updates to the XP netbooks.  Is there a known problem with this?

Keys to the Problem After a Windows Update (XP) my dial-up internet connection hangs up

Download Error Fixer for Free Now

...I am a little concerned about all of the specific questions regarding my internet security

You should be concerned!  McAfee (and Norton) applications are notorious for not upgrading (or uninstalling) cleanly.
Note: The following assumes that none of your McAfee subscriptions (or free-trial period) have
ever expired...
[You will want to print these instructions for offline reference.
If a Step says to reboot,
reboot! ]
1.
Download the McAfee Consumer Products Removal Tool, saving it to your desktop: 

http://download.mcafee.com/products/licensed/cust_support_patches/MCPR.exe
2.
Close all open applications (i.e., anything with an icon on the taskbar).
3.
Physically disconnect the computer from the internet and any local networks.
4.
Uninstall McAfee Internet Security via Add/Remove Programs & reboot.
5.
IMPORTANT! => Make absolutely certain that the Windows Firewall is enabled (yes, even though you're not connected to the internet).
6.
Double-click on the file you saved in #1 above to run the utility.
Don't TOUCH your keyboard until the run completes, then reboot again.
7.
Reconnect your computer to the internet.
Don't do ANYTHING else online until you've completed ALL of the steps below!
8.
Do a clean install of Norton Internet Security using your CD.  If you purchased your software directly from McAfee, go to
https://home.mcafee.com/Secure/Protected/Login.aspx to log in and download your software.  FOLLOW ALL PROMPTS!
9.
IMPORTANT! => Manually & repeatedly update McAfee Internet Security until you get a "no more updates" or similar prompt.
10.
Open Internet Explorer (only!) to
http://support.microsoft.com/kb/923737 & run the Fix It.
11.
IMPORTANT - DON'T SKIP THIS STEP! => Open Internet Explorer (only!) to
http://support.microsoft.com/kb/971058 [ignore any DOES NOT APPLY or NOT RECOMMENDED warnings] & run the Fix It in DEFAULT
and then AGGRESSIVE modes.
[1] [2]
12.
Reboot one last time & test.
===================================================
[1] Dismiss (close) the the "automated troubleshooter" Fix It pop-up that appears when you first open the webpage then run Fix It 50202 (in DEFAULT and then AGGRESSIVE modes) instead.
If need be, you can right-click on the Fix It 50202 button & SAVE the download
to your desktop, then run it manually (in DEFAULT and then AGGRESSIVE modes).
[2] Full Disclosure: Running the Fix It in AGGRESSIVE mode will delete your Update History but not the list of Installed Updates.

Don't Download Malware

Where are you getting the download?

There are malicious people who download valid copies of a popular download, modify the file with malicious software, and then upload the file with the same name. Make sure you are downloading from the developer's web page or a reputable company.


Cancel or deny any automatic download

Some sites may automatically try start a download or give the appearance that something needs to be installed or updated before the site or video can be seen. Never accept or install anything from any site unless you know what is downloading.

Avoid advertisements on download pages

To help make money and pay for the bandwidth costs of supplying free the software, the final download page may have ads. Watch out for anything that looks like advertisements on the download page. Many advertisers try to trick viewers into clicking an ad with phrases like "Download Now", "Start Download", or "Continue" and that ad may open a separate download.

Another Safe way to Fix the Problem: After a Windows Update (XP) my dial-up internet connection hangs up:

How to Fix After a Windows Update (XP) my dial-up internet connection hangs up with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Run it, and it will scan your computer. The junk files will be shown in the list.

2. After the scan is finished, 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 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: [Solved] Adobe PDF Printer,Adobe Flashplayer [Solved],[Solved] Adobe Flash Player Installer constantly wants to make changes,Troubleshooting:After every login I get \" You must restart your computer to apply these changes\" Error,adding an email address How do I add that live.com address to outlook,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

Troubleshoot:After installing a second WD 1TB My Book drive, Windows Explorer does not see the new drive.

After installing a second WD 1TB My Book drive, Windows Explorer does not see the new drive.

Original Title: Signature Collision?
I am having difficulty installing a second external drive.
I'm using Windows 7 Ultimate RC.
There was one WD 1TB My Book drive already installed - healthy and functioning fine.
The problem occured after installing a second WD 1TB My Book drive.
I followed
all instructions, pluuging the drive into a USB Hub.
Windows discovered the drive, installed the drivers and reported the new drive ready for use.

Windows Explorer does not see the new drive.
Devices and Printers shows 2 external WD drives.
Disk managemant also shows 2 drives but the second drive is offline because of a "Signature Collision".

Each drive works fine if it is the only drive plugged in.
"Eject My Book" does not work because a program (or more) is using the drive in the background (Windows or Norton).

I've installed the latest firmware and am still having this problem.
I've been emailing WD with this problem and they have run out of ideas.

Can anyone help?
Thanks
Comatose13

Solutions to the Problem After installing a second WD 1TB My Book drive, Windows Explorer does not see the new drive.

Download SmartPCFixer for Free Now

This is horrible advise unless you know the drive is empty.  Use the Windows Diskpart command.  Select the Offline Disk.  Enter the command Online Disk.  Diskpart is much more powerful than the Disk Management.  I had this problem and Diskpart brought the
drive online with NO issues where Disk Manager continued reporting a Signature Collision.
Sorry to sound harsh but to format the disk?  I would think removing the disk and doing an Import Foreign Media would probably work allowing you to then place the disk bakc into the original computer.  If you still get Signature Collision...use the above
it works fine.
My Signature collision was cause by Acronis Disk Suite...HORRIBLE software if you have Windows 7....have had noting but problems...seems any disk it touches corrupts the MBR and Signaure area.
I had this exact same problem and I used this answer to help me.
In my case I left a second hard disk inside my drive when I rebuilt my primary disk with Windows 7.
The second drive wouldn't be seen in Windows Explorer, Disk Management showed me the disk
was present but "Offline due to Signature Collision" - there wasn't an option to make the disk go online via right click either.
I took the second disk to work, put it into a caddy and moved all the information off of it and then ran a full format.
Came back home and plugged it in but no joy.
I couldn't right click and make the disk go "online" again through Disk Management as before.
I ran across this answer through google and as a thank you will write up the process.
If you have the same problem of Signature Collision try to go to "Manage Computer" and then "Disk Management", find your drive and then right click to make it go "online".
If it wont work then go to a command prompt and type the following in " ", hit return
to move through:
 
"Disk Part"

(this brings up a separate window in Win 7)
"List Disk"
(This will show you which disks can by physically seen, offline and online)
"select disk X"
(Where x is the number of the disk you want to make online)
"online disk"
(This should bring you a message saying your disk is now online)
"Exit"
This takes you back to windows and you should now see your disk through Windows Explorer.
Thanks for the start KevinEBrown!!
 
 
phil

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.

Recommended Method to Repair the Problem: After installing a second WD 1TB My Book drive, Windows Explorer does not see the new drive.:

How to Fix After installing a second WD 1TB My Book drive, Windows Explorer does not see the new drive. with SmartPCFixer?

1. Download SmartPCFixer . Install it on your system.  Click Scan, and it will perform a scan for your computer. The errors 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 fixed. 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: After I installed service pack 1 for windows 7, I lost a dll file Tech Support,Solution to Error: Adding one Style to Toolbar,Adding the \"move window\" function in the the Task Bar [Solved],Adding different headers and footers in Microsoft word [Solved],Tech Support: Adobe Acrobat 8.2x crashes,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 two formula's together in one cell?

Adding two formula's together in one cell?

I'm now working on a separate work book for our ebay sales, and in one of the cells that outputs the insertion fee is the following:  (Be gentle with me lol, if I've done this the wrong way or it's over winded and could have been done simpler :)  Any way
it pulls the insertion fee's from another sheet so that if at a later date they put them up I can just start a new workbook and alter the fee's in that one sheet, but the problem is we sometimes list the same item in two categories so in theory our insertion
fee is doubled, so to get around this I have added another column , so now have:  one column with Category One
P10, and column two with Category Two R10,  in cell Z10 is the total insertion fee.
 But at the moment it just shows the fee's for Category One
P10  how can I also use the same formula but just add them together?


=IF(AND(N10="Auction",P10="All Categories",T10>=0.01,T10<=0.99),'_Settings'!$M$8,IF(AND(N10="Auction",P10="All Categories",T10>=1,T10<=4.99),'_Settings'!$M$9,IF(AND(N10="Auction",P10="All Categories",T10>=5,T10<=14.99),'_Settings'!$M$10,IF(AND(N10="Auction",P10="All
Categories",T10>=15,T10<=29.99),'_Settings'!$M$11,IF(AND(N10="Auction",P10="All Categories",T10>=30,T10<=99.99),'_Settings'!$M$12,IF(AND(N10="Auction",P10="All Categories",T10>=10),'_Settings'!$M$13,IF(AND(N10="Auction",P10="Media Related",T10>=0.01,T10<=0.99),'_Settings'!$M$15,IF(AND(N10="Auction",P10="Media
Related",T10>=1),'_Settings'!$M$16,IF(AND(N10="Buy It Now",P10="All Categories"),'_Settings'!$AC$10,IF(AND(N10="Buy It Now",P10="Media Related"),'_Settings'!$AC$11,""))))))))))


Many many thanks in advance for any help, I'm very grateful.
Linda

PS the work book is so that I can see what fee's we are paying and our profit after fees, and so adjust accordingly.

Solutions to the Problem Adding two formula's together in one cell?

Download SmartPCFixer to Fix It (Free)

Linda wrote:
Cheers Joe,  here's the link
http://www.lindaoraya.talktalk.net/eBay Sales WorkBook.zip

Thank you Joe, still haven't got to bed as yet.
 Daughter is ill so, looks like it's going to be a long night :(

Hope you and your daughter managed to get some sleep.

In the meantime, I had a chance to review your past explanations and look at your uploaded file.  I realized that I had misunderstood some of the intended design, mostly due to my ignorance of eBay.

I have uploaded a file with some changes (click here).  That file is an Excel 2003 file.

The primary change is in column Z.  The formula is a correction to my previous efforts, to wit:

=IF(OR(N10="",AND(P10="",R10=""),T10=""), "",
IF(N10="Buy It Now",
IF(P10="",0,IF(P10="All Categories",_Settings!$AC$10,_Settings!$AC$11))
+IF(R10="",0,IF(R10="All Categories",_Settings!$AC$10,_Settings!$AC$11)),
IF(P10="",0,IF(P10="Media Related",
IF(T10<1,_Settings!$M$15,_Settings!$M$16),VLOOKUP(T10,_Settings!$G$8:$M$13,7)))
+IF(R10="",0,IF(R10="Media Related",
IF(T10<1,_Settings!$M$15,_Settings!$M$16),VLOOKUP(T10,_Settings!$G$8:$M$13,7)))))

A significant change is:  you do not need the table I suggested in X1:Y6.  Your existing table in _Settings!$G$8:$M$13 will suffice.

I suspect that the values in P10 and R10 are mutually exclusive if both are specified.  That is, if P10 is "All Categories", I suspect that R10 is "Media Related" or empty; and vice versa.  I also suspect that P10 will never be empty when R10 is non-empty. 
That is, you always use Category 1 first and only optionally also use Category 2.

Those observations might lead to some simplification of the formula.  But I suspect only minor simplifications; for example, we probably do not need ``IF(P10="",0``.  But we still need ``IF(R10="",0``.

If you confirm the observations above, I could look to see how much we can simplify the formula, if you wish.  But I think it works well as is, and I suspect it is not overly complicated.

Note that I also made a number of other minor improvements in some unrelated formulas.

1.
I simplified the SUM formulas in C4 and G4.  Note that SUM can have at least as many as 30 parameters (XL2003 limit).  XL2007 might permit more.  I don't know.

2.
I simplified the IF formulas in columns AP, AR and AZ.  Let me know if you have any questions.  In general, it is not necessary to test both of two complementary conditions.  The change in column AZ also includes an arithmetic simplification.

3.
I changed the lower limits in G8 and G15 in the _Settings worksheet from 0.01 to 0.00.  That also required a format change for 0 values (3rd field).  Although column T in the "eBay Sales" worksheet might never be zero, it is better to have 0.00 in the lookup
table for technical reasons.  "Defensive programming".  Nevertheless, if you insist on 0.01, it
probably will work that way.

Hope that helps.

[EDIT] PS:  I forgot to mention a change that I did
not make.  I noticed some content in T1011:U1017 in the "eBay Sales" worksheet.  I'm not sure what they are doing there; I did not find any formulas dependent on that data.  I suspect it should be removed.

Run CHKDSK to Fix Adding two formula's together in one cell?

  • 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.
NOTE: You might receive an error message that states:

"Access denied as you do not have significant privileges. You have to invoke this utility in elevated mode."

If you receive the above error message, it means you are not logged into you computer as an Administrator. If that's the case, follow these steps to run the command prompt in elevated mode:

  • Go to theStart button.
  • Go to "All Programs > Accessories" and right click on "Command Prompt".
  • Select "Run as Administrator".
  • 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.

Recommended Method to Repair the Problem: Adding two formula's together in one cell?:

How to Fix Adding two formula's together in one cell? with SmartPCFixer?

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

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 done, 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 missing individual files. [Anwsered],[Solved] Adobe Flash Player Installer constantly wants to make changes,Troubleshooting:Aero Glitch (quite unusual) Error,Fast Solution to Problem: adobe wont let me download a book from library for kobo ereader,Troubleshoot:after disc check get message windows installer corrupted and error messages come up Error,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

[Solved] After IE 9 download - I cannot access a favorite web site

After IE 9 download - I cannot access a favorite web site

After I downloaded Explorer 9 - there is one web site that I cannot access.
I have a subscription to this site.
The web site pops up for about 5 seconds and then goes to an error message.
res://ieframe.dll/acr_error.htm#nytimes.com,http://www.nytimes.com/pages/crosswords/index.html?ocid=1&incamp=xwords:section_front
Can you help?

Solutions to the Problem After IE 9 download - I cannot access a favorite web site

Download SmartPCFixer to Fix It (Free)

Make Sure that your System Meets the System Requirements

Microsoft Windows Requirements :

  • 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
  • 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
  • 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your PC hardware is not up to par, then make sure you update where necessary before continuing.

Recommended Method to Fix the Problem: After IE 9 download - I cannot access a favorite web site:

How to Fix After IE 9 download - I cannot access a favorite web site with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  Open it, and it will scan your computer. The junk files will be shown in the list.

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

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: Adobe Shockwave and Flash Player Upgrades [Anwsered],advent awp10 all in one printer [Anwsered],Troubleshooter of Error: Adobe Reader Error Message: Adober Reader already installed,adding an email address How do I add that live.com address to outlook,Troubleshoot:Aero Snap cannot be used for viewing two Microsoft excel files. Error,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

[Solved] Address a problem with your WLAN card__Your WLAN card has stopped working properly.____To find out if an updated version of your WLAN card is available, contact your device or computer manufacturer.__ __

Address a problem with your WLAN card__Your WLAN card has stopped working properly.____To find out if an updated version of your WLAN card is available, contact your device or computer manufacturer.__ __

Address a problem with your WLAN card
Your WLAN card has stopped working properly.
To find out if an updated version of your WLAN card is available

Keys to the Problem Address a problem with your WLAN card__Your WLAN card has stopped working properly.____To find out if an updated version of your WLAN card is available, contact your device or computer manufacturer.__ __

Download Error Fixer for Free Now

Hello Erlene Ratz,


You should visit your computer manufacturer's website to download any and all updates for your hardware.
Never let the windows update utility, update your hardware to your computer.
Hope this helps you.
Let us know either way.
Make it a great day!




"And In The End The Love You Take, Is Equal To The Love You Make" (The Beatles last song from thier last album, Abbey Road.)

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.
An error might pop up:

"Access denied as you do not have significant privileges. You have to invoke this utility in elevated mode."

If you receive the above error message, it means you are not logged into you computer as an Administrator. If that's the case, follow these steps to run the command prompt in elevated mode:

  • Go to theStart button.
  • Go to "All Programs > Accessories" and right click on "Command Prompt".
  • Select "Run as Administrator".
  • 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: Address a problem with your WLAN card__Your WLAN card has stopped working properly.____To find out if an updated version of your WLAN card is available, contact your device or computer manufacturer.__ __:

How to Fix Address a problem with your WLAN card__Your WLAN card has stopped working properly.____To find out if an updated version of your WLAN card is available, contact your device or computer manufacturer.__ __ with SmartPCFixer?

1. Download Error Fixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The errors will be shown in the list.

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: Troubleshoot:After doing a restore, I lost my Favorites List Error,Solution to Problem: Aero Issue After Install,Troubleshoot:After i made the Disk Defragmenter at C i lost my wireless setting and files for my windows,[Solution] Adding New Heading Levels,[Anwsered] Aero Peek stopped working?,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

Adobe Reader 9 Tech Support

Adobe Reader 9

I tried logging onto a web site which asked me to download adobe reader 9, which I did.  Now when I go back to the site it still asks me to download adobe reader 9.  Can someone help me with this.

Keys to the Problem Adobe Reader 9

Download SmartPCFixer to Fix It (Free)

Adobe - Security Bulletins: APSB10-09 - Security update available for Adobe Reader and Acrobat (13 Apr-10) 
http://www.adobe.com/support/security/bulletins/apsb10-09.html
Troubleshoot Adobe Reader installation for Windows
http://kb2.adobe.com/cps/403/kb403923.html
Adobe Reader Support Forum
http://forums.adobe.com/community/adobe_reader_forums/adobe_reader

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

To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.

Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.

Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.

Recommended Method to Fix the Problem: Adobe Reader 9:

How to Fix Adobe Reader 9 with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will scan 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 fixed. 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.


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: advent awp10 all in one printer [Anwsered],How to Fix Problem - After installing 2 sticks of RAM, my wireless adapter is no longer working, and it shows a code 10 in the device manager.?,Fast Solution to Error: Adobe flash player constantly asked to be installed,Troubleshooting:ADOBE AIR installed able to download PDF DOCs.After installing ADOBE ACROBAT 7 Professional unable to download PDF DOCs from INET. Error,Solution to Error: Advanced Conditional Sum help for Excel 2007,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 You Fix - After installation of win 7 backup will not work. "The backup application could not start due to an internal error: The specified service does not exist as an installed service. (0x80070424).?

After installation of win 7 backup will not work. "The backup application could not start due to an internal error: The specified service does not exist as an installed service. (0x80070424).

Error has occurred on two different computers.

Anwsers to the Problem After installation of win 7 backup will not work. "The backup application could not start due to an internal error: The specified service does not exist as an installed service. (0x80070424).

Download Error Fixer (Free)

Hello Rytail,

Thank you for visiting the Microsoft Answers Community.

I have found another thread with the same issue.

Windows 7 Backup error

Hope this helps

Chris.H
Microsoft Answers Support Engineer
Visit our
Microsoft Answers Feedback Forum and let us know what you think.

Windows Error Reporting - To Fix After installation of win 7 backup will not work. "The backup application could not start due to an internal error: The specified service does not exist as an installed service. (0x80070424).

  1. Go to Start button.
  2. Open Control Panel.
  3. Go to Windows Error Reporting.
  4. Click on System and Maintenance, then click Problem Reports and Solutions.
  5. Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
  6. Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.
  7. Next, click the Advanced settings link.
  8. Select Off to turn off Error Reporting.

Recommended Method to Fix the Problem: After installation of win 7 backup will not work. "The backup application could not start due to an internal error: The specified service does not exist as an installed service. (0x80070424).:

How to Fix After installation of win 7 backup will not work. "The backup application could not start due to an internal error: The specified service does not exist as an installed service. (0x80070424). with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will scan your computer. The errors 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 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: [Solved] After awakening from sleep and hung on an manual update to Avast, Task Manager and Resource Monitor(RM) disk activity is at 100%, CPU is at 1 or 2% & memory at about 12%.,Fast Solution to Error: After Boot Desktop ICONS flash white then resume back to image????,Solution to Error: Adobe Reader X doesn't seem to be compatible,How Can You Fix - After clicking on \"Show windows stacked\" and \"Show windows side by side\" every time I open a new link it is either stacked or side by side.?,Tech Support: Adding ram -> boot hangs on classpnp.sys,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