Copy - paste cells without hidden ones

Problem: How to paste only cells as seen on screen, hidden must stay hidden

In Office 2003:
press F5
Go to -
Special -
Visible Cells only
OK -
copy

Scanner reports error after one scan

Problem: Reliable Throughput Imaging Viewer. An unexpected communications error occurred.

Problem was solved by changing USB cable.

Wireless not working

Problem: The network connection setting have become corrupted. Restore Defaults

IntelPRO software report "No adapter etc".

Solutions found on web to repair and unistal IntelPRO software didn't help, nor Start - Run:
regsvr32 netshell.dll
regsvr32 netcfgx.dll
regsvr32 netman.dll

or
winmgmt /regserver
regsvr32 "%Windir%\system32\netshell.dll" regsvr32 "%Windir%\System32\hnetcfg.dll" regsvr32 "%Windir%\system32\wbem\wbemprox.dll" regsvr32 "%Windir%\system32\wbem\wbemsvc.dll" regsvr32 "%Windir%\system32\wbem\wbemcore.dll" regsvr32 "%Windir%\system32\wbem\fastprox.dll"
proposed by
http://www.winhelponline.com/articles/6/1/Error-The-network-connection-settings-have-become-corrupted-when-configuring-Windows-Firewall.html

Only this helped:
Insert Windows XP instalation CD,
Start - Run (or windows key+R);
sfc /scannow

Change CD/DVD in laptop Asus F5Z

Problem: CD/DVD can't be removed once all screws were removed

There is one extra screw beneath, at the processor (as shown on picture).
Also, holders should be taken from the old CD/DVD for the new one (see pic).

MS Project 2003 can't open

Error: "Your current security settings prohibit running ActiveX..."

This helped:
http://support.microsoft.com/kb/907343

Tools menu, click Options, click the Interface -

clear check box
Display Project Guide

Outlook mail doesn't print text

Problem: Printed message from outlook shows only header on hard copy

Solution proposed by yahoo didn't work (to find and delete OUTLPRNT file,
http://answers.yahoo.com/question/index?qid=20090113142826AAQuLjk

It helped to instal IE8 (IE7 was instaled - IE7 was the source of problem).

Adobe Acrobat Professional save jpeg as black

Problem: When saving pdf as jpeg it turns as black image(s)

Problem is with scanned image - scan it again, but this time with 300 pixels -
150 pixels were somehow too low for Adobe to save it as normal image so it turned out all black.

Xerox 8550 prints PDF as double bill

Problem: On Windows 7 64bit Xerox prints PDF documents as multiple pages

Even though this option is turned off in document print options, document in PDF ends up on hard copy as two pages in one.
Solution is to remove printer drivers (Xerox 8550 printer(s)... and to instal this one:
http://www.support.xerox.com/support/global-printer-driver/file-downlo ad/enus.html?operatingSystem=win7x64&fileLanguage=en&contentId=111410& from=downloads&viewArchived=false
Xerox Global Print Driver PS

And afterwards - in printer properties - options tab for Xerox 8550 - click "Xerox update" button.

NTLDR is missing

Problem: Windows XP CD doesn't offer XP repair, only instal new

Via Recovery mode on Windows XP CD;

copy e:\i386\ntldr c:\
copy e:\i386\ntdetect.com c:\

Xerox 8550 prints only black and white

Problem: It's 64bit Windows and drivers are downloaded from Xerox

This instructions helped:
http://www.sevenforums.com/drivers/67344-w7-xerox-8550-now-b-w.html

Printer options change are available to select from drop-down menu only as administrator.

First, select printer in options,
then vivid color in printing preferences.

Excel takes long time to delete rows

Problem: It takes long time for calculating

Tools - Options -
check Manual
instead of Automatic,
user reports that after this option, excel deletes rows immediately,
and only when saving document, excel calculates for long time, however much less time than before.

Network is not working, all devices have exclamation point!

Problem: Vodafone web stick also reports errors, USB network instals with code39

It was a virus,
which infected ndis.sys file, situated in
c:/windows/system32/drivers/

Antivirus deleted this file, causing all network devices to report code 39.
Deleting lower filters in registry, as suggested for this code39 error, didn't help.

This web page helped:
http://en.kioskea.net/forum/affich-86872-code-39-error-on-network-cards-due-to-virus

However,
after copying ndis.sys from a PC which works fine and after restart, a blue screen of death appeared.
I get rid of it via ERD commander and inserting registry information which was missing too:

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NDIS]
"DisplayName"="NDIS System Driver"
"ErrorControl"=dword:00000001
"Group"="NDIS Wrapper"
"Start"=dword:00000000
"Type"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NDIS\MediaTypes]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NDIS\Parameters]
"ProcessorAffinityMask"=dword:ffffffff

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\NDIS\Enum]
"0"="Root\\LEGACY_NDIS\\0000"
"Count"=dword:00000001
"NextInstance"=dword:00000001


[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\Root\LEGACY_NDIS]
"NextInstance"=dword:00000001

Actually, I opened a regedit on PC which worked ok and wrote this in troubled registry which was missing this information.
After restart, all devices were fine.

So I wouldn't suggest restart after "ndis.sys" copy without checking this registry information about ndis.sys first - they should be written or imported into registry if missing.

Toner ML-D2850B/XAA doesn't print

Problem: Samsung ML-2851 reports "Invalid toner"

XAA is, as the toner box states itself, "for sale only in Americas", it won't work on european printers.
Toners for Europe have ELS mark, written only on toner itself, not on the box. Toner's box for Europe is in green colour, and for Americas is purple one with region map and warning on it.

Excel comment changed size

Problem: How to adjust size for all comments in excel at once

Here is the solution;
http://www.codeforexcelandoutlook.com/excel-vba/comment-shape-formatting/

New macro:
Tools - Macro - Macros
choose name
create
delete
Sub s()

End Sub

copy paste this macro and run:

Function CommentSize(wksht As Excel.Worksheet, hgt As Single, _
wdth As Single)

Dim cmt As Excel.Comment

For Each cmt In wksht.Comments
cmt.Shape.Height = hgt
cmt.Shape.Width = wdth
Next cmt

End Function

Sub TestCmtSize()

Dim wksht As Excel.Worksheet
Dim wb As Excel.Workbook

Set wb = ActiveWorkbook

For Each wksht In wb.Worksheets
Call CommentSize(wksht, 50, 150)
Next wksht

End Sub

for larger comments numbers can change here:
Call CommentSize(wksht, 150, 150)

The change in comment size was caused by user intervention - automatic filter, insert cells, changing size of cells etc.

Size of one comment can be made automatic but only for that selected comment, one at the time.
Right click comment - Format comment
Alignment - check Automatic size

Excel can't be saved

Problem: "Document not saved"

Workaround Solution was to copy every sheet into new document.
Solution by registry didn't help, and windows patch requires personal data to receive their patch for this problem.

http://help.lockergnome.com/office/save-excel-document-saved-message--ftopict702702.html

Network not working, domain unreachable

Problem: Internet is working, but computer browsing is not

Apart from varios viruses, SNACNP Network Provider was active.
It can be seen and unchecked via Autoruns, by Sysinternals.
http://technet.microsoft.com/en-us/sysinternals/bb963902
After uncheck, repairing IP should renew address and make it work.

Thanks to Zac.

MB Asus P5G41-M and unknown PCI device

Problem: After instalation of official Asus CD with drivers, there is one missing

It was audio driver Realtek High definition audio, found on Asus web page.
During instalation, there was note New hardware found and error with driver, which dissapeared on it's own after few minutes and it was all well instaled after restart.

HP2015 stops responding

Problem: Printer HP 2015 after awhile stops taking orders to print althought it's in ready state

Solution described on HP forum worked ok!

http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=109447626+1297756547511+28353475&threadId=1393888

Real easy. The left side cover needs to come off and you just pry it off from the back using a flat tip screwdriver and then out. Remove the 3 connectors and 2 ribbon connectors to the board and remove the 4 screws and remove the board. Remove the black tape piece that covers some items by the dimm slot. Prop up on the 4 corners so the board does not touch anything with the chips facing up and put in baking pan and place in oven preheated to 350 F and keep in over for 8 minutes. Remove a let cool for about 30 minutes and put back together and it should work just fine.

(350F=176C)

Windows XP can't be updated

Problem: After Windows XP repair, activation window can'be be activated

Windows report that it should be activated however when clicking on activation, nothing happens.

It was solved by instaling Internet Explorer 8.
Command prompt didn't help (oobe/msoobe /a ).
After repair there was IE6 which was probably the cause of this problem. Also, IE8 couldn't be downloaded on this machine, so software instalation file for IE8 was copied from another PC.
There was another error message after windows repair:
"the requested lookup key was not found in any active activation context"
This error appeared on web pages randomly. And it was also solved by instaling the newest version of Internet Explorer.

Asus V2-P5945G turn-on switch doesn't work

Problem: User broke switch

Once the front mask removed, switch was easily accessable -
it should be pressed toward front to sit in it's place (like in a picture above).

Cannot start Microsoft Office Outlook, Unable to open the Outlook window

Problem: After unistaling Office 2010 and instaling 2003 there is Outlook error

Solution was to remove profile and to add it again.
Control panel - Mail - E-mail accounts - View: Next - Remove
Control panel - Mail - E-mail accounts - Add

STOP: c000021a (Fatal System Error)

Problem: Blue screen during bootup, after format there is stop error

Problem was caused by bad Fujitsu HDD,
inside HP Compaq nx6310.
Other symptoms were - data error (cyclic redundancy check) while copying data in ERD Commander. Also full format couldn't be completed, it hangs at 2%. Quick format passed ok.

Once new HDD was instead of the bad one, windows installation went fine.

Check Box i Label Box in Excel

Problem: Checkbox/labelbox can't be removed from excel

Toolbar "toolbox" should be active and this enables user to remove boxes-
View - Toolbars- Control toolbox
click on the box and delete

Adobe professional 7 (or 6) report error during instal

Problem: Print spooler restarting error while installing Adobe

Adobe professional restarts print spooler automatically
however problem was - print spooler can't finish restarting and hangs in restart option.
Restarting via services.msc or cmd didn't help.
The cause was Symantec antivirus- once it was removed, instalation went without perfect.
And removal of symantec didn't go perfectly as well - it was removed manually in total via msconfig.

Java error with bank card payement

Problem: Neuspjela instalacija PBZ banke

Copy websectech.dll from PC that works ok to
c-windows-system32

HP 2015 missing drivers during instal

Problem: Downloaded drivers or instalation from CD are not enough to complete printer installation

From the HP2015 CD, unzip hppcps04 (CD:\Drivers\Win2000_XP) file to hard disk
and browse missing files there to complete the installation.

Adobe Photoshop is freezing during start-up

Problem: Photoshop freeze only at a specific user, with others iz starts ok

It helped to find photoshop settings folder inside user profile and to delete it.

C:\Documents and Settings\username\Application Data\Adobe\Photoshop\x.0

Adobe Photoshop x.0 Settings

x=installed number

File menu is missing in Outlook

Problem: Reset toolbar didn't help

Delete Outcmd.dat and restart Outlook.
c - documents and settings - username - Application data - Microsoft - Outlook

Format date after merge

Problem: User wants european date format in Word after merging data date from an Excel document

Although regional settings are all set for local date format (date-month-year), after merge command, it appears in US format ie month - date - year.

Righ click Edit Fields
Field Codes
add this text to command already present:
\@ "d.M.YYYY"

If month appears as 00, original data for (stored in excel for example) date should be formated with *

DATUG is user defined field name.

Use ALT+F9 if data suddenly stops to merge, it is used to show format command from Field Codes.

A6R-5098 hangs at boot

Problem: Laptop freezes during start-up, BIOS or CD/DVD can't be accessed

Solution is to remove HDD, connect it via adapter to working PC,
Control panel - Administrative Tools - Computer managment -
Storage - Disk manager - Delete, reformat disk.
It had 2 partitions
which were created during Windows 7 instalation.
They are the cause of this problem,
which appears falsely at first as invalid MBO, HDD or BIOS.

Printer can't be installed on Windows7

Problem: Printers Canon Xerox 8550 and HP Laserjet 2015 refuse to instal via network on W7

Solution is to instal it locally
and then Add Port from Devices and Printers.
Enter information the same as on Windows XP
for example
\\pcname\hplaserjet
or
ip adress

Drivers for HP2015 are used for Windows Vista, since HP offers only universal printer driver - which doesn't work via network - with shared printer on XP pc.

Prevent Duplicate Entries in Excel formulae

Problem: Duplicate entries Excel formula is not working

Proposed formula found on google is not working; =COUNTIF($A$1:$A$50,A1)=1

the correct one is this, with ";" instead of ","

Data - Validation
Allow: Custom

=COUNTIF($A$1:$IV$20000;A1)=1
for whole sheet

=COUNTIF($C$1:$C$20000;C1)=1
for C column only

Error alert
enter you own error message

Unable to establish a connection with the activation server.

Problem: 32777 error during validation XP

This helped, thanx to Kiki;

IE, or Control panel - Internet Options,
Internet Properties:
Security - Local intranet - Custom level
Reset to: Low -
Reset

Trusted sites, add:
https://*.microsoft.com

I guess this might help with various Microsoft update problems as well?

Samsung ML-2851N prints blank pages randomly

Problem: Blank pages instead of documents started to appear after changing it's toner

The same documents print ok a few times and then randomly it prints as blank page(s).

Problem was resolved by replacing the toner from the same type of printer.
And furthermore, the toner worked OK on that other printer.
Reinstaling drivers from Samsung official download didn't help, neither restarting PC nor printer.
All toners are original Samsung toners.

Windows Security Center

Problem: Security center can't be accessed

Workaround:
in run - services.msc, it can be disabled.
Automatic updates also can be managed in services as well.

"A network cable is unplugged"

Problem: Cable is ok, another network card is inserted, and no network

DLink Green ethernet switch was to blame.
Once plugged into another switch, it worked ok.

Microphone in Skype is not working

Problem: User can't be heard in skype

Cam with mic was used. And cam has microphone integrated.

Skype - Tools - Options - Audio settings -
from Microphone drop-down menu select
the other device, for example Audio device

After forwarding mail, all Words are blank

Problem: When clicking forward mail, there is an error message and all Words start to be blank

Error is:
Word is unavailable, not installed, or is not the same version as Outlook

Solution is:
Microsoft Outlook 2003 - Tools - Options - Mail format - Message format

uncheck:
Use Microsoft Office Word 2003 to edit

Outlook is not showing pictures

Problem: Security settings are changed as advised for this problem, still no picture in mail

Registry:
HKEY_CURRENT_USER
Software - Microsoft - Office - 11.0 (or 8) - Outlook - Security

delete
OutlookSecureTempFolder

(it will recreate itself afterwards)

Access denied to drive C - Vista

Problem: Copy, paste, device manager do not work, there is error message  not allowing it

Even though administrator is logged in.
Solution is here:
http://www.vistahelp.ca/phpBB2/viewtopic.php?t=543&sid=6f0880301c7d67caea8b2398fd2faeed

There is a program Take Ownership, which after is run allows administrator to right click drive C and replace in Security tab current owner (which was nobody) into administrator:

http://www.petri.co.il/download_free_reskit_tools.htm#

Canon MF4150 prints continously same file

Problem: After file is printed, there is an error at display

Error states that paper is incorrect, and system monitor key can be used to cancel document,
system monitor key is left from the display, first in the row.

In printer settings, page size must be A4 selected. It was letter before, which was the cause of same file printing in the loop problem.

Hyperlink doesn't work in Excel

Problem: There is an error message when clicking hyperlink

Internet explorer wasn't default browser.

Internet Properties
Programs - Make default

Classic view style

Problem: Classic view in Control panel can't be set

Start - Run - gpedit.msc

Local Computer Policy - User Configuration -
Administrative Templates
Control Panel
Force classic Control Panel = enabled

Text Services and Input Languages can't save changes

Problem: Regional settings are not saved, IE reports error for search provider

The user was created as "Temp" in documents and settings.
Once the new profile was created, keyboard settings were saved and IE worked ok.
Creating the new profile is the only advice on the net for saving keyboard settings,
tweaks didn't help.

Network scanner is not accessible

Problem: Some users cannot ping and access status to network scanner (iR3300)

The cause of problem was network switch - once it was restarted (unplugged from the power and re-plugged) it worked ok. Scanner and the other user are connected to the switch. PC which was not connected to the switch worked with scanner OK the whole time.

Asus PC keeps freezing

Problem: Windows freeze frequently during start-up, during work and always on shutdown

The cause was audio driver
and enabled settings in BIOS for:

Onboard devices configuration
Azalia Controller