Wednesday, July 6, 2016

Audio playback on ITunes [Solved]

Audio playback on ITunes

When trying to listen to ITunes I have no sound and the progress bar does not move.
When starting ITunes it tells me to reconfigure audio, can anyone help?

Keys to the Problem Audio playback on ITunes

Download SmartPCFixer to Fix It (Free)

Hello,
 
1.
Which operating system is installed on the computer?
2.
Were there any changes (hardware or software) made to the computer prior to the issue?
 
Method 1: Perform steps from the article mentioned below and see if the issue persists.
http://support.apple.com/kb/TS1371?viewlocale=en_US
 
Method 2: If the issue still persists, you need to post the issue in Itunes support for better assistance.
https://discussions.apple.com/community/itunes/itunes_for_windows
 
Hope this information helps.

Running System Update Readiness Command

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve Audio playback on ITunes in Windows.

  1. Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
  2. Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
  3. Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
  4. Close the Command Prompt Window because we are done.

Reboot your Windows & see if error Audio playback on ITunes is still there.

Note: Your administrator's password might be needed.

Recommended Method to Fix the Problem: Audio playback on ITunes:

How to Fix Audio playback on ITunes with SmartPCFixer?

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

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 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: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: How to Fix - Backing up Windows 7 Computer onto Windows XP computer.?,How to Fix Error - Auto Run Module.bas on Excel, HOW??,How Can You Fix - Backup error codes. I had: 0x800703EE,now have: 0x8100002F?,How to Fix Error - AutoPlay Windows 7 64 bit?,Tech Support: Automatically hide entire Rows with zero Values,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

Troubleshooting:Automatic generate enrollment number in excel Error

Automatic generate enrollment number in excel

Respected solver,
I have an excel sheet on which I have three column as follows:-
    a                                           b                                         c                                  d
 name                           date of admission                      branch                        enroll.
no
 deepak anand                01-Jan-2011                          Kalka ji                   01/01/Jan/2011  (should be generated automatically) 
Swati                                 01-Jan-2011                         Kalkaji                     01/02/Jan/2011 (should be generated automatically) 
Karan                               30-Jan-2011                          Kalkaji                    01/03/Jan/2011 (should be generated automatically) 
Abhimanyu                       31-Jan-2011                         G.Puri                     02/01/Jan/2011 (should be generated automatically)
Manish                             01-Feb-2011                          Kalkaji                    01/01/Feb/2011 (should be generated automatically)
Shubham                         19-Feb-2011                         G.Puri                     02/01/Feb/2011 (should be generated automatically)
and so on.
Enroll code = branch code/number of student of particular month/Month of admission/year of admission
01 is branch code, i.e.
kalkaji is first branch, and G.puri is 02nd branch
Now, what i want that enrollment no should generate automatically, is there any VBA code , function or formula?
pls help
regards.
Ayushman

Solutions to the Problem Automatic generate enrollment number in excel

Download Error Fixer (Free)

Hi,
Your English is excellent, I can understand completely.
I produced this table
 

deepak anand
01-Jan-2011
Kalka
01/01/Jan2011

Swati
01-Jan-2011
Kalka
01/02/Jan2011

Karan
01-Jan-2011
Kalka
01/03/Jan2011

Abhimanyu
31-Jan-2011
G.Puri
02/01/Jan2011

Manish 
01-Feb-2011
Kalka
01/01/Feb2011

Shubham
19-Feb-2011
G.Puri
02/01/Feb2011

The formula which goes in the bold cell (D1) is
 
=VLOOKUP(C1,$Q$1:$R$10,2,FALSE)&"/"&TEXT(SUMPRODUCT((--(TEXT($B$1:B1,"mmyyyy")=TEXT(B1,"mmyyyy"))*($C$1:C1=C1))),"00")&"/"&TEXT(B1,"mmmyyyy")
 
Note the leading zero comes from the table in columns Q & R where column R is formatted as TEXT and a leading zero added.

Kalka
01

G.Puri
02

me
03

You
04

Him
05

Her
06

Make Sure that your Computer 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)

This error can be due to some configuration requirements for you system. If your computer hardware is not up to par, then make sure you upgrade where necessary before continuing.

Another Safe way to Repair the Problem: Automatic generate enrollment number in excel:

How to Fix Automatic generate enrollment number in excel with SmartPCFixer?

1. Download Error Fixer . 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. When the Fixing part is finished, your computer has been speeded up and the errors have been removed


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Tech Support: Automatic click on Windows 7 laptops,At start up on Word & Excel, the spell checker starts running and will not stop or cancel. I have to abort the program. Tech Support,How to Fix Problem - AutoPlay always on for external disk drives after PC starts - Windows 7?,How to Fix Problem - Autoplay not installing games?,Troubleshoot:Are there updates for flight sim 2002?,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

How to Resolve - ASCv4ExtMenu_64.dll is on my desktop and I cannot delete it without permission?

ASCv4ExtMenu_64.dll is on my desktop and I cannot delete it without permission

The above dll file is on my desktop and I cannot delete it.  The error message says I need permission to delete it.  I am the computer administrator.  How do I get permission to delete it?

Keys to the Problem ASCv4ExtMenu_64.dll is on my desktop and I cannot delete it without permission

Download SmartPCFixer to Fix It (Free)

Thank you for your reply.  From another source I got information about changing "permissions" and the problem was solved.  What I do not know is what changed the permissions from the default.  My Norton is supposed  to prevent spyware and/or viruses.

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: ASCv4ExtMenu_64.dll is on my desktop and I cannot delete it without permission:

How to Fix ASCv4ExtMenu_64.dll is on my desktop and I cannot delete it without permission with SmartPCFixer?

1. Download SmartPCFixer . Install it on your computer.  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 done, you can see the errors and problems which need to be fixed.

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


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Troubleshooting:Atheros AR9285 and Windows 7 not compatible,[Solution] Automatically update style?,How to Fix Problem - Back Button Doesnt Work in IE8?,How to Fix Error - Backup Error code 0x80070005?,How to Fix Problem - Babylon.com?,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

Troubleshoot:Automatically sorting a range in ascending or descending order

Automatically sorting a range in ascending or descending order

Hi, How can get excel to automatically sort a range i.e A1 - A100 in ascending or descending order ?

Keys to the Problem Automatically sorting a range in ascending or descending order

Download SmartPCFixer for Free Now

Have you tried...
• Select the range of cells to be sorted...including any adjacent cells that you want to sort with the sort column.
• Home.Sort...Select the type of sorting you want to do.
 
Does that help?

Running System Update Readiness Command

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve Automatically sorting a range in ascending or descending order in Windows.

  1. Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
  2. Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
  3. Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
  4. Close the Command Prompt Window because we are done.

Try and see if you still get the same error Automatically sorting a range in ascending or descending order in your Windows.

Note: You may be prompted to enter your administrator's password when you try to execute certain system tasks!

Recommended Method to Repair the Problem: Automatically sorting a range in ascending or descending order:

How to Fix Automatically sorting a range in ascending or descending order with SmartPCFixer?

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

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 fixed


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Troubleshoot:backup disk full. can i transfer data to sandisk memory stick,Solution to Error: Assign own symbol to a Macro (in Word 2010),Avast Internet Security 5.0.667 is not recoginzed on my Windows 7 computer [Anwsered],How to Fix Problem - Auto correct option?,Autocorrect entries in Word 2010 [Solved],application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

Attempting repairs [Solved]

Attempting repairs

I uninstalled a program but my internet then couldn't connect to any webpage through any browser.
I did a System Restore st this point and everything was fine afterwards.
Somehow, when i was not paying attention, my account logged itself off.
I tried to
log in, but it began to lag and I couldn't press anything on the screen, i.e.
everything froze.
I turned off the computer using the switch and turned it back on, resulting in it diagnosing my PC and now attempting repairs which i know are not needed as my
computer is only 3 days old.
What do?

Anwsers to the Problem Attempting repairs

Download Error Fixer (Free)

Manually editing the Windows registry to fix Error Attempting repairs

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.

  • 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: Attempting repairs:

How to Fix Attempting repairs 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 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 this software. Like dll downloading, junk file cleaning and print spooler error repair.


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Troubleshooting:backup to external drive Error,Troubleshoot:back up error code 0x80070424 Error,automatic update Windows 7 : has tried to install Windows security update (KB 2667402) and keeps giving me this error code : \"WindowsUpdate_8024200D\" \"WindowsUpdate_dt000\" Tech Support,Back button mostly unresponsive after viewing PDF file in browser window Tech Support,Solution to Error: Backup Dual boot Win7 + Win server 2008 r2,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

How to Fix - average column with blanks and zeros base on two criteria in another single column?

average column with blanks and zeros base on two criteria in another single column

Hi,
 
I have the following situation:
 
Column X contains the number of process days and can be blank, zero or a number. Column A contains various transaction types. I need to Average Column X when Column A is New or Renew, but also discard blanks and zeros in column X to get an accurate average. 
 
 
Col A            Col X
New             10
Renew           0
Canc              3
Renew           5
Reins                 (reins is blank)
 
I need my result to be 7.5 (10+5/2)
 
Also, if the calculation is 0/0 prevent the #DIV/0! by displaying 0 instead.
 
I tried this formula but it doesn't like the "'s around "<>"&0 and when I remove them, then it still doesn't work.
 
 =IFERROR(SUM(SUMIF(X2:X10000,A2:A10000,"NEW","RENEW)))/SUM(COUNTIF(X2:X10000,"<>"&0),A2:A10000,"NEW","RENEW)),0)
 
Any help is greatly appreciated!!

Solutions to the Problem average column with blanks and zeros base on two criteria in another single column

Download Error Fixer for Free Now

(I did not include all the categories in my sample)

This is never a good idea and only serves to confuse the issue.
Abandon everything I've offered up to this point and start over.

The new, expanded requirements cannot be most efficiently fulfilled with a single style of formula and in any event, the originally supplied formula is not suited for multiple groups of lookup criteria.

              

If you want to find the average for a single match in column A but greater than zero in column X then an AVERAGEIFS() is your best recourse.
The formula in AB4 is,

=AVERAGEIFS(X2:X20,X2:X20,">"&0,A2:A20,AA4)

However, if you want to average the matching entries in column A to two (or more) possibilities, you should move to an
array formula.
The formula in AB2 is,

=AVERAGE(IF(X2:X20>0,IF(ISNUMBER(MATCH(A2:A20,"New","Renew",0)),X2:X20)))

...
which requires Ctrl+Shift+Enter rather than just Enter.
The formula in AB3 is,

=AVERAGE(IF(X2:X20>0,IF(ISNUMBER(MATCH(A2:A20,"Canc","Reins",0)),X2:X20)))

...
which requires Ctrl+Shift+Enter rather than just Enter.

In this method we will try to Boot in Safe mode with Networking and see if the error still persists.

  • Search "MSCONFIG" and Open.
  • Click on Boot Tab
  • Tick Safe Boot in Boot Option
  • Select Network.
  • Click Apply and OK.
  • Reboot your System.

Recommended Method to Fix the Problem: average column with blanks and zeros base on two criteria in another single column:

How to Fix average column with blanks and zeros base on two criteria in another single column with SmartPCFixer?

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

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

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


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: [Solution] Atheros AR9485WB-EG shuts down,How to Fix Error - Averaging Percentages with the error #DIV\/0!?,Automatically divide cell by a number Tech Support,How to Fix - Bacckup- It says backup complete, but some files skipped. backing up on DVD\/R?,How to Fix Problem - ati catalyst control center?,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

Troubleshooting:Backup issues with a new Netbook and Windows 7 Starter Error

Backup issues with a new Netbook and Windows 7 Starter

I bought a Toshiba Netbook with Win 7 starter and an external CD/DVD reader/writer
I was able t6o make the recovery discs and a repair disc without issuse
I cannout make a system image or a backup from the Restore control panel.
Prior to attempting to make the discs I ran Protective software scan: (microsoft security Esentials, Spybot S&D and  Avira Antivirus) Only Spybot found something.  I cleaned the computer and rechecked to make sure it was clean.
Error messages: System Image: The progress bar says "verifying disc 1" then I get a pop up, "Windows has found an error.
The disc cannot be used" I have tried three different discs and get the same message each time.
The backup appears to be frozen at 51%.
Please help
Wheels8

Keys to the Problem Backup issues with a new Netbook and Windows 7 Starter

Download Error Fixer (Free)

Hi Wheels,
Put your computer in clean boot to check if the issue is caused by third party software.
How to troubleshoot a problem by performing a clean boot in Windows Vista
http://support.microsoft.com/kb/929135
After checking the issue, put the computer back to theNormal mode.
Uninstall or update the program which is causing the issue.
Bindu R-Microsoft Support

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

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

Another Safe way to Fix the Problem: Backup issues with a new Netbook and Windows 7 Starter:

How to Fix Backup issues with a new Netbook and Windows 7 Starter with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  Open it, and it will perform a scan for 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. When the Fixing part is finished, your computer has been speeded up and the errors have been removed


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Solution to Problem: Archiving email in Windows Mail,Authentication Certificate Missing when trying to connect to secure wireless network [Anwsered],Backup and Restore not working [Solved],Tech Support: Arrange Favorites,Troubleshoot:As far as I am concerned microsoft, ripped me off. Is there a way to fix the problem with my new lap top freezing up all the time? i have a new CORE i7 that has windows 8. Error,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

Troubleshooting:Autofit the row height when there are merged cells Error

Autofit the row height when there are merged cells

Hi, I understand that you can't autofit the row height when there are merged cells, but I found the code below that allows you to set up a worksheet change event for the cells in question, which are named "OrderNote".
This is great, but there's 1 tweak that I need and am hoping somebody can help me by inserting.  Due to the font/pitch I'm using, Excel figures each row's height should be 17 pixels, but I want it to be 20 pixels to match the rest of the tab.
Thank you in advance - I really appreciate it.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim MergeWidth As Single
Dim cM As Range
Dim AutoFitRng As Range
Dim CWidth As Double
Dim NewRowHt As Double
Dim str01 As String
str01 = "OrderNote"

  If Not Intersect(Target, Range(str01)) Is Nothing Then
    Application.ScreenUpdating = False
    On Error Resume Next
    Set AutoFitRng = Range(Range(str01).MergeArea.Address)

    With AutoFitRng
      .MergeCells = False
      CWidth = .Cells(1).ColumnWidth
      MergeWidth = 0
      For Each cM In AutoFitRng
          cM.WrapText = True
          MergeWidth = cM.ColumnWidth + MergeWidth
      Next
      'small adjustment to temporary width
      MergeWidth = MergeWidth + AutoFitRng.Cells.Count * 0.66
      .Cells(1).ColumnWidth = MergeWidth
      .EntireRow.AutoFit
      NewRowHt = .RowHeight
      .Cells(1).ColumnWidth = CWidth
      .MergeCells = True
      .RowHeight = NewRowHt
    End With
    Application.ScreenUpdating = True
  End If

End Sub

Anwsers to the Problem Autofit the row height when there are merged cells

Download Error Fixer (Free)

  1. Access the files on your computer via MY COMPUTER
  2. Under the C: drive, access the WINDOWS folder
  3. Select the SOFTWARE DISTRIBUTION folder, followed by the DOWNLOAD folder.
  4. Delete any files within this download folder.
  5. If you are unable to delete these files, open the command prompt (CMD) as the administrator, and type "net stop wuauserv" into the CMD prompt window. Press ENTER. This should allow you to delete the files from step 4.
  6. Once the files are deleted, open and run the CMD as the administrator and type "wuauclt.exe /updatenow". Press ENTER.

Another Safe way to Fix the Problem: Autofit the row height when there are merged cells:

How to Fix Autofit the row height when there are merged cells 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 done, the speed of your computer will be much higher than before and the errors have been removed.


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: [Solution] At the start computer ask \"Strike F1 key to start of F2 for system setup.,How Can I Fix - Avery label 5202 Printing Problem?,How to Fix Problem - Backing up Windows Mail .eml files?,How to Fix - automaticaally loosing the usb modem connection?,Solution to Error: Auto copy from cell to text box,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

Fast Solution to Error: auto sort after adding entry

auto sort after adding entry

I created excel file (columns A:O) with my annual expenses.  I would like to sort this file by column B, then column A in descending order every time I make entry to existing worksheet. 
I don’t like to use/create macro, I would prefer that every time I make entry column B (total amount) will be sorted automatically.
 
Thanks

Solutions to the Problem auto sort after adding entry

Download Error Fixer (Free)

I created excel file (columns A:O) with my annual expenses.  I would like to sort this file by column B, then column A in descending order every time I make entry to existing worksheet. 
I don’t like to use/create macro, I would prefer that every time I make entry column B (total amount) will be sorted automatically.
 
Thanks
Hello,

I suggest to have a look here:
http://sulprobil.com/html/sorting.html

Regards,
Bernd

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.

Recommended Method to Fix the Problem: auto sort after adding entry:

How to Fix auto sort after adding entry with SmartPCFixer?

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


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Troubleshoot:Auto increment of numbers depending on prefix Error,Troubleshooting:autofill when typing in a listbox,Back up set up with Windows 7 \"The system cannot find the file specified (0x80070002) [Anwsered],Solution to Problem: Automate a VBA Code,How to Fix Problem - Autoplay dialog box not working; flashes up and disappears?,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?