January 31, 2012

Scan settings for TIF extension


Problem: TIF size turns out too big, how to minimize TIF size

Output settings: 150 dpi
Output size: 65%

And when saving TIF, choose click on options button
to choose compression type.

Adobe is not working from IE or Mozilla



Problem: When user clicks on PDF link, page displays with error

When web page with pdf is opened, this error appears:
The application is being terminated because of memory corruption.

Instalin the newst PDF reader didn't help, and updates for Adobe professionalcaused the same symptom but with new error message:
"the organizer database is damaged and will be reset the next"

From that point, there is solution on adobe forum:
http://kb2.adobe.com/cps/407/kb407749.html

Windows XP: C:\Documents and Settings\[your user name]\Application Data\Adobe\Acrobat\8.0
Delete organizer.
which fixed the problem.

January 23, 2012

How to ignore more than 2 decimal places in excel




Problem: When formated cell with 2 decimal points is copy/pasted to another cell, it copies more than 2 decimal places as well

User doesn't want to see and calculate all decimal places, to copy only 2 decimal places.

Excel:
Tools - Options - calculation
Workbook options

mark;
Precision as displayed
(warning message that calculation won't be precise on that particular document appears.
This should be repeated on every documents that user wants without all decimal places)

Precision as displayed options works only on current document.

Microsoft .Net Framework 4 won't install




Problem: On Windows 7, .Net framework 4 update keeps appearing

This web page suggest repair
http://social.msdn.microsoft.com/Forums/ar-SA/netfxsetup/thread/e5e59c7d-29a6-40b7-9ee1-e0a65c3259d0
however, it didn't help. Unistal also produce error message.
It helped to download and run Clean up utility
http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_update/my-net-framework-4-wont-repair-and-it-keeps-coming/9fe80453-f7ec-48ab-b878-b21f5380b61d

dotnetfx_cleanup_tool.zip
http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Components-PostAttachments/00-08-90-44-93/dotnetfx_5F00_cleanup_5F00_tool.zip

After clean, restart Windows
and run update again,
there will be repair notification (as shown on picture) and successful instalation of framework 4.

Toshiba Satellite High Definition on Audio device


Problem: Satellite P100 -10P has unknown driver for audio

Instaling patch, Drivers for high definiton didn't work.
Problem was wrong driver for sound:
Toshiba web site for this model will offer 2 drivers for sound.
http://il.computers.toshiba-europe.com/innovation/jsp/SUPPORTSECTION/discontinuedProductPage.do?LNG=29&service=IL&PRODUCT_ID=127190


sound-20071106151533 didn't work,

the correct one is;
sound-20071015135316
version 3.21.0.52

January 20, 2012

Warning: IllegalMediaSize

Problem: Excel document prints partialy

Page Setup - Paper size was A3 - it must be A4 because printer is A4 only.

January 18, 2012

How to list data in Excel with enter


Problem: When user types data and then press enter, or shift and enter, another cell is active

Press "alt" and "enter" to have desired data in a single cell - in a row.
(as shown in picture)

January 17, 2012

Excel doesn't show values in document created by SAP




Problem: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features

Document uses program features from bookkeeping software SAP. Exporting SAP data to excel results that it doesn't show values in Office 2007 by users who have instaled both Office 2007 and Office 2003. It appears as #NAME?

Problem was solved on one user by saving document from e-mail and allowing macro in Office 2003 - and opening document in Office 2003.
At the other user however, this didn't help. There was additional problem - Office 2003 didn't have VBA project, so it should be instaled first (Add remove programs - Office 2003 - Change - and additional features - install Office shared features - which weren't instaled at first time, as shown in second picture). Afterwards, document worked fine only after deleting document and saving it again from e-mail, with macro security removed. It appears as if document was somehow meddled with simply by opening it.

Users who had instaled only Office 2003 didn't have this problem.

Problems keep appearing in Office 2007, it works without value error only in Office 2003.

January 12, 2012

Office 2007 can't be instaled


Problem: Microsoft Office Professional Plus 2007 encountered an error during setup.

This didn't help:
MSI Removal, Remove Office 2007 application, Microsoft Fix it patch 50493, nor deletion of Microsoft Help folder (c - documents and settings - all users)

After all that, this Microsoft patch Fix it 50154 helped:
http://support.microsoft.com/kb/928218

January 11, 2012

Enter product key in Office 2010




Problem: Where is office 2010 activated?

After instaling, open Word -
click File - Help
Change product key

OR

Control Panel - Programs and features -
Microsoft Office - Change
Enter a Product key

However that's not all - after a few restarts and updates,
starting word there'll be activation window - which will activate Office.

November 28, 2011

Error - path to Symantec AntiVirus.msi


Problem: "The feature you are trying to use is on a network"

Remove Symantec with free Microsoft program "MSI removal" - find Symantec in the list and remove it,
then reinstal Symantec.

November 21, 2011

Printer Samsung 2851 prints blank pages


Problem: With new toner inserted, there are only blank pages

Another toner also produced blanks. However old toner worked ok.
It was solved by shutting down the printer and switching it on again..

November 11, 2011

An error (607) occured during the action Print.


Problem: Visio won't print

Problem was with printer removed from the network, user didn't see descriptiont that printer is no longer available.
Another printer installed solved the problem.

November 10, 2011

Cannot Instal this Hardware error for printer


Problem: Printer refusing to print

Error message for Samsung ML-3050 was "Cannot Instal this Hardware".
Instaling universal samsung driver reported printer was offline.

Solution was to replace printer cable and installing drivers for 3050.

How to show expired date in excel


Problem: What is formulae in excel for showing expired dates

Explained for Excel 2003 - 2011:
http://www.techonthenet.com/excel/questions/cond_format4_2007.php

Update:
formulae won't work if user used full stop in the date (11.11.2011.)
Find - replace 2011. with 2011 solved that problem (11.11.2011)

Xerox 8550 appears offline

Problem: It's offline on PC screen, it's "Ready to print" on printer display

Troubleshooting – (OK)
Service Tools – (OK)

Reset NVRAM – (OK)
Reset Nvram And Reset Printer – (OK)

(thanx to Tomi)

November 07, 2011

Format cells in excel for typing a number as currency


Problem: How to automatically format cells in excel for currency

Format Cells - Number - Custom
Type for euro:
#.##0,00 "€"

or some other currency;
#.##0 "LEK "

SM Bus unknown driver at G41MT-D3V




Problem: Although official CD installed all drivers, there is SMBus unknown

Solution is here:
http://downloadcenter.intel.com/confirm.aspx?httpDown=http://downloadmirror.intel.com/18494/a08/infinst911autol.exe&lang=eng&Dwnldid=18494&DownloadType=Utilities%2c+Tools+and+Examples&OSFullname=Windows+XP+Professional*

Intel offers description and link for this problem:
http://www.intel.com/support/chipsets/sb/cs-013541.htm

October 20, 2011

Canon i-SENSYS MF4150 doesn't print report(s)

Problem: Fax is working, but there are no fax reports

Problem was low toner,
The printer indicates toner error, however, the hard copy is ok.

Once the toner cartridge was replaced, error was gone and it printed all missing reports.

Office File Validation detected a problem



Problem: "Opening it may be dangerous" message while opening excel file

The cause for this error is new Microsoft Office feature.

Document can be opened
however to turn off this message:

you must create new values in registry editor so it looks like in picture above:
for office 2003:

start - run - cmd -
regedit -
HKEY_CURRENT_USER\Software\Policies\Microsoft\
Office\11.0\Excel>\Security\FileValidation

Value: EnableOnLoad
Type: DWORD
  • 0 = Don’t validate

  • 1 = Validate

  • 2 = Validate unless called via object model

Explanation and Solution:
http://technet.microsoft.com/en-us/library/gg985445%28office.12,printer%29.aspx

October 01, 2011

USB mouse not working

Problem: USB installs mouse drivers, however mouse cursor not responding

USB works fine with storage devices, mouse works fine on another PC.
Solution was to reinstal Windows - without format option, only to repair.

September 29, 2011

Excel not responding when opening over network


Problem: Excel document shared over network takes long time to open

This solution helped:
http://forums.techarena.in/ms-office-support/749154-2.htm

KB2509503 was in the list (Show updates option ticked in Add/Remove list)
once it was removed, excel opens normally.
That update was installed 5 months ago, but it started to make problems a few weeks ago.

September 28, 2011

No desktop icons



Problem: Right click is not working over desktop area

There was generated registry key, hiding desktop;
it was set to 1, it should be 0:
cmd - regedit -
CURRENT_USER - Soft. - Micros.-Windows - CurrentVersion - Policies - Explorer
No desktop: 0

September 04, 2011

The process android.process.acore has stopped unexpectedly.


Problem: Error keeps repeating on Prestigio PMP5100C

Forums on web suggest factory reset, however keyboard is not responding, or respond only by clicking on message, then returning again.
It helped to reset it, and turn off few times, all of the sudden it started to work so far to reach settings and factory reset option - after erasing everything it worked ok, suggesting it was caused by some faulty software.
UPDATE: Possible cause of this problem is google,
in the first instance it was google mail application, and in another it was google talk. In both instances, applications were instaled as incorporated third party software, sw run fine until google account was added.

The second time it happened, it helped to draw android status bar - which was only possible action - down, open application remover software which was installed and luckily enough run in status bar all the time - and deinstal app associated with google. Once removed, error message stopped.

UPDATE 2:
The solution is to open setting- applications - and to click one by one and to clear cache on each of them, unistalling the last unused applications as well. Once the newspapers cache was cleared, repetative error miraculously dissapered.

August 22, 2011

Open Heat Error: Cycle power



Problem: Samsung 3051-ML reports error status, not printing

This helped:
http://www.fixya.com/support/t7903700-solve_samsung

Fuser Unit Fuser assembly Fuser kit for Samsung 3051 needs to be replaced.
There are 4 screws, 2 green hafts need to be turned up to release..it's easy to replace, no need to remove printer shell.
Once the unit was replaced, it worked ok.


August 20, 2011

Button on PC case is not working





Problem: Start up button is broken

On case as shown on picture, I used solder wire to imitate broken part
which allowed button to press and start up the PC.
Update:
Even better, press slightly tin which holds movable part, as shown on picture- to hold it without being able to move out. (thanks to Hrvoje)

August 18, 2011

Programs not visible, desktop is empty


Problem: Only Documents and settings folder is visible

The rest of folders are hidden.
Control panel - Folder options - View - select Show hidden files and folders,
Uncheck Hide protected operating system files
Then, you can unhide them, right click on folder and remove hidden check box.

But this won't bring back shortcuts inside start - programs, this will:
http://answers.yahoo.com/question/index?qid=20110528163854AAL9Uyp

C:\Documents and Settings\Username\Local Settings\Temp - smtmp folder
has all shorcuts for start programs, copy them back:
folder 1 is programs - copy all shortcuts back to where it belongs; C:\Documents and Settings\All Users\Start Menu
folder 2 is quick launch - C:\Documents and Settings\Username\Application Data\Microsoft\Internet Explorer\Quick Launch.
folder 4 is desktop - C:\Documents and Settings\All Users\Desktop

However if you log in as another user, desktop is empty. Solution is:
run- cmd - regedit:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer
NoDesktop,REG_DWORD,1
delete it.

http://www.tomshardware.co.uk/forum/259472-35-desktop-items-programs-empty


August 11, 2011

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


August 09, 2011

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


July 27, 2011

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).

July 21, 2011

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


July 18, 2011

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).

June 21, 2011

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.

May 04, 2011

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.

April 27, 2011

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:\

April 04, 2011

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.

March 25, 2011

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.

March 23, 2011

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.