Problem: Can't get rid of Research pane in Word
Tip from MS forum helped; press ALT R R
(yes, that is double R)
All Word toolbars will appear activated (display shortcuts), but annoying pane is removed this way.
October 07, 2017
July 12, 2015
ProgDVB doesn't show subtitles
Problem: Icon for subtitles is turned on, yet there are no subtitles displayed
Numerical values for subtitles display are set to low.
To correct this, go to:
Settings - options -Subtitles & OSD -
button under Subtitles -
values should be something like this:
5 - 399 - 633 - 150
See the pic below and notice a black border surrounding the example text for subtitles.
Black border must cover all text inside, otherwise it won't be shown.
With TV5 Monde and African, Indian TV now equipped with English subtitles, Rai TV with Italian for learners,etc etc.. it would be shame not to take use of subtitles and see the satellite TV world in full.
Numerical values for subtitles display are set to low.
To correct this, go to:
Settings - options -Subtitles & OSD -
button under Subtitles -
values should be something like this:
5 - 399 - 633 - 150
See the pic below and notice a black border surrounding the example text for subtitles.
Black border must cover all text inside, otherwise it won't be shown.
With TV5 Monde and African, Indian TV now equipped with English subtitles, Rai TV with Italian for learners,etc etc.. it would be shame not to take use of subtitles and see the satellite TV world in full.
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.
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.
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.
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;
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)
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:
http://www.adobe.com/products/flashplayer/distribution3.html
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
August 19, 2013
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:
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.
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.
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).
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?
http://panasonic.net/pcc/support/scanner/download.html
RTIV and basic drivers are enough:
panascan5606
rtiv57025_all_package
http://panasonic.net/pcc/support/scanner/download.html
RTIV and basic drivers are enough:
panascan5606
rtiv57025_all_package
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.
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
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.
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.
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 }
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 }
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
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.
(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.
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:
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
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
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"
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).
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).
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,
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
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
April 09, 2013
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.
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.
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.
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.
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.
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.
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.
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.
UPDATE:
http://software.canon-europe.com/software/0026726.asp
Printer driver for iR1018/1022 series for WindowsXP/2003/Vista x64
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
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:
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.
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.
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.
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.
December 08, 2012
Tune in PRO converting recording files
Problem: TuneIn PRO recorded files cannot be opened
Posts on the net suggest for users to simply add .mp3 as extension to the file name.
It doesn't work. Format factory recognized one of two files and converted it into mp3.
Posts on the net suggest for users to simply add .mp3 as extension to the file name.
It doesn't work. Format factory recognized one of two files and converted it into mp3.
December 07, 2012
Remote sessions cannot save settings in registry
Problem: Remote desktop can't be ticked
There is error message;
"The specified module could not be found"
Solution is to tick remote desktop via registry:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Serverset value to 0
http://www.windowstipspage.com/remote-desktop-terminal-services-how-to/
There is error message;
"The specified module could not be found"
Solution is to tick remote desktop via registry:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Serverset value to 0
http://www.windowstipspage.com/remote-desktop-terminal-services-how-to/
November 26, 2012
Unknown drivers Compaq nx9420
Problem: There are no drivers for Windows7 Laptop HP Compaq nx9420
There are no Windows7 drivers on official HP web page, Windows 7 instals most of the drivers, and after Windows Update there are 2 unknown drivers left:
Mass Storage Controller and PCI Simple Communications Controller
Windows offered driver - not through automatic updates but via Action Center - Messages.
Missing drivers were both from one source: Texas Instruments Cardbus Driver, sp43509.exe media card reader
There are no Windows7 drivers on official HP web page, Windows 7 instals most of the drivers, and after Windows Update there are 2 unknown drivers left:
Mass Storage Controller and PCI Simple Communications Controller
Windows offered driver - not through automatic updates but via Action Center - Messages.
Missing drivers were both from one source: Texas Instruments Cardbus Driver, sp43509.exe media card reader
November 15, 2012
Hyperlink in Office 2007 doesn't offer all pages
Problem: Probably due to continuous break there are no pages outside break for hyperlink selection.
Workaround is to create bookmark on desired page and then insert hyperlink with this new bookmark(s).
http://support.microsoft.com/kb/291182
In Office 2007, select title you want to be linked,
in Insert tab, Action group, click Bookmark,
create a new name - which will be visible only in Hyperlink option, name should not contain special characters,
and this bookmark will now appear when creating hyperlinks.
Workaround is to create bookmark on desired page and then insert hyperlink with this new bookmark(s).
http://support.microsoft.com/kb/291182
In Office 2007, select title you want to be linked,
in Insert tab, Action group, click Bookmark,
create a new name - which will be visible only in Hyperlink option, name should not contain special characters,
and this bookmark will now appear when creating hyperlinks.
November 06, 2012
Outlook 2003 can't be opened
Problem: Error message while opening Outlook 2003; "Cannot start Microsoft Office Outlook. Unable to open the Outlook window. The set of folders could not be opened."
Outlook shows only this message, Outlook cannot be opened.
Via Control panel - Mail - find PST options for add and remove PST:
Problem was resolved by removing one PST (with its location in default folder) - it was cut/paste to another partition on disk. Outlook worked with that pst file added back again - from that new location. User had many pst files, all other pst were on
Outlook shows only this message, Outlook cannot be opened.
Via Control panel - Mail - find PST options for add and remove PST:
Problem was resolved by removing one PST (with its location in default folder) - it was cut/paste to another partition on disk. Outlook worked with that pst file added back again - from that new location. User had many pst files, all other pst were on
October 26, 2012
Asrock Z68 Pro3 Gen3 graphics adapter driver
Problem: Asrock Intel Series Z68 Pro3 Gen3 can't instal graphic's driver
Driver found on original Asrock Cd or Asrock Web page didn't help, there is an error message "minimum requirements". Windows Update found driver and instal it without problem.
Unknown device (ACPI properties) can't be instaled - workaround is disabling option in BIOS:
Advanced - Intel(R) Smart Connect Technology - Disable it.
Driver found on original Asrock Cd or Asrock Web page didn't help, there is an error message "minimum requirements". Windows Update found driver and instal it without problem.
Unknown device (ACPI properties) can't be instaled - workaround is disabling option in BIOS:
Advanced - Intel(R) Smart Connect Technology - Disable it.
October 16, 2012
Lenovo G565 model 20071 Unknown device
Problem: There is unknown driver although all drivers were installed from Lenovo web page
Right click directs to ACPI as property for unknown driver.
Solution is here:
http://forums.lenovo.com/t5/Lenovo-3000-and-Essential/ACPI-VPC2004-Unknown-Device-Lenovo-g560-windows-7-pro-x64/td-p/205909
Unknown driver was actually utility - "Energy management".
Right click directs to ACPI as property for unknown driver.
Solution is here:
http://forums.lenovo.com/t5/Lenovo-3000-and-Essential/ACPI-VPC2004-Unknown-Device-Lenovo-g560-windows-7-pro-x64/td-p/205909
Unknown driver was actually utility - "Energy management".
October 04, 2012
LSM-100 has no OpenGL on Windows8
Problem: LG Mouse scanner is not working on Windows 8
Installing drivers for LSM-100 reports error at start that OpenGL is not found.
Windows8 Enterprise installed drivers for Nvidia GeForce 9600 GT however these are not sufficient for mouse scanner LSM-100.
Installing the newest drivers for Nvidia graphic's card solved the problem and scan works on Windows 8.
Installing drivers for LSM-100 reports error at start that OpenGL is not found.
Windows8 Enterprise installed drivers for Nvidia GeForce 9600 GT however these are not sufficient for mouse scanner LSM-100.
Installing the newest drivers for Nvidia graphic's card solved the problem and scan works on Windows 8.
September 25, 2012
HP2311x resolution not accepted
Problem: There is notification "set resolution 1920x1080" however you can't select it in display settings screen resolution
Problem was old graphics card - it was onboard card. Shows messages as "Input signal out of range" and "change settings to 1920x1080". However, the only resolution that was possible for HP2311x monitor to show on this old video card was 1280x1024. Otherwise it was either black screen or stretched screen.
Resolution is to buy a new video card -
for example for AGP slot - Ati Radeon HD 3450
or PCIe - Asus GT4400.
Problem was old graphics card - it was onboard card. Shows messages as "Input signal out of range" and "change settings to 1920x1080". However, the only resolution that was possible for HP2311x monitor to show on this old video card was 1280x1024. Otherwise it was either black screen or stretched screen.
Resolution is to buy a new video card -
for example for AGP slot - Ati Radeon HD 3450
or PCIe - Asus GT4400.
September 18, 2012
Excel move/copy sheet error
Problem: In Excel 2003, only the first 255 characters in each cell are copied.
Excel has limitied number of characters it can move to another worksheet, it reports this error when moving it:
The sheet you are copying has cells that contain more than 255 characters.
only the first 255 characters in each cell are copied.
To copy all of the characters, copy the cells to a new sheet instead of copying the entire sheet.
User should have in mind to limit contents of cells or when moving to another worksheet,
it will be copied only via selecting the whole sheet and simple copy-paste to another worksheet.
However, format will not be as original.
Excel has limitied number of characters it can move to another worksheet, it reports this error when moving it:
The sheet you are copying has cells that contain more than 255 characters.
only the first 255 characters in each cell are copied.
To copy all of the characters, copy the cells to a new sheet instead of copying the entire sheet.
User should have in mind to limit contents of cells or when moving to another worksheet,
it will be copied only via selecting the whole sheet and simple copy-paste to another worksheet.
However, format will not be as original.
August 13, 2012
Run-time error '1004' Application-defined or object-defined error
Problem: In Excel 2003 and 2007 when button is clicked, there is this Visual basic error '1004'
Problem is not the code/macro as suggested on numerous web forums because this error didn't appear on other computers.
Problem was caused by local settings - instead of the language set in the computer (Croatian) - it was set to English (as shown on picture) and somehow Visual basic couldn't run normally. After setting the right language and restart, it worked ok, no error.
Control panel - Regional and Language options -
Advanced - Language for non-Unicode programs
Select a language (same as for the other options)
Problem is not the code/macro as suggested on numerous web forums because this error didn't appear on other computers.
Problem was caused by local settings - instead of the language set in the computer (Croatian) - it was set to English (as shown on picture) and somehow Visual basic couldn't run normally. After setting the right language and restart, it worked ok, no error.
Control panel - Regional and Language options -
Advanced - Language for non-Unicode programs
Select a language (same as for the other options)
July 19, 2012
Insert copied cells not available in Excel
Problem: There is no "insert copied cells" option in excel
It was not available because some columns were hidden.
Unhide and then it worked ok.
It was not available because some columns were hidden.
Unhide and then it worked ok.
July 12, 2012
Setting path for Java in command prompt of Win7
Problem: Typing javac in command line produce error "'JAVAC' is not recognized as an internal or external command, operable program or batch file"
To verify java version from windows you need to type javac -version in command prompt - but first set path as explained at:
http://www.java.com/en/download/help/path.xml
System Properties - Advanced system settings > Advanced tab - Environment Variables, under System Variables, find PATH
adding the location (where JDK was installed).
There should be no space between other text already in path, path should look like this;
C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Lenovo\Bluetooth Software\;C:\Program Files\Lenovo\Bluetooth Software\syswow64;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Java\jre6\bin;C:\Program Files\Java\jdk1.7.0_02\bin
To verify java version from windows you need to type javac -version in command prompt - but first set path as explained at:
http://www.java.com/en/download/help/path.xml
System Properties - Advanced system settings > Advanced tab - Environment Variables, under System Variables, find PATH
adding the location (where JDK was installed).
There should be no space between other text already in path, path should look like this;
C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Lenovo\Bluetooth Software\;C:\Program Files\Lenovo\Bluetooth Software\syswow64;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Java\jre6\bin;C:\Program Files\Java\jdk1.7.0_02\bin
June 30, 2012
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
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)
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)
June 23, 2012
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).
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.
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.
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.
June 12, 2012
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%.
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.
Viruses caused the problem.
Malwarebytes quick scan found them and once removed, internet worked ok.
June 06, 2012
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
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
Subscribe to:
Posts (Atom)