Pictures don't show up in Windows7

Problem: In folder My Pictures, pictures have no display image, only default icon instead

Start - Control panel - System -
Advanced System settings (AKA System properties) -
Advanced - Settings - Visual effects at Performance options:
Show thumbnails instead of icons
uncheck it - apply - and then check it again -ok


http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/pictures-do-not-display-as-thumbnail-preview/f0c429b7-d7dd-4535-a8e7-c3f5e8c42939

How to sum a cell with another cells in different worksheets

Problem: To sum cells from another sheets in Excel

 Formulae for the example shown on picture is:
=SUM(A1;+February!A1;+March!A1)

to sum sheets named after months- in this example with cells to be summed are found at A1 address, and result to be displayed in first sheet (that's why it's called A1 - it doesn't have January in name)

If we want sum to be displayed in new sheet, the same formulae would be:
=SUM(January!A1;+February!A1;+March!A1)

or with cells we want to calculate are found at A1:
=SUM(name-of-the-first-sheet!A1+name-of-the-other-sheet!A1)

Word - removing extra page

Problem: Microsoft Word - The last (blank) page can't be removed

In this instance, blank extra page at the end of document appeared because user tried to delete last line on the first page - which didn't do anything.
The cause of annoying extra page was between cells (as showed on picture). Positioning cursor at the right spot between cells and hitting del key here removed that extra page (but also joined two tables together).

Printer Samsung ML-2851 behaving erratically

Problem: ML-2851 when shared on the network blocks users randomly

Problem were drivers on Samsung web page.
It was solved by deinstaling printer drivers on all infected PCs. (Windows XP: also by removing Control Panel - Printers - File-Printer settings - Remove ML2851 drivers here also). And then drivers were installed by using drivers CD.
Web page by Samsung offers only universal drivers which cause problems.

Windows XP freeze after login

Problem: A few seconds after entering Windows, it freezes completely

Safe mode (press F8 after turning on PC) works ok, it helped to scan PC, there were various viruses.
Combofix, online scan - nothing helped. Repair also produced freezing - at 34th minute of repair-
problem was solved by formating PC.

HP ProBook 4710s after reinstal is at 100% CPU

Problem: Laptop 4710s is very slow before and after reinstal (format C), CPU at 100% when plugged

It was power managment in Windows 7 - it slows down the laptop;
http://h30434.www3.hp.com/t5/Notebook-Lockups-Freezes-Hangs/100-CPU-Usage/td-p/200791/page/3


Quick solution is to unplug the power, to finish all instalation.
Safe mode works without interruption.

This didn't help at all:
Power options - HP Optimized selected, or if choose Power saver - it goes back to CPU 100% usage.
Options - Processor power management - lower than 100%, CPU usage still high.
Screen birightness - Windows mobility - Display Brighness - to 50%.

Mobile internet connects but no web page

Problem: Connection to Mobile network works however nothing displays over IE or Firefox

Viruses caused the problem.
Malwarebytes quick scan found them and once removed, internet worked ok.

In Outlook2010 link in a message is not working

Problem: After user clicks on a link in an Outlook message there is an error

Error is:
This operation has been canceled due to restrictions in effect on this computer.
Microsoft web suggest that IE settings should be reset - this didn't help.
However, their "Microsoft Fix it 50388" solved the problem.
http://support.microsoft.com/kb/310049/en

Excel rows and columns appear at the right

Problem: Document in excel received from arabic country

Tools - Options - International
uncheck option "View current sheet right-to-left"

How to print BCC from Microsoft Outlook 2003

Problem: User needs hard copy of sent mail in BCC field

http://www.msoutlook.info/question/5
Open e-mail you want to print,
Tools - Forms - Design this form (this will not appear if you open it from Outlook menu itself)
From Field chooser select from drop-down menu "Address fields"
and then drag BCC to e-mail , below CC.
Then right-click BCC - Properties - and in Validation tab, check the option "Include this field for Printing..."
Save, close and then BCC will appear when printing this mail.

Excel forumula, enter data then a letter appears in another cell

Problem: How to enter a letter in one cell and another cell displays a number (or any character) corresponding to entered data?

cell K3 needs this forumulae;
=IF(G3="D";1;0)

cell L3 needs this forumulae;
=IF(G3="N";1;0)

So, user will enter D or N in cell G3
and in the same time cell K3 will display 1, and L3 will display zero.
If user enters some other letter than D or N, both cells will display 0.

Signature doesn't appear/is blank

Problem: Microsoft Outlook signature can be written in yet not displayed

The name of signature must not contain dot.
(for example "signature.name" is wrong, "signaturename" is ok)
If the name contains dot, there will be no error while creating signature, however it will not appear in e-mail.
This problem was found locally, it's not universal - other windows alllow dots in the signature name.

Paper tray can't be pulled out

Problem: Samsung ML-2851 paper tray got stuck

2 plastic hooks at the back of printer got hooked to rear side.
It can be pressed, push upward and thus released in its normal position.
Normally, there is plastic protection on place where tray get hooked upon.

Microsoft Office Document Scanning not showing multiple pages

Problem: There is "corrupt" message on additional pages when scanning with Miscrosoft scan and pages don't appear

Problem was program opening scaned image -
it was Microsoft Office Picture Manager.
Once the default program is changed to Windows Picture and Fax Viewer and program closed,
all pages appeared.

Some e-mails can't open in Outlook 2003

Problem: "The text formatting command is not available. it may not be installed"

Reinstaling Office 2003 didn't help.
Re-instaling IE8 helped (as suggested by Microsoft web).

Docking station

Problem: First use of docking station - how to mount notepad

First move the plastic grip (L shape) all the way up, so notepad can fit without interruption.
Then, connect the parts of notepad with the docking station, they can't go wrong way. Press so that notepad sits in the docking station.
Then move the plastic grip so it can dock the notepad in its place, so the next mounting can go easier.

CONVERT excel formula is not working

Problem: Excel refuse to accept formula for Convert

Formula found in a book or on web site is:
=CONVERT(A1*5280, "ft", "m")/1000

or
=CONVERT(1.0, "lbm", "kg")

It should contain semi-colon (;) instead of virgola (,) in order to work:

=CONVERT(A1*5280; "ft"; "m")/1000

Also, if NONAME appears, as help on Microsoft web page suggest - Analysis pack should be instaled, that is, it should be selected in Tools - Add-ins - Analysis Tool-pak

http://office.microsoft.com/en-us/excel-help/convert-HP005209022.aspx?CTT=5&origin=HP003056127

Office 2007; Chart doesn't appear when no network

Problem: Only in Office 2007 a chart doesn't display, also printers are unavailable when no network present

In office 2003 everything works fine,
but in Office 2007 chart doesn't appear when network cable is disconnected. It turns out as grayed out, blank with background colour, with no selections available (as shown in picture). Also when there is no network, all printers or even print preview is unavailable - including pdf makers, local printers, network printers... Word works ok, this problem appear only in Excel.
Chart is displayed with no problem when network is connected and all printers are available when network cable is connected.

Problem was the default printer:
Microsoft XPS Document Writer

Once some other one was selected as the default one, everything worked fine.

System error &H80004005 (-2147467259)

Problem: After Office 2007 reinstal there are multiple errors

Excel options - Resources - run Microsoft Diagnostics

Change default balloon size in Word 2003/2007

Problem: Where is option for default font size for commentary?

Office 2007:CTRL + ALT + SHIFT + S
Manage Styles - Select order - Alphabetically
Balloon - Mofify - select New document..

Ofice 2003:
Format - Styles and Formatting -
Show: Custom - Style - All style -
Balloon - Modify

HP Laserjet 6500A problems

Problem: HP Laserjet 6500A refuse to scan, then it makes a partial copy

Software installed on Windows7 from official CD for HP Laserjet 6500A results in on screen message
hp scan application cannot detect the ocr software
Problem probably begun because software was installed without printer physically connected to PC during instalation (there is an option to continue without connection). And problem was solved by unistaling and re-instaling the software.
However, once windows are in shut down, then started again, it should be linked every time, PC to printer, via HP 6500 software. This didn't happen on Windows XP.

Second problem, as a copier, results on only part copy and error message that paper size doesn't match. It was solvbed by firmware update on HP web page for HP Laserjet 6500A. Update itself was easy - click and run.

No adapter in device manager

Problem: No network on Asus P5GD1-VM/Vintage motherboard, Windows Xp

Didn't help:
checking BIOS options for onboard network card - it was enabled
instaling another network card
cmd - netsh commands
Microsoft fix it
uninstal antivirus sw
repair windows

It was solved by taking HDD out from the case and placing it in new PC with the same type of motherboard.
Obviously problem was in faulty motherboard, not virus, software or Windows-related. Somehow it banished all network possibilities. However, network worked fine via USB network adapter.

Setup is being restarted...

Problem: XP is in the loop after repair XP option

Disabling I/O units and various cards in BIOS didn't help. Nor exploring setup logs with SHIFT + F10 option
http://www.windowsbbs.com/windows-xp/100569-xp-home-repair-now-stuck-setup-being-restarted.html

Problem was solved by using Windows XP SP1 instalation CD, instead of the one with SP3.

Invitations are not arriving in Inbox on Outlook

Problem: Appointment/Scheduling, meeting requests are sent and marked as delivered at sender's sent items, however they do not appear in Inbox

Person who receives invitations had a delegate and all appointments and invitations ended up at the delegate's mail.

Remove delegates option or delegate itself to solve this problem:
Tools - Options - Delegates

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.

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

Warning: IllegalMediaSize

Problem: Excel document prints partialy

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

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)

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.

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

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.

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.

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

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.

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)

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

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

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.