Excel 2003 Slow Opening From Network Share

Recently a user was having issues opening excel files , were by a 600kb file could take around 20 seconds to open. When you copied this file locally to the computer it opened it straight away , and other computers accessing the file had no problem. What I did notice was when you opened the file , the network usage would spike to 7mb/s for the entire time while only retrieving a 600kb file. Opening .pdf / .doc files around double or triple the size would open instantly A bit of research online only proved the fault/fix with a Windows 7 setup accessing office 2003 documents http://support.microsoft.com/kb/982860 I tried the “Under the registry entry, disable these two registry keys: Right-click Enablesecuritysignature, and then click Modify. Type 0 in the Value data box and then click OK. Right-click Requiresecuritysignature, and then click Modify. Type 0 in the Value data box and then click OK.” However no success , my setup however was Windows XP and Office 2003. After much searching the fix was actually pretty recent from microsft http://support.microsoft.com/kb/2570623 “reduces performance due to the network traffic when reading in the parts of the workbook” So upgrade to 2007/2010 or disable OFV!

You can perform the below fix manually , or I have create a .re file which does it http://www.pariswells.com/upload/fix.zip

You can use the EnableOnLoad registry entry to configure how you want Excel to handle opening workbooks for the OFV. By default, the EnableOnLoad entry is not present in the Windows registry. To add the EnableOnLoadentry to the Windows registry, follow these steps:

1. Exit Excel.
2. Click Start, click Run, type regedit, and then click OK.
3. Locate and then click to select the following registry key: **EDIT** Thanks to Frank in the comments , the proper key is ” HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\11.0″ Old key “HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\”
4. After you select the key that is specified in step 3, point to New on the Edit menu, and then click Key.
5. Type Excel, and then press ENTER.
6. Select Excel, point to New on the Edit menu, and then click Key.
7. Type Security, and then press ENTER.
8. Select Security, point to New on the Edit menu, and then click Key.
9. Type FileValidation, and then press ENTER.
10. Select FileValidation, point to New on the Edit menu, and then click DWORD Value.
11. Type EnableOnLoad, and then press ENTER. Note: The default value is 0 which disables the validation.
12. On the File menu, click Exit to quit Registry Editor.

Tags: .xls slow from network share, 2570623, Excel 2003 slow to open network, Excel Slow Opening From Network Share, High Network Usage Office 2003, OFV, The Office File Validation, Windows XP Excel 2003 slow opening

WordPress WP-Admin Folder Not Parsing PHP

I moved an existing wordpress site from one server to another. After initial complications of getting the “White Screen of Death” of nothing showing this was caused by the MySQL being on another server instead of localhost. It should of given me a SQL error but for some reason it didn’t show!

Next issue was when I tried to get into the admin control panel on domain.com/wp-admin/ the webserver started serving pages as the raw php files for me to download instead of parsing them in the browser. I checked the folder permissions which the same as the server before. I tried copying a phpinfo.php file ( to check if it was a wordpress issue) but it wouldn’t even parse that! I created another folder and copied the phpinfo.php into there to try and it worked. I then copied all the wp-admin files into the new folder , renamed it to wp-admin after deleting the old folder and it worked!

Tags: wordpress not parsing wp-admin folder, wordpress white screen, wp-admin

IIS Windows 7 AppOffline DefaultAppPool

After installing IIS 7 on a windows 7 SP1 machine , upon trying to view http;//localhost/ default ISS7 page the following error popped up :

“service unavailable 503″

After logging into IIS Manager , the DefaultAppPool was in a stopped start. I renabled this and tried again , however upon trying to view the localhost default IIS webpage again , the DefaultAppPool went back to Stopped state.

Checking the event log brought back the following error

“The Windows Process Activation Service failed to create a worker process for the application pool ‘DefaultAppPool’. The data field contains the error number.”

I right clicked on the DefaultAppPool in the Application Pool menu, under advanced settings/process model changed the Identity to “LocalSystem”. I started the DefaultAppPool up again and it worked

 

Tags: DefaultAppPool, ISS 7, service unavailable 503, The Windows Process Activation Service failed to create a worker process for the application pool 'DefaultAppPool'. The data field contains the error number.

WinWord 2010 Opening Document usp10.dll Crash

Upon opening a document with Word ,  Winword crashes straight away.

I tried the main fixes of resetting the Normal.dot + normal.dotm files and opened the Winword in safe mode ( Winword /a). But the problem still continued. After further investigation usp10.dll was the DLL causing the issue , and some online research it stated Helvettica Font was to blame. I removed the problem font from C:\Windows\Fonts and Word opened straight away. It looks like this problem also exists in Outlook

Microsofts Post on the Problem : http://support.microsoft.com/kb/2119612

Tags: usp10.dll Crash

Windows 7 Date Format Showing as US MM/DD/YYYY instead of UK DD/MM/YYYY

A new Asus computer out the box had been setup with the region settings of English (United Kingdom) , however in some .net programs the date format still showed as English (United States)

This looks like a common problem with some Windows 7 Sysprepped Machines. To reset the date do the following

• Control Panel
• Region and Language
• Change the Format to anything else but English (United Kingdom)
• Click Apply
• Change the Format back to English (United Kingdom)

This should fix the problem

Tags: Windows 7 Date Format, Windows 7 Date Format UK, Windows 7 Date Format US

DYMO Label Software has stopped working

I had a Dymo 400 Label Machine which was working fine on a Windows 2008 Terminal server using the 7.8 Software. A Dymo Label 450 Turbo label machine was purchased which needed installing on the same terminal server. 7.8 Version of the software does require an update for it to work with a 450 Turbo Printer which is here After installing the version 8.3 software on the server , upon launching the program the following message was displayed “DYMO Label Software has stopped working” To install the 8.3 software on a 2008 Terminal Server you need 3.5  .Net Framework instructions here . After installing this the program ran fine.

Tags: Dymo 400 Label Machine, Dymo Label 450 Turbo, Windows 2008 Terminal

SBS 2008 and Blackberry Internet Service

Recently I was trying to activate a blackberry using Blackberry Internet Serivces ( BIG )  on a new Small business server 2008 Box. I went through the normal settings of Username : domain\username Password : password Webmail Address : https://mail.domain.com/owa Mailbox : username However the server address could not be verified, I checked the link and tried to login as the user through webmail and logged me in fine. I then tested the server through the EWS ( Exchange Web Services )  by trying to log the user in via https://mail.domain.com/ews using the same username and password. This did not let me in which would explain why the blackberry wasn’t validating. A server reboot did not fix the issue so ran “iisreset /noforce” which fixed the issue and allowed me to validate the email , however it seemed to go back to its old ways 30 Minutes later I downloaded Update rollup 10 installed an rebooted into the server , and seems to have rectified the issue

Tags: Blackberry Internet Service, Exchange Web Services, SBS 2008, Update rollup 10

Lupdate Mfc Application – Has Stopped Responding

A computer running Windows Vista had the error message “Lupdate Mfc Application Has Stopped Working” appear on every startup. Google results suggested the computer was infected by spyware , but after a scan with malware bytes and Microsoft Security Essentials , there was no sign of any infection. Further searches showed that Printer Programs could be the issue. I used MSconfig Startup Options to remove the Samsung Printer Control panel and restarted the computer. This fixed the issue. Further diagnostics prove that is could be a program called “openwares liveupdate” If removing the printer software from startup did not fix the issue

Tags: Lupdate Mfc Application

Outlook Webmail Shows Red Cross on New Message Content Text Box

When going into Microsoft Exchange via Webmail and Internet Explorer and opening a New Email to compose , the text area where you enter the content of the message displays as a Red Cross. This only happens in Internet Explorer and not other browsers such as firefox, reports show this is a problem with internet explorer and the solution is to install the S/MIME install manually: The Solution: 1. In OWA, click on the “options” in the left Task Pane. 2. Under “E-mail Security” and Click Install or Upgrade the S/MIME Control. This will download a new add-on. 3. Click “RUN” when asked about the Microsoft Outlook Web Access S/MIME install and security warning. 4. Restart IE ( Computer does not need restarting ) However installing this fixed the problem , but when sending or closing the box it crashed Internet Explorer. This KB article described the issue http://support.microsoft.com/?kbid=924334 However I did not have access to the exchange server , I did login to another exchange server which had been updated and downloaded the latest setupmcl.exe which can be downloaded here: http://filevo.com/i3gmicvqvhvs.html After installing this , it fixed both problems!

Tags: Outlook Webmail Shows Red Cross on New Message Content Text Box, setupmcl.exe, Upgrade the S/MIME Control

Activation error. Digital signature is either missing or corrupted

After installing Kapersky Antivirus from fresh and trying to activate the product with a Key file , it came up with the following error “Activation error. Digital signature is either missing or corrupted” I redownloaded the key file and it still brought up the message. After looking on Kav Knowledge base , and looking to check if the Ask toolbar was installed (which it wasn’t). I unistalled Kapersky , Restarted the Computer and rinstalled. This resolved the problem!

Tags: Activation error. Digital signature is either missing or corrupted