December 13, 2013

Partial print of PDF document

Problem: Only part of PDF document is printed although it's A4

In print option, "Choose paper source by PDF page size" should be unchecked.

November 29, 2013

Excel 2010 crashes when a box above the cells is clicked

Problem: Excel has "not responding" error when check/text box is clicked

I opened that same document in Libre office, saved it, then when it's opened again as Microsoft Office-
the box was gone by itself, and no more crashes.

October 27, 2013

Printed documents turns out as distorted hard copy

Problem: Printed documents are only fragments of original sent document, they turn out to be partly printed,  magnified and distorted in hard copy

Problem was in printer settings for paper size/Orientation -
it was set to print in landscape even though the document was in portrait.

September 24, 2013

Sum values only those which are not hidden

Problem: Sum function sums all values, even though some are not visible (hidden) in Excel

How to sum only visible values - not to include hidden ones -
the instructions for Excel says to use SUBTOTAL instead of SUM and number 9 or 109 in front of the range, like this;


In Croatian system this doesn't work,
there should be ; instead of ,
and number 109;

=SUBTOTAL(109; A1:A5)

August 20, 2013

Adobe Flash can't be installed

Problem: Adobe Flash installation hangs in Task manager

Some web sites suggest this is due to antivirus/malware software. The PC with this problem didn't have any antivirus/malware software at all.

Solution was to download and run full Adobe Flash installation:

August 19, 2013

Remote desktop shortcut

Problem: How to quickly open Remote Desktop Connection

Windows button + R
mstsc - OK

August 13, 2013

Excel 2003-2007-2010 crashes when opening up

Problem: Excel document opens only after recovery

This problem is connected with previous post:

The same solution helped - in registry:

was to 3, it should be 0:

LoadBehavior from 3 to 0

Excel works fine when opening as new document, however if old documents are opened - they crash immediately.

August 12, 2013

Problem: Excel cannot be added through Object option in Word

There is an error:

"The program used to create this object is Excel. That program is either not installed on your computer or is not responding. To edit this object, intall Excel or ensure that any dialog boxes in Excel are closed."

 Excel document was opened - once it was closed, it could be inserted into Word as Object (no dialog boxes as suggested).

August 02, 2013

Drivers for Panasonic s3065c

Problem: Where to find Windows 7 64-bit drivers for Panasonic scanner s3065c?

RTIV and basic drivers are enough:

July 15, 2013

This command is not available in a shared workbook.

Problem: Copy - paste image is not allowed in Excel 2003

Also, at the name of document, there is [Shared] label,

To remove it and thus allow copy-paste:
Tools - Share Workbook - remove check box 'Allow changes..'- confirm with yes.

July 11, 2013

An extension failed to initialize

Problem: This error occurs when opening Outlook 2003

extended.dat must be renamed into extended.old

File is in this location:
C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Outlook

June 26, 2013

Status message at startup trying to instal itself

Problem: After repairing Windows XP there is Status error message in loop

It was caused by HP software
HP Deskjet F4200 All-in-one DriverSoftware 11.0 Rel.3
Once uninstalled, the message was gone.

Paste special is not showing standard features

Problem: Copy-paste in excel doesn't show paste special for formatting

On the internet, it is said that skype is causing this, and that browsers should be closed, with add-in for skype disabled :
in this case, skype was not installed on user's PC. So immediate solution was to close Mozilla and IE -
and copy - paste worked ok.

Mail merge items show various decimal points, only 2 are needed

Problem: In Excel, mail merge option inserts decimal points with 0,xx and 0,xxxxxxx format and user wants only 0,xx

This web page helped:
Changing How Word Displays Numbers in Mail Merge

the best solution is to include a switch in the merge field.

 {MERGEFIELD "Iznos"\#--0,00x }

June 07, 2013

Page numbering in Word 2010

Problem: Insert - Page number options does not insert solely page number, it adds format header as well

(Thanks to Tomi):
Insert - Page Number - Current Position

However if that doesn't work, to insert only page number, go to;
Insert tab - Quick Parts - Field

NumPages is total number of pages.

May 14, 2013

Office 2003 installation on your computer is corrupted

Problem: Removing Office 2003 and installing 2010 produces error

Consequently, Office 2010 can't be installed.
Registry solved this problem;
run - cmd - regedit:

May 07, 2013

No text when forwarding mail

Problem: In Outlook 2003 there is no message body when forwarding

User had local folder with messages - when opened from this location there is message text, however when user tries to reply or forward, there is no body message.
All mails located in Outlook worked fine when forwarding.

It didn't help to set filtering none:
Tools, Options, General Tab, Email Options... ( button), General Tab "Html Options" > HTML filtering Options: - Select "none"

Also it didn't help to set automatic colour font, nor removing add-ins.

Workaround that helped was to drag e-mails from folder back to outlook folder,
then it worked - message appeared when hitting forward (or reply).

May 02, 2013

Default location for Windows Explorer

Problem: How to set up new location when opening Explorer shortcut?

Find Windows Explorer in Accessories, right click Properties,
add space and address to folder you'd like to be opened - instead of Libraries.

April 09, 2013

How to disable

Problem: Pop-up Microsoft start web page can't be removed when Internet Explorer opens

Solution is described here:

It helped to add DisableFirstRunCustomize in registry,
HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main
and put the REG_DWORD value as 1.

Can't create file: right click the folder you want to create

Problem: File attachment in Outlook can't be opened, there is "can't create" error

This web page helped:

Problem was caused by hidden OLK folder. The location of it can be found here:
registry - find; OutlookSecureTempFolder
once found, there is location to OLKxx folder,

find it via My Computer or Windows Explorer,
delete its contents.

February 28, 2013

IE opening Datasheet view error

Problem: "The list cannot be displayed in Datasheet view for one or more of the following reasons" error

This errror happened on Windows XP 32bit and IE8 with Office 2003.
Microsoft claims that it should run on 64-bit Windows with Office 2010 in order to function fine.
Source of the problem was installation of Visio 2010 and Project 2007 alongside with Office 2003.
Once both the Visio and Project were removed, page could display Datasheet view.

February 23, 2013

msi NVIDIA GeForce GT630 no picture

Problem: msi Graphics card has no output

Monitor was connected via analogue cable, somehow DVI was the default one, and monitor should be connected to DVI to instal the card, then switch primary monitor at display settings to make analogue active.

February 21, 2013

In Outlook 2010, PST as default doesn't work

Problem: PST file is set as default, however mails keep coming into mailbox

In Outlook 2010 it's not enough to set default PST,
there is an additional option for default delivery at
File - Account settings - drop down Account settings -
Selected account delivers new messages to the following location:
Change Folder
select PST file.

February 10, 2013

Linux Mint wireless network problem

Problem: Wireless network is connected, internet drops from time to time

Linux Mint 14 Nadia, it connects to router (ZTE) - wireless is connected all the time, also there are no driver problem(product: AR9485 Wireless Network Adapter , vendor: Atheros Communications Inc.), however, in random time, internet suddenly stops working. Even connecting to the wireless router is not possible during internet "blackout". And all of suddenly starts to work again, all by itself. Then drops again etc. At the same time, the internet is working fine on Windows PC.

Solution is - add static IP address.

That was temporary fix, fix was plugging to network cable.

January 30, 2013

Canon iR 1018 drivers for Windows7 not recognized

Problem: Canon iR1018 driver for windows 7 64bit cannot be installed

Installation was in two parts - one part was instaled by drivers provided by Canon web page.
However, second part - scanner - could not be instaled by any driver at Canon web page.
Solution was - to use drivers for XP, Vista.

Another problem is that Toolbox utility for scanner is not offered at drivers' Canon web page - it can be found via google.

Printer driver for iR1018/1022 series for WindowsXP/2003/Vista x64

January 29, 2013

This server's clock is not synchronized with the primary domain

Problem: PC is not accessible via network

Suuport web page says:
that this command will work;
w32tm /resync

User had no right to change time, time on the PC was 30 minutes late.
It helped to log on as administrator and to manually set the correct time.

January 18, 2013

Xerox 8550 yellow colour

Problem: Yellow colour is tinted on Xerox Phaser 8550

Problem was caused by difference in solid ink -- there is one with bright yellow colour which works ok, and the one which is darker - which was the source of the problem with yellow colour. As shown on pics within their package.