2016年3月31日星期四

[Solution] After a crash I cannot send mail using windows mail. It is not the server but a p[roblem with windows mail. Ican receive but not send

After a crash I cannot send mail using windows mail. It is not the server but a p[roblem with windows mail. Ican receive but not send

I can receive mail using Windows Mail but cannot send.
I have checked with the server and they determined it is aproblem with Microsoft Windows Mail.
This occured after my computer crashed and I was able to get everything back that was backed up but apparently
something is wrong with Windows mail

Solutions to the Problem After a crash I cannot send mail using windows mail. It is not the server but a p[roblem with windows mail. Ican receive but not send

Download Error Fixer for Free Now

I can receive mail using Windows Mail but cannot send.
I have checked with the server and they determined it is aproblem with Microsoft Windows Mail.
This occured after my computer crashed and I was able to get everything back that was backed up
but apparently something is wrong with Windows mail
When you try to use a Windows Live e-mail account or a different Web-based e-mail account in Windows Mail, you cannot send e-mail messages?
 
Windows Mail no longer supports the HTTP servers that are used by Hotmail and by other Web-based e-mail providers such as AOL mail, Google mail, and Yahoo! mail.
To resolve your problem, use Windows Live Mail instead of Windows Mail.
Windows Live Mail works with popular Web-based e-mail services such as Hotmail, AOL mail, Google mail, and Yahoo! mail.
Windows Live Mail is built to automatically configure many popular e-mail services.

Windows Mail also supports Post Office Protocol 3 (POP3), Internet Message Access Protocol (IMAP), and Simple Mail Transfer Protocol (SMTP) server types. 

Downloading an updated "Windows Live Mail " should solve your problem.

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 After a crash I cannot send mail using windows mail. It is not the server but a p[roblem with windows mail. Ican receive but not send 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 After a crash I cannot send mail using windows mail. It is not the server but a p[roblem with windows mail. Ican receive but not send 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: After a crash I cannot send mail using windows mail. It is not the server but a p[roblem with windows mail. Ican receive but not send:

How to Fix After a crash I cannot send mail using windows mail. It is not the server but a p[roblem with windows mail. Ican receive but not send with SmartPCFixer?

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

2. After the scan is finished, 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, 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: Troubleshooting:Adding new row labels fields in pivot table from new columns in named table range Error,How Can You Fix - After downloading Business-In-A-Box install updates and it states it is not compatible with Windows 7?,Solution to Error: Adding names to dropdown list already created (Excel),Adding a Graphic Pop-up in Word 2007 [Anwsered],Troubleshoot:after downloading sp3, pc caught in loop 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

[Solution] adobe flashplayer sound plays slower than the video

adobe flashplayer sound plays slower than the video

When I play online movies and video via Adobe Flash player (HTML5) the sound plays slower than the video.  I don't know if it's because some movies are older or I don't have enough memory online to play them.  My OS system is Windows 8.1, 64 bit and my
computer is DELL inspiron 2020.

Solutions to the Problem adobe flashplayer sound plays slower than the video

Download SmartPCFixer for Free Now

The issues might we with the Adobe flash player , Please check this link 
https://forums.adobe.com/thread/1031029?start=0&tstart=0
http://www.adobe.com/support/cslive/

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.

Recommended Method to Repair the Problem: adobe flashplayer sound plays slower than the video:

How to Fix adobe flashplayer sound plays slower than the video with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Run it, and it will scan 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 repaired. 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 fixed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Troubleshooting:Adobe Photoshop 5 LE compatiblity Error,Fast Solution to Problem: Adobe Lightroom 3.0 issues, updated Adobe and Dell Studio PC not working correctly.,Troubleshooting:Adobe Flash Player operating system error Error,Troubleshooter of Error: After a complete reboot an error box appears - 'Explorer.exe - Application Error' It reads: The instruction at 0x773ca669 referenced memory at 0xdd850ac0.,After installing Adobe flash player or reader, Internet Explorer 9 won't work. Tech Support,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

Troubleshooter of Error: Administrator profile will not load in Win 7 and all suggested repairs not working HELP!

Administrator profile will not load in Win 7 and all suggested repairs not working HELP!

The administrator profile will not load on a Windows 7 Home Premium computer.
 I have tried all of the suggested repairs.
 There is no 'back up administrative account' that I can see.
 When I do the suggested 'add one' method, it doesn't show.
 (at least
there is not an icon on the re-boot in safe mode.
 All other profiles will not load properly as well.
 
When I do go in under safe mode and navigate to the registry address I can see the administrator has a .bak and a duplicate file but of course since I am not under administrative privilages, I can't make any changes.

Oh, and my initial repair was a recovery to 4 weeks ago.
 Didn't make a difference.

I am pulling my hair out.
 I can see the problem but can't fix it.
 Very frustrating.

Help please.

Thanks so much, 

Marie

Solutions to the Problem Administrator profile will not load in Win 7 and all suggested repairs not working HELP!

Download Error Fixer (Free)

Hello Marie,
 
Thank you for the reply.
 
I understand that you have issues logging in to the Administrator account.
 
From which of these options did you run the command ,is that the advance boot options or command prompt in user account with admin mode?

And I would like to inform that, this command works only in admin mode of Command Prompt.
 
Also, the icon may not reappear.

 
However, we can try to boot to the safe mode and try to follow the steps.
1.
Click start.
 
2.
Type in the search box Command Prompt.
3.
To enable administrator account by typing in the following command.
net user administrator /active:yes
4.
Now you can exit the command prompt screen and boot to the normal mode.
5.
Now login to the account which is with a name"Administrator".

If the above doesn't help then, put the Windows 7 disk in and follow the steps mentioned below to enable the built in admin from Command prompt in WinRE.
 
1.
Press a key when the message indicating "Press any key to boot from CD or DVD …” Appears.
2.
Select a language, a time and currency, and a keyboard or input method, and then click next.
 
3.
Click Repair your computer.
4.
Click the operating system that you want to repair, and then clickNext.
5.
In the System Recovery Options dialog box, clickCommand Prompt.
6.
To enable administrator account by typing in the following command.
net user administrator /active:yes
7.
Now you can exit the command prompt screen and boot to the normal mode.
8.
Now login to the account which is with a name"Administrator".
Hope this helps.
Otherwise reply to this response and we will be happy to help you again.

Thank you

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.

Recommended Method to Fix the Problem: Administrator profile will not load in Win 7 and all suggested repairs not working HELP!:

How to Fix Administrator profile will not load in Win 7 and all suggested repairs not working HELP! with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Run 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 repaired. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up 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: [Anwsered] Add value of specifc cell in every worksheet in a folder - Office 2007,How to Fix - Adding duplicate value in registry?,Tech Support: Aero disappears after reboot,Adding two formula's together in one cell?,How to Resolve - After blue screens, Facebook and dhgate.com are only showing text?,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

Solution to Error: adobe flash player keeps flashing at the bottom of my screen

adobe flash player keeps flashing at the bottom of my screen

i can't close the "adobe flash player" icon that keeps flashing at the bottom of my computor screen...
seperate issue - at the bottom right - where it shows the time - i can't click on the date or get the calendar

Solutions to the Problem adobe flash player keeps flashing at the bottom of my screen

Download Error Fixer (Free)

Hi,
1.     Have you made any changes to your computer prior to this issue?
2.     Which Operating System is installed on your computer?
Which version of the Windows operating system am I running?
http://windows.microsoft.com/en-US/windows7/help/which-version-of-the-windows-operating-system-am-i-running
You may follow the suggestions and check.
Method 1
Step 1:
Check if the issue exists in safe mode..
Start your computer in safe mode
http://windows.microsoft.com/en-US/windows7/Start-your-computer-in-safe-mode
 
Step 2:
If the issue doesn’t persist in safe mode, I would suggest you perform clean boot to see if any third party services are causing this issue.
How to troubleshoot a problem by performing a clean boot in Windows Vista or in Windows 7
http://support.microsoft.com/kb/929135
Note : After troubleshooting follow Step 7: Reset the computer to start as usual
 
Method 2
You may uninstall and re-install the latest Adobe Flash Player from the manufacturer’s website.
Uninstall Flash Player | Windows
http://helpx.adobe.com/flash-player/kb/uninstall-flash-player-windows.html#main_Download_the_Adobe_Flash_Player_uninstaller
 
Install Adobe Flash Player
Adobe Flash Player 11.3.300.257
http://get.adobe.com/flashplayer/
 
Method 3
You may run a complete virus scan using Microsoft Safety Scanner.
Microsoft Safety Scanner
http://www.microsoft.com/security/scanner/en-au/default.aspx
Note: The Microsoft Safety Scanner expires 10 days after being downloaded.
To rerun a scan with the latest anti-malware definitions, download and run the Microsoft Safety Scanner again.
It also performs check disk and you may lose amount of data.

Check Windows System Requirements

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

Microsoft Windows Requirements :

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

Recommended Method to Fix the Problem: adobe flash player keeps flashing at the bottom of my screen:

How to Fix adobe flash player keeps flashing at the bottom of my screen with SmartPCFixer?

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

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


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 text from combobox to a table using append query [Solved],Tech Support: After a system restore and reboot to bypass malware, the icon tabs for my \"Favorites\" on the Favorites Bar have disappeared,Troubleshoot:after i get past andministrator's password, what do i do next?We'll search for answers Error,Troubleshooting:add or remove program,Adding a new line by means of a macro,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:Adding a macro to a Word form

Adding a macro to a Word form

I have created a form in Word 2007 and added a macro.
The form includes general instructions text (including the shortcut keys to run the macro that will delete the instruction text when the user has finished filling out the form), but when I add protection
to the form and press the shortcut keys I get an error run message. Is there any way around this or another way to be able to delete the instruction text when the user completes the form?

Solutions to the Problem Adding a macro to a Word form

Download SmartPCFixer for Free Now

Plain text can't be deleted (or added or modified or formatted...) while the document is
protected.
The way to do this is in three steps within the macro:
1.
Unprotect the document
2.
Make the change(s)
3.
Reprotect the document
 
In code,
 
    If ActiveDocument.ProtectionType <> wdNoProtection Then
        ActiveDocument.Unprotect  ' , Password:="MyPassword"
    End If
   
    ' make the change(s) here
   
    ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True
 
Jay Freedman
MS Word MVP  FAQ: http://word.mvps.org

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 update where necessary before continuing.

Another Safe way to Fix the Problem: Adding a macro to a Word form:

How to Fix Adding a macro to a Word form with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Run 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 fixed. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up 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: Adding text in a cell from a check box or list [Anwsered],How to Fix Error - Address fields mismatched after installing KB829918?,How Can I Fix - Address bar drop down menu has stopped dropping down, how do I fix this problem??,How to Fix - After every start on Windows 7, there appears on the desktop an annoying input string.?,[Anwsered] After I upgraded to Windows 7 I lost the ability to drag and drop between specific programs,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

Fast Solution to Error: Added memory +2 GB - still showing 2 GB available

Added memory +2 GB - still showing 2 GB available

Original Title : stuck
upgraded from 2gig to 4gig ram.
system shows 4gig installed, but only 2gig available, how do i get it to have all 4gig available

Anwsers to the Problem Added memory +2 GB - still showing 2 GB available

Download Error Fixer (Free)

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 Repair the Problem: Added memory +2 GB - still showing 2 GB available:

How to Fix Added memory +2 GB - still showing 2 GB available with SmartPCFixer?

1. Download SmartPCFixer. Install it on your system.

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

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: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: How to Fix - Adobe Audition 2.0 Windows 7 compatibility?,How to Fix Error - ADOBE AND ACROBAT?,adding an email address How do I add that live.com address to outlook,Solution to Error: Aero Snap does not work with mouse pointer, although keyboard shortcuts work fine.________,Troubleshooting:Adobe Flash Player operating system error 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

Troubleshooting:Adding & subtracting numbers in a series of cells Error

Adding & subtracting numbers in a series of cells

Here is what I'm trying to do.  I have a sub-total that I need to subtract a specified number entered, then add that to a series of additional numbers for the grand total.
(Hope I'm explaining it well enough)

For example:
A1 $100 (subtotal)
A2 -$10
A8 +$25
A10 +$50
A12 +$15
A20 =$180

Keys to the Problem Adding & subtracting numbers in a series of cells

Download SmartPCFixer for Free Now

Not really sure what you're after here...
Do you jsut need to type the following in cell A20:
=A1+A2+A8+A10+A12
or you could use:
=SUM(A1,A2,A8,A10,A12)
both do the same thing.
Assuming A2 does contain a negative number.  If A2 just contains 10, you'd need to use:
=A1-A2+A8+A10+A12
(note the minus sign between A1 and A2 in this formula).
Cheers
Rich

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: Adding & subtracting numbers in a series of cells:

How to Fix Adding & subtracting numbers in a series of cells 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 list.

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

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


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Troubleshoot:After downloading a Java update for Internet Explorer I am unable to access my favorite chat room online. Error,[Anwsered] Add value of specifc cell in every worksheet in a folder - Office 2007,Adobe Flash Player will not update/install [Solved],Fast Solution to Error: Adding unique records in Excel using class module, collections and 'key',Troubleshoot:Adobe Primiere Pro CC causes windows to crash,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

How to Fix Error - adding a new row when another row filled in another worksheet?

adding a new row when another row filled in another worksheet

I have two excel workbooks called "forecast" and "taeh".
In these workbooks I have several sheets in each. I want to write a macro code which enables this: whenever a new row filled in
one of the worksheets (say "summary") of "taeh" workbook, I want to add a new row after the row one before of the last filled row in the worksheet (say "banks") of "forecast" workbook.
I also want to copy the formula of row one before the new added row, to
the new added row. 

Could you help me on this?

Many thanks,
Good work,

Davut Elmastaş,
Turkey

Keys to the Problem adding a new row when another row filled in another worksheet

Download SmartPCFixer to Fix It (Free)

You do not have to change any of the code in the taeh.xls workbook -- but all workbooks like it that the forecast.xls workbook will try to open must have that same code in them.
 
Here is new code for the forecast.xls file.  Replace all of what I provided for that workbook to you with this code.
 
When you open the workbook it will examine all of the workbooks you set up to work with in the Workbook_Open() event.  It calls the other section of code for each of them.  I believe now that you have had to change worksheet names and paths to workbooks
before that you will understand what you have to change in this to make it work properly for you.
 
Private Sub Workbook_Open()
  'call the other routine for each workbook and worksheet you need to process
  'before each call, set up the names of the sheets involved and the path
  'to the other workbook.  This will work for 1 or 1,000 workbooks.
  Dim mySheetName As String
  Dim otherSheetName As String
  Dim otherWorkbook As String
  mySheetName = "banks" ' name of the sheet in this workbook to add a row to
  otherSheetName = "summary" ' if same name in all other workbooks, only need to set it 1 time
  'change this to the real path to the other workbook as seen from your system
  otherWorkbook = "Q:\for_DavutElmastas\taeh.xls"
  ProcessNewEntriesFromOtherWorkbooks mySheetName, otherSheetName, otherWorkbook
 
  'process another workbook (or same as before) but go to another sheet in this one
  mySheetName = "banks (2)" ' change to actual sheet name in this workbook
  otherSheetName = "Summary" ' sheet name to examine in the other workbook
  otherWorkbook = "Q:\for_DavutElmastas\taeh2.xls" ' full path and name to other workbook
  ProcessNewEntriesFromOtherWorkbooks mySheetName, otherSheetName, otherWorkbook
 
  'repeat as needed the 4 lines of code for each process to be done
  'if one of the mySheetName, OtherSheetName or otherWorkbook names
  'does not change, you only need to set it one time.
 
  '
End Sub
Private Sub ProcessNewEntriesFromOtherWorkbooks(thisWBSheetName As String, _
 otherWBSheetName As String, pathToOtherWB As String)
  'as this is setup now, we only anticipate having to open the taeh.xls workbook
  'if there are several that need to be examined, then we may want to alter the
  'way this works.
  '
  'change these constants as required to match the real workbook name and the sheet in it
  'that must be examined.
  '******
  Const ourMarkerColumn = "AD" ' known column where the process marker is placed
  'these refer to the sheet in this workbook to work with
  Const myFirstColumn = "B"
  Const myLastColumn = "AC"
'working constants and variables do not change the Const values below.
  Const readyToProcess = "R" ' same as in other workbook's code
  Const alreadyProcessed = "F" ' same as in other workbook's code
  Dim dataWBName As String
  Dim dataWSName As String ' the name of the sheet in the data workbook to examine
  Dim mySheetName As String
  Dim dataWB As Workbook
  Dim dataWS As Worksheet
  Dim markerList As Range
  Dim anyMarker As Range
  Dim myWS As Worksheet
  Dim myLastRow As Long
  Dim myNewRow As Long
  Dim myCopyRange As Range
 
  'move passed parameters into working variables
  dataWBName = pathToOtherWB
  dataWSName = otherWBSheetName
  mySheetName = thisWBSheetName
 
  'this prevents screen flickering and
  'improves speed of this process
  Application.ScreenUpdating = False
  Set dataWB = Workbooks.Open(Filename:=dataWBName, UpdateLinks:=False, ReadOnly:=False)
  Set dataWS = dataWB.Worksheets(dataWSName)
  Set markerList = dataWS.Range(ourMarkerColumn & "1:" & _
   dataWS.Range(ourMarkerColumn & Rows.Count).End(xlUp).Address)
  For Each anyMarker In markerList
    If anyMarker = readyToProcess Then
      'this is a full row that has not yet been accounted for in this workbook.
      Set myWS = ThisWorkbook.Worksheets(mySheetName) ' the banks sheet
      myLastRow = myWS.Range("B" & Rows.Count).End(xlUp).Row
      myWS.Range("A" & myLastRow).EntireRow.Insert ' add new blank row
      myNewRow = myLastRow
      myLastRow = myLastRow + 1
      Set myCopyRange = myWS.Range(myFirstColumn & myNewRow - 1 & ":" _
       & myLastColumn & myNewRow)
      myCopyRange.FillDown ' should copy the formulas if they are formed properly.
      'remember to mark the row as processed in the taeh.xls file
      Application.EnableEvents = False ' don't trigger Sheet_Change() in taeh.xls
      anyMarker = alreadyProcessed
      Application.EnableEvents = True ' re-enable event processing.
      'add totals for columns E, F, G, H and I
      myWS.Range("E" & myLastRow & ":I" & myLastRow).FormulaR1C1 = _
       "=SUM(R2C:R[-1]C)"
    End If
  Next
  'good housekeeping practices
  Set myCopyRange = Nothing
  Set markerList = Nothing
  Set dataWS = Nothing
  'close the other workbook
  Application.DisplayAlerts = False
  dataWB.Close True
  Application.DisplayAlerts = True
  Set dataWB = Nothing
End Sub

Make Sure that your Computer Meets the System Requirements

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

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)

If your computer meets the minimum requirements above, then continue on…

Recommended Method to Repair the Problem: adding a new row when another row filled in another worksheet:

How to Fix adding a new row when another row filled in another worksheet 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 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 SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Troubleshooting:Adding new row labels fields in pivot table from new columns in named table range Error,Solution to Problem: Adobe Flash Player problems With Internet Explorer,[Anwsered] After installing 4 additional GB or ram, Windows tells me I only have the original 2GB. Why?,After I installed service pack 1 for windows 7, I lost a dll file Tech Support,Troubleshoot:adobe flash player not staying installed,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

Fast Solution to Error: adware popups in internet explorer

adware popups in internet explorer

I tried to download a driver for my maxtor usb one touch external drive from a site called rapidshare-catalog.com

the driver did not install but now i get several pop up advertising windows from all sorts of adverising sites in ie explorer.

I installed ad aware but it did not find any malware.

how do I get rid of these? do i need to find them in the registry and, if so,how?

many thanks

Keys to the Problem adware popups in internet explorer

Download SmartPCFixer to Fix It (Free)

I tried to download a driver for my maxtor usb one touch external drive from a site called rapidshare-catalog.com

the driver did not install but now i get several pop up advertising windows from all sorts of adverising sites in ie explorer.

I installed ad aware but it did not find any malware.

how do I get rid of these? do i need to find them in the registry and, if so,how?

many thanks

hi ,

the site is seagate.com !

download only drivers from the manuf !

you can run in adition to spirit his post run the onecare scanner , link below in sig

have a nice day and happy new year

http://www.microsoft.com/security + http://www.microsoft-hohm.com/default.aspx + http://www.getpivot.com/ + http://photosynth.net/ + http://seadragon.com/ + http://blogs.technet.com/mmpc + http://windowsteamblog.com/blogs/genuinewindows/default.aspx + http://technet.microsoft.com/en-us/sysinternals/default.aspx
+ https://www.microsoft.com/security/portal/Shared/Resources.aspx#rss + http://www.microsoft.com/security_essentials/ + http://onecare.live.com/site/en-us/center/whatsnew.htm + Plagued by the Privacy Center? Learn how to remove it > http://blogs.msdn.com/securitytipstalk/
+ http://blogs.technet.com/ecostrat/ + http://memory.dataram.com/products-and-services/software/ramdisk + 50 Windows Tips > http://windowsvj.com/wpblog/2009/12/windowsvj-xclusive-release-windows-7-tips-tricks-ebook/ + http://windowsteamblog.com/

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 adware popups in internet explorer has been fixed.

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

Recommended Method to Fix the Problem: adware popups in internet explorer:

How to Fix adware popups in internet explorer with SmartPCFixer?

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

2. After the scan is done, 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: Troubleshooting:add-ins are not showing up,[Solved] Adobe PDF Maker not working.....,How Can I Fix - Advanced filtering Macro does not work afther recording.?,Tech Support: Adding new data for a spreadsheet to the master spreadsheet.,Adobe lightroom 3 - A problem has caused the program to stop working correctly,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