2016年7月6日星期三

Fast Solution to Error: as soon as i start my computer normally, it says "please wait" and it stays on that screen and does not change. i went to safe mode and system restore and it brings it back to normal but after a while it does the please wait again....what can i do???

as soon as i start my computer normally, it says "please wait" and it stays on that screen and does not change. i went to safe mode and system restore and it brings it back to normal but after a while it does the please wait again....what can i do???

my computer will not start normally it says please wait and that screen does not change.

Solutions to the Problem as soon as i start my computer normally, it says "please wait" and it stays on that screen and does not change. i went to safe mode and system restore and it brings it back to normal but after a while it does the please wait again....what can i do???

Download SmartPCFixer for Free Now

Hi raptorsvt79,

Welcome to Windows Vista Answers Forums!


Method 1: First  you may try to run a clean boot and verify if any of the services or startup items is causing this issue.
To perform a clean boot we will have to run System Configuration Utility.
To perform Clean boot and check if it works, follow the steps below and refer the following link:
http://support.microsoft.com/kb/939671   
To perform a clean boot on a computer that is running Windows Vista:
1.
Click Start, type msconfig in the Start Search box, and then press
ENTER.
If you are prompted for an administrator password or for a confirmation, type the password, or click Continue.
2.
On the General tab, click Selective Startup.
3.
Under Selective Startup, click to clear the Load Startup Items check box.
4.
Click the Services tab, click to select the
Hide All Microsoft Services check box, and then click Disable All.
5.
Click Apply and OK.
6.
When you are prompted, click Restart.
7.
After the computer starts verify if you are getting the same issue.
If your issue is resolved after performing Clean Boot, then follow the steps mentioned in the following KB article to narrow down the exact source:
http://support.microsoft.com/kb/929135
Also, see the section on how return your computer to a Normal startup mode by following the steps under “Reset the computer to start as usual”.
Method 2: You can try to run a System File checker tool.
This tool will fix the system files if they are corrupted.

Steps to perform SFC scan:

1.
Click the Start button

2.
From the Start Menu, Click All programs followed by Accessories

3.
In the Accessories menu, Right Click on the Command Prompt option

4.
From the drop down menu that appears, Click on the 'Run as administrator' option

5.
If you have the User Account Control (UAC) enabled, you will be asked for authorization prior to the command prompt opening.
You may simply need to press the Continue button if you are the administrator or insert the administrator password etc.

6.
In the Command Prompt window, type: sfc /scannow and then press Enter

7.
A message will appear stating that 'The system scan will begin'

8.
Be patient because the scan may take some time

9.
If any files require replacing SFC will replace them.
You may be asked to insert your Vista DVD for this process to continue

10.
If everything is okay you should, after the scan, see the following message "Windows resource protection did not find any integrity violations"

11.
After the scan has completed, close the command prompt window, restart the computer and check.

You may also disable the Security software and check whether the issue persists.

Hope this information is helpful.
Praseetha K
Microsoft Answers Support Engineer
Visit our
Microsoft Answers Feedback Forum and let us know what you think.

To check for Windows updates

  1. Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
  2. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
  3. If any updates are found, click Install updates. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

Another Safe way to Repair the Problem: as soon as i start my computer normally, it says "please wait" and it stays on that screen and does not change. i went to safe mode and system restore and it brings it back to normal but after a while it does the please wait again....what can i do???:

How to Fix as soon as i start my computer normally, it says "please wait" and it stays on that screen and does not change. i went to safe mode and system restore and it brings it back to normal but after a while it does the please wait again....what can i do??? 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 scan result.

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

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating 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: Solution to Error: Autorun.inf file is missing from registry,Troubleshoot:avoid zero in chart data label for nonvalue cells Error,Automatically hide rows in Excel based on value per row Tech Support,Troubleshoot:Autoplay won't open when nonformatted cd is inserted.,Troubleshooting:Apps in the start screen like mail, skype and downloaded games open for a second or 2 then crash, including store.,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?

[Anwsered] Auto insert of correct spelling

Auto insert of correct spelling

With my old Office 2003 (Window 2003), when I write "September" for example, it gave me correct spelling before I completed typing.  This came automatically (without my doing anyting).  With my new Word 2007, it did not.  How do I set this up?  I like
this function because it saves me time.

Keys to the Problem Auto insert of correct spelling

Download SmartPCFixer for Free Now

I believe you are talking about Word 2003's AutoComplete feature.
AutoComplete was dropped from Word 2007, but there are two vialble alternatives: AutoCorrect and AutoText.
With AutoCorrect, you can type sxpt and have it immediately converted toSeptember.
Each custom entry needs to be manually added.
For longer phrases that are routinely used, set up some AutoText entries, Give your AutoText entries short names, type them, then press F3.

If this proposed solution has resolved your issue(s), please return and mark it as Answered for others to consider.

Manually editing the Windows registry to fix Error Auto insert of correct spelling

Caution: Unless you an advanced computer 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.

Recommended Method to Repair the Problem: Auto insert of correct spelling:

How to Fix Auto insert of correct spelling with SmartPCFixer?

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

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

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,Troubleshooter of Error: Auto Scrolling in Windows 7 - How do you stop it??,[Solution] association in default programs control panel,Tech Support: Arrange Favorites,[Solution] Backup & Restore \/ Backup Now, Manage Space, Change Settings, Turn On Schedule - NOT Responding,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?

[Solution] Are there benefits to having a registry repair program; if so, is there one that is not associiated with a scam, is efficient, etc.?

Are there benefits to having a registry repair program; if so, is there one that is not associiated with a scam, is efficient, etc.?

Any benefits to purchasing a registry cleaner program?  If so, which one is efficient and not scam related?

Anwsers to the Problem Are there benefits to having a registry repair program; if so, is there one that is not associiated with a scam, is efficient, etc.?

Download Error Fixer (Free)

Any benefits to purchasing a registry cleaner program?

IMHO, registry cleaners/boosters are snake oil.
I've never seen one create a measurable benefit but I've seen lots of them make systems inoperable.

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

Recommended Method to Repair the Problem: Are there benefits to having a registry repair program; if so, is there one that is not associiated with a scam, is efficient, etc.?:

How to Fix Are there benefits to having a registry repair program; if so, is there one that is not associiated with a scam, is efficient, etc.? 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 fixed.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating 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 Problem - Autoplay does not pop-up with USB camera SDHC memory card?,Fast Solution to Problem: As of April 13 security updates (Win7) I keep getting error with Quickbooks 2011. Won't run only runs under switching user? Problem signature:,[Solved] Attempting to unistall a program and recieve a message, \" Windons Installer could not be accessed.,Audio not working after Windows 8.1 Upgrade Tech Support,How to Fix Error - Automatically move varying number cells up to same row as non blank cell in column A?,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:ATC voices in Flight Sim X running Windows 7 Error

ATC voices in Flight Sim X running Windows 7

I purchased Flight Sim X Gold Edition for a new computer running Windows 7.  Everything works fine except the voices of ATC and the pilot.
I hear the intro music and engine sounds.  Also the voice of the person in the missions is also missing.
All the
settings appear to be correct within Flight Sim.
What should I be changing to get the voices to speak to me?

Solutions to the Problem ATC voices in Flight Sim X running Windows 7

Download Error Fixer for Free Now

Hi Leonard Friedman,
 
Refer the following links:
Troubleshoot sound-related problems with Microsoft games or mapping programs
http://support.microsoft.com/kb/812394
Note: Refer How to return Windows to a normal startup mode
from the Kb article 331796 mentioned in the above link.
 
Articles About Combat Flight Simulator
http://support.microsoft.com/combatflightsimfaq
 
If you are still facing the issue with Filght simulator, you may have to
contact Flight simulator support for further assistance
http://www.microsoft.com/Products/Games/FSInsider/tips/Pages/default.aspx

Hope this information helps.

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

Another Safe way to Fix the Problem: ATC voices in Flight Sim X running Windows 7:

How to Fix ATC voices in Flight Sim X running Windows 7 with SmartPCFixer?

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

2. After the scan is 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: 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: [Solved] Automatic highlighting when selecting a range of cells.,Fast Solution to Error: Backup to network drive silently stops after password change,How Can I Fix - assign application program to extension?,Fast Solution to Error: Auto-correction default font troubles,Fast Solution to Error: Auto Complete will not work in Yahoo Mail\/Windows 7.,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 Problem: Average in one column values based on selected values in another column.

Average in one column values based on selected values in another column.

How do I create the following in EXCEL?
  Average a2:a200 where c2:c200 is between 600 and 1000.

Keys to the Problem Average in one column values based on selected values in another column.

Download Error Fixer (Free)

Excel 2007 has a new function AVERAGEIFS that you can use for this:
 
=AVERAGEIFS(A2:A200, C2:C200, ">=600", C2:C200, "<=1000")

Boot in Safe Mode:

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

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

Another Safe way to Fix the Problem: Average in one column values based on selected values in another column.:

How to Fix Average in one column values based on selected values in another column. with SmartPCFixer?

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

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

3. 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 to Error: Assist me in getting a code,Troubleshooter of Error: Backup and Restore Manage Space will not connect,Fast Solution to Problem: Ayuda urgente ! \"Ningun dispositivo de salida de audio instalado\",Troubleshoot:Auto-export of graph slopes?,Fast Solution to Error: Automatically create a new worksheet same as an existing worksheet, when new name is inserted on other worksheet,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?

[Solved] Assessment and Deployment Kit

Assessment and Deployment Kit

I have Assessment and Deployment Kit on my Windows 7 Home Premium 64.
I am trying to uninstall it but it just crashes right away saying it cant be accessed.
I also cant reinstall it because it says I must remove other Assess & Dep..
for Windows 8.1....
How do I get rid of this broken software that clearly isnt even FOR my OS? Thanks in advance.

Anwsers to the Problem Assessment and Deployment Kit

Download Error Fixer (Free)

Run CHKDSK

  • Go to the Start button.
  • In the Search box, type "cmd" (without quotes) and press Enter.
  • At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
  • 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.

Recommended Method to Repair the Problem: Assessment and Deployment Kit:

How to Fix Assessment and Deployment Kit 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: 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 - backup error code 0x8007007B?,[Solved] Average speed - on whose roads? Not safe for buses to use this?,Troubleshooter of Error: Backup to network drive asking for password,Solution to Error: Attach a file or picture to an e-mail crashes Internet Explorer,Authentication Certificate Missing when trying to connect to secure wireless network [Anwsered],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?

Avoid duplicate entries in a table [Solved]

Avoid duplicate entries in a table

We use a table to enter all of our A/P invoices.  Is there a way to avoid entering an invoice twice by searching the cells above for the duplicate number for that vendor?  The vendor's name is entered in one column, the invoice # is entered in a different
column
Thanks for any help!

Anwsers to the Problem Avoid duplicate entries in a table

Download SmartPCFixer to Fix It (Free)

You will need a macro to prevent any duplicates from being entered into your invoice table.
Assuming that invoice numbers are unique, i.e.
different vendors do not use the same numbers, try this macro:
Right click on the worksheet tab and select "View Code".
Enter the below macro in the top right window.
Private Sub Worksheet_Change(ByVal Target As Range)
  Set firstinvoice = Range("C2")
  If Not Intersect(Target, firstinvoice.EntireColumn) Is Nothing Then
    If Target.row > firstinvoice.row Then
      If WorksheetFunction.CountIf(firstinvoice.Resize(Target.row - firstinvoice.row), Target.Value) > 0 Then
        MsgBox "Invoice number " & Target.Value & " is already entered", vbOKOnly + vbCritical, "Invalid entry"
        Target.Value = ""
      End If
    End If
  End If
End Sub
Change the "C2" to the cell where your first invoice number is.
Hope this helps / Lars-Åke

How to Avoid Downloading 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.

Recommended Method to Fix the Problem: Avoid duplicate entries in a table:

How to Fix Avoid duplicate entries in a table with SmartPCFixer?

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

2. After the scan is finished, 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: 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: back up files converted to PBD,[Anwsered] Are there any plans to include Firewire support with XP Mode and Windows 7?,Fast Solution to Error: Azure Tools 1.2 for Visual Studio stability hotfix from connect.microsoft.com,Automate drawing a circle around cell [Anwsered],Troubleshoot:AutoComplete entries not displayed for Username field although values are present in registry.,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 - Autofill Sheets into a Summing Formula?

Autofill Sheets into a Summing Formula

I need a formula that will automatically go get (and add) the values from cell C3 of that sheet plus the next 3 sheets.  For example,
If use that formula on sheet1, it will automatically get the values from cell C3 of sheet1, sheet 2, sheet 3 and sheet 4, then add them up.
If I use the formual on sheet 2, it will automatically get the values from cell C3 of sheet 2, sheet 3, sheet4 and sheet 5, then add them up.
If I use the formula on sheet 12, it will automatically get the values from cell C3 of sheet12, sheet13, sheet14 and sheet 15.
NOTE:  My sheets all have different names, like Jan 4-8, Jan 11-15, Jan 18-22, Jan 25-29, Feb 1-5, etc.
And so on....

Solutions to the Problem Autofill Sheets into a Summing Formula

Download SmartPCFixer to Fix It (Free)

Use a custom function like this;
Function AddSheets(cell As Range, NoSheets As Long) As Double
Dim idxSht As Long
Dim i As Long
idxSht = ActiveSheet.Index
For i = 0 To NoSheets - 1
  AddSheets = AddSheets + Worksheets(idxSht + i).Range(cell.AddressLocal).Value
Next
End Function
To use it type this formula in a cell, where 4 is the number of sheets you wish to add including the current sheet, and C3 is the cell you wish to sum across sheets
=AddSheets(C3,4)

Ed Ferrero www.edferrero.com

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 Repair the Problem: Autofill Sheets into a Summing Formula:

How to Fix Autofill Sheets into a Summing Formula with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will perform a scan for your system. 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 Fixing part is finished, 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: [Anwsered] audio devices are \"disbled\" how can i fix this,Solution to Problem: ArcSoft PhotoStudio 5.5,[Solution] Array as the result of two calculations,Troubleshooter of Error: AUTOSUM Function summing only subtotal items - can it also sum non subtotal items,How Can I Fix - asp.net Session not valid when open new page using showModalDialog in IE, works fine with Firefox?,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?

Solution to Error: Asus g50vt-x5 windows 7 random disconnects from network, but connected?

Asus g50vt-x5 windows 7 random disconnects from network, but connected?

Ok so I have the Asus g50vt-x5 with windows 7 x64 ultimate edition installed with all the latest updates.
My adapter is a 5100 AGN.
I will be randomly browsing the internet (with comcast high speed internet) or playing a game perfectly and all of a sudden,
it will just stop receiving data.
Sometimes if I'm playing a video game, it will very quickly drop the connection and reconnect.
but my ping just skyrockets for that time im not getting internet (like 2000+).
And sometimes, it will just occasionaly get a delayed
lag (around 200 ping) for a few seconds.
Its VERY anoying.
What i can't figure out is that it doesn't necessarily disconnect (sometimes, it does completely connect and reconnect occasionally), it keeps the connection, stable and i'm getting full bars on the windows toolbar, I have firewall disabled.
I have AVG
anti virus as well as Spybot Search and Destroy antivirus programs running, I always do matinence on my computer.
Run CCleaner for registry errors, etc. 

Whats weird is that if i flip off my internet switch, then back on, then wait for awhile for the connection it will start working again.
This applies as well to hitting "disable" then re-enabling it in the device manager or just reinstalling device drivers,
only to come up again shortly later (can be as quick as 10 minutes, can be as long as like a few hours). 

Speaking of drivers, I originally had the Asus drivers from the webpage (supposed to be the latest) but when I started encountering this problem, I went to the Intel website, found the latest drivers for my adapter and installed them.
Still not fixing
the issue.
I'm stumped and quite frankely, pissed off.
What the **** microsoft! I got my computer all personalized with music, settings programs games and everything, the least thing i want to do is reinstall windows.
I dont want to, but maybe i should move
to a mac.

On a side note: i have tested this on 3 different routers, and 2 different connections (my step dad borrowed a different one to see if it would fix the issue).
The problem persists on all the routers (WEP and WA2-PSK).
And the wired connection works perfect.
Not a single disconnect on a corded connection.
Another here: http://hardforum.com/showthread.php?t=1512953 had the same problem, with the same laptop, but found no solution.
I'm begging you microsoft, save my life from pc hel l, cause quite frankly, i can't
take it anymore.

Anwsers to the Problem Asus g50vt-x5 windows 7 random disconnects from network, but connected?

Download Error Fixer for Free Now

Hi Aspen1135,
Since it happens with different routers, the problem is with his wireless card, driver, or interference with the wireless signal.
As you have updated the driver, check for any other electronics or appliances in the path of the wireless, if there is a clean path, the card is likely failing.
You may refer the following articles for more information:
Phone and Modem: setting up calling card information
http://windows.microsoft.com/en-US/windows7/Phone-and-Modem-setting-up-calling-card-information
How do I fix network adapter problems?
http://windows.microsoft.com/en-US/windows7/How-do-I-fix-network-adapter-problems
Why can’t I connect to a network?
http://windows.microsoft.com/en-US/windows7/Why-can-t-I-connect-to-a-network

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

  • Move the mouse cursor over to the upper right side of the screen.
  • A menu will pop up on the left. Click on the "Settings" feature on the menu.
  • On the Settings window, click on the "Change PC settings."
  • Now, left click on the "Update and recovery" feature.
  • For the next step, left click on the "Recovery" feature.
  • There is an option here saying "Refresh your PC without affecting your files." There, left click on the "Get started" button.
  • Now, follow the instructions on the screen to finish the Refresh process.
  • After the Refresh process has finished restart your Windows 8.1 or Windows 8 device.
  • Check again to see if the error Asus g50vt-x5 windows 7 random disconnects from network, but connected? has been fixed.

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

Another Safe way to Fix the Problem: Asus g50vt-x5 windows 7 random disconnects from network, but connected?:

How to Fix Asus g50vt-x5 windows 7 random disconnects from network, but connected? 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 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 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: Solution to Error: Auto Play prompt when system wakes from sleep,How to Fix Error - Automatic update failed and Windows will not start?,average of in a row range gives zero 0,Attempting to restore a single file from the first Backup made generates the error \"The system cannot find the path specified. (0x80070003),[Solution] Autofilter does not recognized entire column,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?