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.

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.

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.

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;

=SUBTOTAL(9,D6:D82)

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

=SUBTOTAL(109; A1:A5)

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:

http://www.adobe.com/products/flashplayer/distribution3.html

Remote desktop shortcut

Problem: How to quickly open Remote Desktop Connection

Windows button + R
mstsc - OK

Excel 2003-2007-2010 crashes when opening up

Problem: Excel document opens only after recovery

This problem is connected with previous post:
http://pcproblemi.blogspot.com/2009/04/excel-20032007-crash-during-closing.html

The same solution helped - in registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins

 BtOfficeAddin.NtOfficeIntegration.1
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.

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

Drivers for Panasonic s3065c

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


http://panasonic.net/pcc/support/scanner/download.html

RTIV and basic drivers are enough:
panascan5606
rtiv57025_all_package

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.

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

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
http://wordprocessing.about.com/od/usingmailmerge/qt/NPFSwitch.htm

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

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

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

http://office.microsoft.com/en-001/word-help/add-or-remove-headers-footers-and-page-numbers-HA010372690.aspx

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

NumPages is total number of pages.

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:
HKEY_CURRENT_USER\Software\Microsoft\Office
HKEY_LOCAL_MACHINE\Software\Microsoft\Office
To:
HKEY_CURRENT_USER\Software\Microsoft\xOffice
HKEY_LOCAL_MACHINE\Software\Microsoft\xOffice


http://community.office365.com/en-us/forums/172/t/8334.aspx

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"
https://getsatisfaction.com/mozilla_messaging/topics/forward_message_message_body_text_missing

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

Default location for Windows Explorer

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

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

http://www.pcworld.com/article/239258/win_ex_default.html

How to disable http://go.microsoft.com/fwlink/?LinkID=191285

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

Solution is described here:
http://www.geoffchappell.com/notes/windows/ie/firstrun.htm

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:
http://msmvps.com/blogs/steveb/archive/2007/08/24/can-t-open-or-save-an-attachment-in-outlook-2003.aspx

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.

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.

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.

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.

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.

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.

UPDATE:
http://software.canon-europe.com/software/0026726.asp
Printer driver for iR1018/1022 series for WindowsXP/2003/Vista x64

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

Problem: PC is not accessible via network

Suuport web page says:
http://support.microsoft.com/kb/307897
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.
 

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.