Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-21-2015, 12:41 PM
BethA BethA is offline Missing Macros after upgrade to 2016 Windows 10 Missing Macros after upgrade to 2016 Office 2016
Novice
Missing Macros after upgrade to 2016
 
Join Date: Dec 2015
Location: NJ, USA
Posts: 3
BethA is on a distinguished road
Default Missing Macros after upgrade to 2016

Microsoft pushed an upgrade out in updates this past weekend.
After my system applied the updates all of my macros that I use in Word are gone. I did have to reenable macros after opening Word the first time but when I pull up the macros dialog box it is completely empty.
When I checked the start up folder there is no macros file.
I contacted the Microsoft Answer Line and they told me that I had to contact Microsoft Tech support. Microsoft Tech support won't even open a ticket without my credit card so they can charge me $499.00.
Has anyone else had this problem? And more importantly, has anyone figured out a fix or where Microsoft might (please dear god) have saved a copy of the old macros before updating?
Reply With Quote
  #2  
Old 12-21-2015, 01:06 PM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is online now Missing Macros after upgrade to 2016 Windows 7 64bit Missing Macros after upgrade to 2016 Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,907
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

What you describe is a known issue. In the User Templates folder, look for a template called Normal15Pre.dotm or Normal.dotm.old (whatever the exact name, the time stamp will be the day the updates were installed); it will be a renamed version of your old Normal template. Rename the file that is currently called Normal.dotm and then change the name of the new template back to Normal.dotm.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #3  
Old 12-21-2015, 04:26 PM
BethA BethA is offline Missing Macros after upgrade to 2016 Windows 10 Missing Macros after upgrade to 2016 Office 2016
Novice
Missing Macros after upgrade to 2016
 
Join Date: Dec 2015
Location: NJ, USA
Posts: 3
BethA is on a distinguished road
Default

Thanks for the quick response Stefan.
Unfortunately both files (the normal.dotm and normal.dotm.bak) were blank. I think this might be due to something our IT did while trying to fix this as I did see him change the names of files.
I'll be retyping macros from now to June.
thanks again
Reply With Quote
  #4  
Old 12-21-2015, 04:30 PM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is online now Missing Macros after upgrade to 2016 Windows 7 64bit Missing Macros after upgrade to 2016 Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,907
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

Are there any files (in the User Templates folder) with names similar to "Normal"? It might be worth opening each of them and see what comes up...
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #5  
Old 12-22-2015, 08:44 AM
BethA BethA is offline Missing Macros after upgrade to 2016 Windows 10 Missing Macros after upgrade to 2016 Office 2016
Novice
Missing Macros after upgrade to 2016
 
Join Date: Dec 2015
Location: NJ, USA
Posts: 3
BethA is on a distinguished road
Default All Files checked

Stefan,
There was a normal.dotm, a normal(2).dotm, and a normal.dotm.bak file but all were empty. I had at one time converted all my macros to a word doc and I was able to copy and paste those in but I hadn't updated that doc in a while. That won't happen again.
I have purchased a backup from seagate. Will that back up my macros or should I stick with my low tech copy and paste backup? Hopefully this will never happen again but I would like to be prepared this time.
Thanks!
Reply With Quote
  #6  
Old 12-22-2015, 11:50 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is online now Missing Macros after upgrade to 2016 Windows 7 64bit Missing Macros after upgrade to 2016 Office 2013
Moderator
 
Join Date: Aug 2011
Posts: 3,907
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

Using backup software is a good idea. To find out what is being backed up, you have to look at the documentation.

File History in Windows 10 may be an alternative, but I suspect it primarily backs up document files, not templates.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #7  
Old 12-22-2015, 03:30 PM
Charles Kenyon Charles Kenyon is offline Missing Macros after upgrade to 2016 Windows 8 Missing Macros after upgrade to 2016 Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Here is a KB article on this situation.

https://support.microsoft.com/en-us/kb/3129969
Reply With Quote
Reply

Tags
microsoft office 2016, missing macros, ms tech support sucks



Similar Threads
Thread Thread Starter Forum Replies Last Post
Missing Macros after upgrade to 2016 Excel 2016 Macros running slow Neels_MSExcel2016 Excel Programming 5 05-18-2016 01:37 AM
Missing Macros after upgrade to 2016 Selection Pane Missing in PowerPoint 2016 mrhuddman PowerPoint 1 01-15-2016 06:56 AM
New Office for Mac 2016 wmth99 Office 1 12-22-2015 08:15 PM
Office 2016 preview - has anyone tried it? jladbury Office 0 06-06-2015 11:30 AM
Missing Macros after upgrade to 2016 2010 Upgrade Word Icon Missing Kzootie Office 6 09-18-2012 04:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft