How Can I Speed Up Windows?: September 2016

Thursday, September 29, 2016

Display issue opening multiple instances of Word 2007

I have an issue when opening two instances of Word 2007. I want any istance that I open to be maximized upon opening.
My first instance is maximized, but the second instance is smaller. This happens every time no matter if I set the Word shortcut to
open maximized or if the last Word instance that I close is the maximized one.

Solutions to the Problem Display issue opening multiple instances of Word 2007

Download SmartPCFixer to Fix It (Free)

How are you trying to open two instances of Word?

Also open Word in safe mode and check if it helps:
Click on Start< All Programs< Accessories< Run< Type ‘winword /safe’ (without quotes) and click on Ok.
Note: There should be a space between 'winword' and '/'.

If you are able to work with Word without any problem then the issue might be due to add-ins.
In order to disable the add-ins follow the steps given below:
Step1: Click the Office Icon and Click Word Options.
Step2: In the left hand side of the word Options dialog box, click Add-Ins.
Step3: Under ‘Manage’ Click the COM Add-ins.
Step4: Uncheck all the Add-Ins listed under COM Add-ins.
Step5: Click close and restart Word.

Open Word and then try to open the document from within the Word and check if it works fine.

Is Service pack 3 for Office 2007 installed on the system?
If no, then try to download and install service pack 3 for Office 2007 from the link given below and check:
http://www.microsoft.com/download/en/details.aspx?id=27838

To check for Windows updates

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

Display bug in Excel 2007 and 2010. What to do?

I've found a display bug that affects Excel 2007 and 2010.
There was a previously documented issue with numbers nearing 65535, but this one affects calculations that should result in 0.

For example,

65.57 - 58.03 - 7.54 = 0
65.57 - 7.54 - 58.03 = -7.99361 x 10^15

but to verify it's a display bug, add an extra helper at the end...

65.57 - 7.54 - 58.03 + 1 = 1

These numbers originally came from a calculation involving each number being in separate cells.
I did test in a new workbook, by manually typing the values into one cell (=65.57-7.54-58.03) and I get the same display result.

I then tested on a separate PC, using Excel 2010, and got the same visualization.

I've tried formatting it, but I use comma or accounting format for most things...
I'm not use to seeing 0.00 randomly inserted in my column of all '-'s

Any suggestions on what to do, or how to work around it?

For what it's worth: Office 2007 on XP SP3, Office 2010 on Win7 x64 SP1

Thanks

Neil

Edit: =2059.32-1879.32-120.48+184.8-244.32 displays 2.27374e-13 as an answer, when it should be 0 as well.

Keys to the Problem Display bug in Excel 2007 and 2010. What to do?

Download SmartPCFixer for Free Now

Neil wrote:
For example,
65.57 - 58.03 - 7.54 = 0
65.57 - 7.54 - 58.03 = -7.99361 x 10^15

Actually, I think you have the examples reversed. For me:

1.
65.57 - 58.03 - 7.54 = -7.99361E-15
2.
65.57 - 7.54 - 58.03 = 0
3.
65.57 - 7.54 - 58.03 - 0 = -7.10543E-15

I added #3 to make a point: in this case, #2 results in exactly zero only because Excel forces it to be zero due to the dubious heuristic poorly described under the misleading title "Example When a Value Reaches Zero" at http://support.microsoft.com/kb/78113.

As I indicated previously, the problem is that none of those numbers are represented exactly. They are:

65.57: 65.5699999999999,9317878973670303821563720703125
58.03: 58.0300000000000,01136868377216160297393798828125
7.54: 7.54000000000000,003552713678800500929355621337890625

The order of operations makes a difference only because of the differences in the approximate representations of the intermediate results (pairwise operations). So:

65.57-58.03: 7.53999999999999,2041921359486877918243408203125
65.57- 7.54: 58.0299999999999,9403144101961515843868255615234375
[EDIT] Well, of course the intermeditate results are different. I meant: differences between the approximate representations
relative to the last operand, the latter being closer to 58.03 than the former is to 7.54.

Excel forces #2 to zero only because the representation of 65.57-7.54 is "close enough" to the representation of 58.03 that Excel decides
arbitrarily the subtraction is "close enough" to zero.

But as #3 demonstrates, Excel does that only if the
last subtraction (or addition of operands with opposite signs)
causes a change and is "close enough" to zero. Since "- 0" does not cause a change, Excel does not employ the heuristic. (Klunk!)

Neil wrote:
2059.32-1879.32-120.48+184.8-244.32 displays 2.27374e-13 as an answer, when it should be 0 as well.

The explanation is similar. I could provide the details, but I hope you get the point.

Because of this Display bug in Excel 2007 and 2010. What to do? error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.

Lastly, this error Display bug in Excel 2007 and 2010. What to do? can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.

In order to resolve Display bug in Excel 2007 and 2010. What to do? error or repair the corrupted and damaged Windows files, you will need a Display bug in Excel 2007 and 2010. What to do? error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:

Start the computer and log in as administrator
Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
On the new confirmation window that appears, click Next
Restart your computer after the restoration has been completed

Another Safe way to Fix the Problem: Display bug in Excel 2007 and 2010. What to do?:

How to Fix Display bug in Excel 2007 and 2010. What to do? 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 computer. The errors will be shown in the scan result.

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

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

does defrag work in a raid 0 setup?

I'm using dual 750GB WD Black Caviar hard drives.

Anwsers to the Problem does defrag work in a raid 0 setup?

Download Error Fixer (Free)

I'm using dual 750GB WD Black Caviar hard drives.

Yes.
RAID0 (not really a RAID to me - JBoD maybe) is nothing but a striped set of disks so that it is PRESENTED as a single disk. Defragmentation can sort the data on array of disks just as well as it can a single disk - since it is the same thing. I guess
it is aptly named if you take it as a whole (there's no redundancy, so RAID ZERO.
heh)
I wouldn't recommned striping at all. When you defragment you do moving around of data which can uncover issues with a drive - which could break the "RAID" set and thus - make you lose all your data. However, if you have chosen to do so - it contains data
just like anything els e- defragmentation is something you should do because the file system will work more effectively if the drive is defragmented.
Guessing you are doing some sort of video/audio editing and you are trying to squeeze out some extra performance as well as have 1.5TB (more like 1.4TB usable) of contiguous space too? (Two drives...
probably between 0% and 15% performance increase depending
on what you are doing on them as opposed to using just one of those drives.)

Machine Throttling

Go to the Start button.
In the Search box, type "regedit" (without quotes) and press Enter.
Look for the following registry key: "HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\ SQMClient\Windows\DisabledSessions".
On the right window pane, delete the subkey: "Machine Throttling".
Restart your computer.

Another Safe way to Fix the Problem: does defrag work in a raid 0 setup?:

How to Fix does defrag work in a raid 0 setup? 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 computer. 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. 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.

Does Windows Update install actual Windows updates?

What I'm trying to say is: Does the automatic updater install Windows 8.1 on Windows 8, because I don't want to install 8.1, due to earlier problems when I installed it a few months ago and had to restore my pc.

Keys to the Problem Does Windows Update install actual Windows updates?

Download SmartPCFixer to Fix It (Free)

First you get Windows 8.1 from the store not Windows update and you have physically accept the download for it to be installed.
You may get banners advising you update to Windows 8.1 but you don't have to at this point.
Hope this helps and if you need
further assistance post and we will be glad to assist you.

The above opinion is mine and mine alone and doesn't necessarily reflect that of Microsoft, it's
employees, or any other member of this forum.
"When we try to pick out anything by itself, we find it hitched to everything else in the Universe." -John Muir

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

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

Another Safe way to Repair the Problem: Does Windows Update install actual Windows updates?:

How to Fix Does Windows Update install actual Windows updates? 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 finished, you can see the errors and problems need to be repaired. Click Fix All.

[Solution] Download error message "A semi colon character was expected"

Download error message "A semi colon character was expected"

Can't download anything from internet as get the error message

A semi colon character was expected

Line 2

Download SmartPCFixer to Fix It (Free)

Hi smparry,

Which website are you trying to download from?
What version of Internet Explorer (IE) is installed on your computer?
In the meantime, try configuring the setting below in Internet Explorer.
Step1: Enable Active Content on the computer.
Open Internet Explorer.
Go to Tools Menu > Internet Options
Go to Advanced Tab.
Put a check on “Allow Active Content to run files on my computer” under security.
Click on apply and ok.

Check if you can download from IE.
If you still can’t, then follow the steps below.
Step 2: Perform IE optimization.
Method 1: Clear cached data in Internet Explorer
This is how we do in IE 8
Internet Explorer 8
1.       Open Internet Explorer 8.
2.       Click Safety, and then click
Delete Browsing History.

3.       In Delete Browsing History area, click
Delete.

For IE 7, you may refer the link below.
Method 2: Reset security settings for Internet Explorer
1.       Open Internet Explorer.

2.       Click Tools, and then click
Internet Options.

3.       Click the Security tab.
4.       Click Reset all zones to default level, and then click
OK.
After you do this, test Internet Explorer to verify that it works correctly.
If issues still occur, try Method 3.
Method 3: Start Internet Explorer in "No Add-ons" mode
To start Internet Explorer in "No Add-ons" mode,
1.       Click Start >
All Programs.
2.       Point to Accessories >
System Tools
3.       Click Internet Explorer (No Add-ons).
To continue to your home page, click the
Home button.

If the problem does not occur after you use this method, use Manage Add-ons to determine which add-ons are causing the problem.
To do this, follow these steps:
1)       Click Tools on the Internet Explorer toolbar, and then click
Manage Add-ons.

2)       Click the name of the add-on at the top of the
Toolbars and Extensions list, and then click Disable.
3)       Click Close, and then test Internet Explorer.
4)       If the problem still occurs, open
Manage Add-ons, enable the add-on that you disabled in step 2, and then repeat steps 1 through 3 for the next add-on in the
Toolbars and Extensions list.

5)       Repeat steps 1 through 3 until the problem is resolved or until all the add-ons have been tested.
Additional Information:
How to optimize Internet Explorer
http://support.microsoft.com/default.aspx/kb/936213
If the above steps still don’t help, you may consider performing IE reset.
Step 4: Reset Internet Explorer settings
This brings IE to its default configuration.
To reset Internet Explorer settings, click the fix it provided in the knowledge base link below.
Important:
Please note that running RIES (Reset Internet Explorer Settings) will reset all user-defined settings including those set by installed extensions, toolbars and other add-ons to IE Defaults.
This includes all Security, Privacy and Zone settings.
Also
this will clear browsing history, delete all temporary Internet Files, cookies, form data and especially all stored passwords.

How to reset Internet Explorer settings
http://support.microsoft.com/kb/923737

Regards,
Shinmila
H - Microsoft Support
Visit our Microsoft Answers Feedback Forum
and let us know what you think

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 Download error message "A semi colon character was expected" in Windows.

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

Try and see if you still get the same error Download error message "A semi colon character was expected" in your Windows.

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

Driver Detective programme does not start due to standard font error "Arial font does not support style 'Regular'"

Have updated to latest version to no avail

Keys to the Problem Driver Detective programme does not start due to standard font error "Arial font does not support style 'Regular'"

Download SmartPCFixer for Free Now

Hello Midasi,
According to Windows 7 compatibility Center, Driver Detective version 8 is compatible with Windows 7.
What version are you trying to install?
Check
out the list here for compatiblity.
I suggest you contact the manufacturer, PC Drivers Headquaters for assistance with issue and see if they have an updated version of their software.
http://www.drivershq.com/

Sincerely,

Marilyn
Microsoft Answers Support Engineer
Visit our
Microsoft Answers Feedback Forum and let us know what you think

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.

Does anyone know how to change/control/emit the dates shown on the x-axis to only those with corresponding data??

I need to make a line graph displaying a student's scores which only shows the dates on the x-axis that have data.
I teach kids with autism in their homes, sometimes only once or twice a week, and some things get put on hold for a month or two, so showing
every day would be unnecessary and skews the graph appearance.

I've tried everything I can think of and nothing has worked. I tried to call Customer Service but they were absolutely no help.
I'm incredibly frustrated!!
Any ideas/help would be greatly appreciated!! Thanks so much!!

Keys to the Problem Does anyone know how to change/control/emit the dates shown on the x-axis to only those with corresponding data??

Download Error Fixer (Free)

Hi,

Right click on the x axis dates and under Format Axis, choose Text axis

Hope this helps.

To check for Windows updates

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

Keys to the Problem disk defrag problems

Download Error Fixer for Free Now

Don't Download Malware

Where are you getting the download?

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

Cancel or deny any automatic download

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

Avoid advertisements on download pages

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

Another Safe way to Fix the Problem: disk defrag problems:

How to Fix disk defrag problems with SmartPCFixer?

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

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 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, junk file cleaning and print spooler error repair.

How to Fix - Display one worksheet inside another worksheet?

Display one worksheet inside another worksheet

In Sheet1 Columns A2 thru C15, I have a table. In Sheet1 Column E2 thru F3 I want to display a table from Sheet2.
How do I set up Sheet1 so I can display a small table from Sheet2 inside it?

Anwsers to the Problem Display one worksheet inside another worksheet

Download SmartPCFixer for Free Now

You may use formula to link Sheet1 E2:F3 to Sheet2 E2:F3.

In Sheet1, select E2 to F3.
type the formula:
=Sheet2!E2
Press ctrl + enter after finish typing.

Regards,
Edwin Tam
Excel Power Expander - http://www.vonixx.com

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.

Thursday, September 29, 2016

Display issue opening multiple instances of Word 2007

Solutions to the Problem Display issue opening multiple instances of Word 2007

To check for Windows updates

Recommended Method to Repair the Problem: Display issue opening multiple instances of Word 2007:

How to Fix Display issue opening multiple instances of Word 2007 with SmartPCFixer?

Display bug in Excel 2007 and 2010. What to do?

Keys to the Problem Display bug in Excel 2007 and 2010. What to do?

Another Safe way to Fix the Problem: Display bug in Excel 2007 and 2010. What to do?:

How to Fix Display bug in Excel 2007 and 2010. What to do? with SmartPCFixer?

does defrag work in a raid 0 setup?

Anwsers to the Problem does defrag work in a raid 0 setup?

Another Safe way to Fix the Problem: does defrag work in a raid 0 setup?:

How to Fix does defrag work in a raid 0 setup? with SmartPCFixer?

Does Windows Update install actual Windows updates?

Keys to the Problem Does Windows Update install actual Windows updates?

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

Another Safe way to Repair the Problem: Does Windows Update install actual Windows updates?:

How to Fix Does Windows Update install actual Windows updates? with SmartPCFixer?

Download error message "A semi colon character was expected"

Running System Update Readiness Command

Recommended Method to Repair the Problem: Download error message "A semi colon character was expected":

How to Fix Download error message "A semi colon character was expected" with SmartPCFixer?

Driver Detective programme does not start due to standard font error "Arial font does not support style 'Regular'"

Keys to the Problem Driver Detective programme does not start due to standard font error "Arial font does not support style 'Regular'"

Recommended Method to Fix the Problem: Driver Detective programme does not start due to standard font error "Arial font does not support style 'Regular'":

How to Fix Driver Detective programme does not start due to standard font error "Arial font does not support style 'Regular'" with SmartPCFixer?

Does anyone know how to change/control/emit the dates shown on the x-axis to only those with corresponding data??

Keys to the Problem Does anyone know how to change/control/emit the dates shown on the x-axis to only those with corresponding data??

To check for Windows updates

Recommended Method to Fix the Problem: Does anyone know how to change/control/emit the dates shown on the x-axis to only those with corresponding data??:

How to Fix Does anyone know how to change/control/emit the dates shown on the x-axis to only those with corresponding data?? with SmartPCFixer?

disk defrag problems

Keys to the Problem disk defrag problems

Don't Download Malware

Another Safe way to Fix the Problem: disk defrag problems:

How to Fix disk defrag problems with SmartPCFixer?

Display one worksheet inside another worksheet

Anwsers to the Problem Display one worksheet inside another worksheet

Recommended Method to Fix the Problem: Display one worksheet inside another worksheet:

How to Fix Display one worksheet inside another worksheet with SmartPCFixer?