angelic_webmaster
asked on
Normal.dot file corrupted? Or Slowing MS Office 2003 down
Here is my problem - everytime we open our Microsoft Office 2003 it takes foreever we have a ton of macros attached to our Normal.dot file. Could this be the issue? Any suggestions?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am trying to redo the entire Normal.dot file. Is there any other way?
This happens to Word Normal templates, they grow and grow until they start slowing everything down. If you only have macros in it, I would suggest exporting all the macros - from the VBA editor right click on the module name and choose Export. Then close Word and delete or rename normal.dot. Reopen word and import the modules back into the newly-created normal.dot, then save it. You'll find the size is way smaller and everything should be ok.
If you have other stuff like autotext entries in there that you want to keep, you may also need to copy these back using the Organiser, but most people don't have this.
If you have other stuff like autotext entries in there that you want to keep, you may also need to copy these back using the Organiser, but most people don't have this.
I advocate to resist placing macros in the Normal.dot template because Normal is the template used for every document I might ever create. The procedures likely to be added to it are much more selective. Some of them may be required for letters, others for notes, invoices, reports, minutes, or whatever.
Accordingly, I would advocate creating individual templates for letters, others for notes, invoices, reports, minutes, and whatever, each with its own VB procedures. Limit Normal only to Styles.
Yes, that would require a complete overhaul of Normal, but that was long, long overdue, and the advantage in productivity you will gain is quite substantial because once you have separate templates for letters, others for notes, invoices, reports, minutes, and whatever you will be able to apply formatting and many, many other features which will greatly reduce the time required to create those documents.
Accordingly, I would advocate creating individual templates for letters, others for notes, invoices, reports, minutes, and whatever, each with its own VB procedures. Limit Normal only to Styles.
Yes, that would require a complete overhaul of Normal, but that was long, long overdue, and the advantage in productivity you will gain is quite substantial because once you have separate templates for letters, others for notes, invoices, reports, minutes, and whatever you will be able to apply formatting and many, many other features which will greatly reduce the time required to create those documents.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Agree with andrewssd3...
Export the modules to a clean template. If there are a lot of modules you might want to use the organiser. ALT > t > i
Export the modules to a clean template. If there are a lot of modules you might want to use the organiser. ALT > t > i
ASKER
Ok, I am going to try the clean Template - and if this does not work I will clear the Registry. I will let you all know what happens.
Did you read my comment?
ASKER
Hi Davis
Trying this now as we speak before going the longer way
Trying this now as we speak before going the longer way
by: DavisMcCarnPosted on 2013-09-21 at 05:48:15ID: 39511546
The Office File Validation Tool is known to cause horrendous performance problems in numerous networking environments. I had spreadsheets taking 20 minutes to load that had been 3 seconds! Because it will be reinstalled as part of the Windows Updates, the correct answer is to disable it.
Either Copy and paste this into a Disable-Office-Validation.reg file or create the key using RegEdit:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Policies \Microsoft \Office\11 .0\Word\Se curity\Fil eValidatio n]
"EnableOnLoad"=dword:00000000
ASKER
ASKER
From speaking to my friend it seems we have been moving over the macros without a problem, but the auto corrects are now missing - could this be an issue? And what do I need to do?
It needs to be a Dword entry not a Qword. Delete the erroneous one, create it as a Dword, and reboot.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok so I removed most of the macros and redid all of the autocorrects one by one. Works great in MS Office (Word) but is not showing in Outlook 2010. Help
ASKER
I was researching and it looks like Outlook uses a different dotm file? How can I add in these autocorrects here to Outlook 2010 to use the same ones as from Word 2010.
ASKER
Ok, update -I figuredi out the autocorrect for Office 2010 and Outlook 2010. They use two different files, so I just made the NormalEmail.dotm the copy of the Normal.dotm.
Only issue I see now is everything is taking longer to open again - very little or no macros. Was running fine earlier - think my friend added something else. File size on the Normal.dotm is now 979 kb. When I finished earlier it was half - then I took a nap woke up and it is later now.. thoughts? How can I make it so Work and Outlook open a little quicker?
Only issue I see now is everything is taking longer to open again - very little or no macros. Was running fine earlier - think my friend added something else. File size on the Normal.dotm is now 979 kb. When I finished earlier it was half - then I took a nap woke up and it is later now.. thoughts? How can I make it so Work and Outlook open a little quicker?
ASKER
It was bad macros and the Normal.dot
ASKER
Not sure how to do what Tmoore1962 said.
It is version MS Word 2003. I opened the Normal.dot in my 2007 version and it seemed to be ok. Could just one macro be corrupted. The file is 6 mb.