Why is My Personal Macro Workbook Not Loading? Top 3 Reasons.

34K views Jan 27, 2022

Today’s video is an answer to a common question I receive. Why is my Personal Macro Workbook not loading automatically in Excel?. I had this problem recently also. All was going well. Every time I opened Excel, my trusty Personal Macro Workbook loaded up too, until one day it did not. A while ago, I wrote a blog post about creating and updating your Personal Macro Workbook. If you want to learn more about the workbook, you can read that using the link below. Macro Mondays -Creating and Updating Your Personal Macro Workbook http://www.howtoexcelatexcel.com/blog/macro-mondays-creating-and-updating-your-personal-macro-workbook/ After some digging around, it seems there are a few reasons for this to happen. I want to share them with you, so you don’t have to manually navigate to the file and manually opened it, as I did for a day or so. So let’s work through the checklist of possible problems and how to fix them. 1. Is Your Workbook Read Only? 2. Has The Workbook Been Disabled? 3. Have You Trust Issues? I walk you through how to troubleshoot all 3 issues that may cause your Personal Macro workbook to not load automatically. 𝐉𝐨𝐢𝐧 𝐭𝐡𝐨𝐮𝐬𝐚𝐧𝐝𝐬 𝐨𝐟 𝐨𝐭𝐡𝐞𝐫 𝐄𝐱𝐜𝐞𝐥 𝐮𝐬𝐞𝐫𝐬 𝐰𝐡𝐨 𝐡𝐚𝐯𝐞 𝐚𝐥𝐫𝐞𝐚𝐝𝐲 𝐣𝐨𝐢𝐧𝐞𝐝 𝐭𝐡𝐞 𝐄𝐱𝐜𝐞𝐥 𝐀𝐭 𝐄𝐱𝐜𝐞𝐥 𝐌𝐨𝐧𝐭𝐡𝐥𝐲 𝐍𝐞𝐰𝐬𝐥𝐞𝐭𝐭𝐞𝐫. 𝟑 𝐅𝐑𝐄𝐄 𝐄𝐱𝐜𝐞𝐥 𝐓𝐢𝐩𝐬 𝐞𝐯𝐞𝐫𝐲 𝐦𝐨𝐧𝐭𝐡. 𝐏𝐥𝐮𝐬 𝐅𝐑𝐄𝐄 𝟑𝟎 𝐓𝐢𝐩𝐬 𝐄𝐁𝐨𝐨𝐤. 𝐡𝐭𝐭𝐩://𝐰𝐰𝐰.𝐡𝐨𝐰𝐭𝐨𝐞𝐱𝐜𝐞𝐥𝐚𝐭𝐞𝐱𝐜𝐞𝐥.𝐜𝐨𝐦/𝐧𝐞𝐰𝐬𝐥𝐞𝐭𝐭𝐞𝐫-𝐬𝐢𝐠𝐧-𝐮𝐩/

#Calculators & Reference Tools
  # General Reference