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:

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.

Tools - Options - calculation
Workbook options

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
however, it didn't help. Unistal also produce error message.
It helped to download and run Clean up utility


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.

sound-20071106151533 didn't work,

the correct one is;

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:

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


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.