Are you saying removing only 1 of the 3 patches you mentioned above resolves the issue? I removed 2541025 and this alone did not do anything for me. However, removing both, 2509503/2541025 worked perfectly.
The MS Article states : http://support.microsoft.com/kb/2570623
After you install MS11-021 and the Office File Validation (OFV) Add-in for Office 2003 (KB 2501584), workbooks stored in a network location open slower over the network in Excel 2003 than they did without the OFV installed. The decrease in performance depends on the size of the workbook and bandwidth of the network and in some scenarios can seem to hang Excel.
The fix references 2501584 and 2502786 (MS11-021) (as highlighted in BOLD above). BUT does not say anything about:
What am I missing here?
Last edited by systematic; 04-08-2011 at 02:38 PM.
There were different solutions for this particular issue and many people solved it by removing different kind of KB security patches, as you can read from the thread mentioned in my previous post. In either cases, if it still doesnt solve your issue then you can contact microsoft from here - http://www.microsoft.com/worldwide/default.aspx
The registry modification works. I tested on a PC before I made the change to a user that was experiencing this exact problem. User is just sailing along with their Excel files now.
Finding this thread and the fix it suggests has just made my life so much easier... THANK YOU!
There's nothing worse than having a gang of angry end-users waiting for your to fix to an illusive problem so that they can get on with their work!
Some advice please guys.
Ok the registry fix does work in an ideal environment but not in mine.
My environment - Users do not have local admin rights and registry access from their limited accounts has been disabled via GPO.
Prior to applying the reg fix, I noticed all user accounts were having the problem including the local admin account. By problem I mean, Excel stalling when accessing a workbook over the network. After installing the reg fix whilst logged in as a local admin, the issue was resolved upon reboot for THIS ACCOUNT PROFILE ONLY.
The fix does not stick for all other accounts. When logged in as a limited user,
the issue is still there.
How do I get around this easily?
I can manually uninstall the 2 patches from a local admin profile but when you have 60 users complaining about the same thing, this method becomes a nightmare.
I was going to suggest writing a script which uses the RUNAS command to enable the users to run the fix in their profile as an administrator.
Unfortunately I tried this manually.. and it applies the fix to the administrator profile instead of the user that's logged-on :(
Luckily for me, the problem appears to be contained to users in the accounts department (who use 15MB Excel sheets!) so I fixed the problem manually on the accounts dept PCs:
- logged-on remotely to their PCs as an administrator
- Added them as a local PC administrator.
- logged-in as that user and ran the reg fix
- Logged back in as an administrator and removed the user's admin rights
I know it's long-winded, but that’s how I solved it on a small scale.
Another solution, albeit not very professional, is to create a temporary Admin group, add all of your 60 users into that group and set the reg fix to run under a Group Policy or a log-on script.
At the end of the day, most users won't realise they have admin privileges in the day it takes to roll-out the fix (you just have to make sure that you take a note of anybody absent from the office that day - their PCs won't be updated).
I appreciate that only applies to the individual profile, but it may be a useful stop-gap solution. I'd also be greatly interested in seeing how the fox can be globally applied to any user that logs-onto the account using the reg fix, (without removing the updates).
There is an small tip that you can try on this. I tried this and it really worked for me. I have a vpn connection setup where the lan files are extremely slow. To fix them out Run folder option and then click on View. In that you have to remove the tick from Automatically search for network printers and folders and then click on ok. Before doing that exit all your office applications. Then run excel and go in Tools > options. In General untick the file Recently use file list.
I had the same problems and just found out that the all stuff is due to another windows update called "file validation". There is an easy fix from MS at this address:
then you can reapply the security fixes for Excel
So the Ultimate Solution is:
Set to ZERO registry key:
If you don't have it, just create it, it's a DWORD.
No need for patch uninstalling and administrator privileges.
Thanks to all. :-)