{"id":9258,"date":"2025-11-07T16:29:47","date_gmt":"2025-11-07T16:29:47","guid":{"rendered":"https:\/\/www.repairmsexcel.com\/blog\/?p=9258"},"modified":"2025-11-07T16:45:03","modified_gmt":"2025-11-07T16:45:03","slug":"excel-personal-macro-workbook-in-the-startup-folder","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder","title":{"rendered":"How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">In Microsoft Excel, the <strong>Personal Macro Workbook (Personal.xlsb)<\/strong> is a hidden file that saves macros you can use across any workbook. It loads automatically when the Excel application starts. However, sometimes, you may face \u201c<strong>Microsoft Excel: Personal macro workbook in the startup folder must stay open for recording<\/strong>\u201d when this file fails to load or when trying to record a macro.<!--more--><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9259 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/Pic-1.png\" alt=\"Excel Personal Macro Workbook in The Startup Folder\" width=\"524\" height=\"161\" \/><\/p>\n<p style=\"text-align: justify;\">Fortunately, this error can be easily fixed by applying the solutions mentioned below in this post.<\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To fix corrupt Excel file, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h2 style=\"text-align: left;\"><strong>What Causes Excel Error Personal Macro Workbook in the Startup Folder?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Several causes can contribute to the occurrence of this Excel error &amp; identifying the root is vital for easy troubleshooting. Therefore, let\u2019s see the potential culprits:<\/p>\n<ol style=\"text-align: justify;\">\n<li>The Excel document is corrupted or inaccessible.<\/li>\n<li>The Personal.xlsb file isn\u2019t in the correct startup folder.<\/li>\n<li>Excel\u2019s startup settings are misconfigured.<\/li>\n<li>The workbook is already open but hidden.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Knowing the cause helps you apply the best fix quickly.<\/p>\n<h2 style=\"text-align: left;\"><strong>How to Solve Excel Personal Macro Workbook in the Startup Folder Must Stay Open for Recording Error?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Follow the methods below to fix this error message in Excel.<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<h3 style=\"text-align: left;\"><strong>Quick Fixes:<\/strong><\/h3>\n<ol style=\"text-align: justify;\">\n<li><strong><a href=\"#s1\">Unhide the Personal Macro Workbook<\/a><\/strong><\/li>\n<li><strong><a href=\"#s2\">Turn ON Personal Macro Workbook Feature<\/a><\/strong><\/li>\n<li><strong><a href=\"#s3\">Checking the Excel\u2019s Startup Folder<\/a><\/strong><\/li>\n<li><strong><a href=\"#s4\">Recreate the Personal Macro Workbook<\/a><\/strong><\/li>\n<li><strong><a href=\"#s5\">Repairing MS Office<\/a><\/strong><\/li>\n<li><strong><a href=\"#s6\">One-Stop Solution: Excel Repair Tool<\/a><\/strong><\/li>\n<\/ol>\n<\/div><\/div>\n<a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 1- Unhide the Personal Macro Workbook<\/strong><\/h3>\n<p style=\"text-align: justify;\">The very first solution you can try is unhiding the personal macro workbook. Many users have found this method helpful in their cases. So, let\u2019s try this:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Open Microsoft Excel.<\/li>\n<li>Click on <strong>View<\/strong> tab &gt;&gt; <strong>Unhide<\/strong> in the <strong>Window.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3540 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/04\/unhide-personal-macro-workbook.png\" alt=\"Unhide Personal Macro Workbook\" width=\"536\" height=\"374\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/04\/unhide-personal-macro-workbook.png 536w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/04\/unhide-personal-macro-workbook-300x209.png 300w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Choose the <strong>XLSB<\/strong> &gt;&gt; click <strong>OK<\/strong>.<\/li>\n<li>Save &amp; close Excel properly.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Now, check if Excel can record new macros again or not. If not, try the further tricks.<\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/microsoft-has-blocked-macros-from-running\">Microsoft Has Blocked Macros from Running Error in Excel \u2013 Easy Fix Guide!<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 2- Turn ON Personal Macro Workbook Feature\u00a0<\/strong><\/h3>\n<p style=\"text-align: justify;\">Since you are getting <strong>personal macro workbook in the startup folder must stay open for recording 365 error<\/strong> when trying to record a macro, so it is vital to enable the \u201cPERSONAL MACRO WORKBOOK\u201d feature in Excel.<\/p>\n<p style=\"text-align: justify;\">Here is how you can do so:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Open the <strong>Excel<\/strong> &gt;&gt; go to the <strong>File &gt; Options<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7700 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/12\/choose-and-click-options-1.png\" alt=\"Excel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\" width=\"550\" height=\"697\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Next, click on the Add-ins.<\/li>\n<li style=\"text-align: left;\">Under the Manage drop-down at the bottom, choose the <strong>Disabled Items<\/strong> &gt;&gt; click <strong>Go<\/strong><\/li>\n<li style=\"text-align: left;\">In Disabled Items window, locate &amp; select personal.xlsb.<\/li>\n<li style=\"text-align: left;\">Now, click on the \u201c<strong>Enable<\/strong>\u201d button &amp; then Close.<\/li>\n<\/ul>\n<p><a name=\"s3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 3- Checking the Excel\u2019s Startup Folder<\/strong><\/h3>\n<p style=\"text-align: justify;\">When the Personal.xlsb file isn\u2019t in the correct startup folder, it can trigger this annoying error message. Therefore, make sure your Personal.xlsb file is stored correctly by following the instructions below:<\/p>\n<p style=\"text-align: justify;\"><strong>Step 1<\/strong>&#8211; Press <strong>Win + R <\/strong>keys together to open Run box.<\/p>\n<p style=\"text-align: justify;\"><strong>Step 2<\/strong>&#8211; Type <strong>\u201c%appdata%\\Microsoft\\Excel\\XLSTART\u201d.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7785 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/appdata.png\" alt=\"%appdata%\" width=\"399\" height=\"206\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Step 3-<\/strong> Then, hit <strong>Enter<\/strong> to open the folder.<\/p>\n<p style=\"text-align: justify;\"><strong>Step 4-<\/strong> Now, confirm the <strong>Personal.xlsb&lt;\/strong&gt; file is present.<\/strong><\/p>\n<p style=\"text-align: justify;\">If missing, recreate it using the previous step.<\/p>\n<p><a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Way 4- Recreate the Personal Macro Workbook\u00a0<\/strong><\/h3>\n<p style=\"text-align: justify;\">Despite enabling the \u201cPERSONAL MACRO WORKBOOK\u201d feature and checking the startup folder, if you are still receiving this warning message, try <strong>recreating the personal macro workbook<\/strong> to overcome this situation.<\/p>\n<p style=\"text-align: justify;\">Follow the steps below to do so:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Close all the Excel instances.<\/li>\n<li style=\"text-align: left;\">Find the\u00a0<strong>XLSTART <\/strong>folder, which you can locate in\u00a0<strong>C:\\Users\\&lt;yourusername&gt;\\AppData\\Roaming\\Microsoft\\Excel\\XLSTART<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9264 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/lockfile-leave-start.webp\" alt=\"XLSTART\" width=\"786\" height=\"160\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/lockfile-leave-start.webp 786w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/lockfile-leave-start-768x156.webp 768w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Then, locate a\u00a0personal.xlsb\u00a0file there and move it to another location.<\/li>\n<li style=\"text-align: left;\">After this, open the Excel &amp; record the new macro.<\/li>\n<li style=\"text-align: left;\">Proceed to save it to the &#8220;<strong>Personal Macro Workbook<\/strong>&#8220;. This will create a new person.xlsb file in the XLSTART folder.<\/li>\n<\/ul>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <a href=\"https:\/\/www.repairmsexcel.com\/blog\/personal-macro-workbook-not-opening\">Solutions for Excel Personal Macro Workbook Not Opening Issue!<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"s5\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Way 5- Fix Excel Personal Macro Workbook in the Startup Folder Error by Repairing MS Office<\/strong><\/h3>\n<p style=\"text-align: justify;\">Last but not least, if nothing works for you, try repairing your Excel installation:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Open the <strong>Control Panel &gt;&gt; <\/strong>click<strong> Programs &gt;&gt; Programs and Features<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7547 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/open-programs-and-features-in-control-panel.png\" alt=\"Control Panel\" width=\"600\" height=\"246\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Find and click on <strong>Microsoft Office<\/strong>.<\/li>\n<li style=\"text-align: left;\">Then, click <strong>Change<\/strong> &gt;&gt; <strong>Repair<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7548 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2015\/07\/programs25252520and25252520feature.png\" alt=\"Programs and Features\" width=\"710\" height=\"467\" \/><\/p>\n<p style=\"text-align: justify;\">Once the repair completes, restart your computer.<\/p>\n<p><a name=\"s6\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>One-Stop Solution: Excel Repair Tool<\/strong><\/h2>\n<p style=\"text-align: justify;\">If you are facing this error due to file corruption, try the most reliable <a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\" target=\"_blank\" rel=\"noopener\"><strong>Excel Repair Tool<\/strong><\/a>. It is specially intended to repair Excel file and recover all their objects, such as <strong>macros, formulas, charts,<\/strong>\u00a0<strong>tables, queries<\/strong>, etc., with 100% integrity.<\/p>\n<p style=\"text-align: justify;\">Besides, it fixes multiple Excel files in a single process and even supports all Excel versions.<\/p>\n<center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Try Now<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/buy-now' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Buy Now<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> Free version of the product only previews recoverable data.<\/div><\/center>\n<h3 style=\"text-align: left;\"><strong>Steps to Use MS Excel Repair Tool:<\/strong><\/h3>\n\n<h2 style=\"text-align: justify;\"><strong>Frequently Asked Questions:<\/strong><\/h2>\n<p style=\"text-align: justify;\">        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How to Record Macros in Personal Workbook?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo record a macro in your Personal Macro Workbook, follow the steps below: <ul><li>Navigate to <strong>Developer<\/strong> tab &gt;&gt; <strong>Record Macro<\/strong>. <\/li><li>Choose Personal Macro Workbook from a \u2018<strong>Store macro in<\/strong>\u2019. dropdown menu. <\/li><li>Click on <strong>OK<\/strong>, once the recoding done, click Stop Recording and save the changes.                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Why Won&#039;t My Personal Macro Workbook Open in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tDue to corrupted Excel file or an incorrect file path, you are unable to open the Personal Macro Workbook.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Where To Open Personal Macro Workbook?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYou can locate your Personal Macro workbook in a Project Explorer pane on the left side pane. If you don't see it, then navigate to View &gt;&gt; Project Explorer.                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Recover My Personal Macro Workbook?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYou can recover Personal Macro workbook by using Excel\u2019s built-in Document Recovery feature. Simply navigate to \u2018<strong>File<\/strong>\u2019 &gt;&gt; \u2018<strong>Open<\/strong>\u2019 &gt;&gt; \u2018<strong>Recent Documents<\/strong>\u2019 &gt; \u2018Recover Unsaved Workbooks\u2019 to see if there\u2019re any auto-recovery files.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How to Record Macros in Personal Workbook?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To record a macro in your Personal Macro Workbook, follow the steps below: &lt;ul&gt;&lt;li&gt;Navigate to <strong>Developer<\/strong> tab &gt;&gt; <strong>Record Macro<\/strong>. &lt;\/li&gt;&lt;li&gt;Choose Personal Macro Workbook from a \u2018<strong>Store macro in<\/strong>\u2019. dropdown menu. &lt;\/li&gt;&lt;li&gt;Click on <strong>OK<\/strong>, once the recoding done, click Stop Recording and save the changes.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Why Won't My Personal Macro Workbook Open in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Due to corrupted Excel file or an incorrect file path, you are unable to open the Personal Macro Workbook.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Where To Open Personal Macro Workbook?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"You can locate your Personal Macro workbook in a Project Explorer pane on the left side pane. If you don't see it, then navigate to View &gt;&gt; Project Explorer.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Recover My Personal Macro Workbook?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"You can recover Personal Macro workbook by using Excel\u2019s built-in Document Recovery feature. Simply navigate to \u2018<strong>File<\/strong>\u2019 &gt;&gt; \u2018<strong>Open<\/strong>\u2019 &gt;&gt; \u2018<strong>Recent Documents<\/strong>\u2019 &gt; \u2018Recover Unsaved Workbooks\u2019 to see if there\u2019re any auto-recovery files.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/cannot-edit-macro-on-hidden-workbook\">Fix Excel Cannot Edit a Macro on a Hidden Workbook Error \u2013 Easy Tutorial<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Wrap Up<\/strong><\/h2>\n<p style=\"text-align: justify;\">Now you can<strong> fix the Excel personal macro workbook in the startup folder must stay open for recording 365\u00a0<\/strong>on your own. Ensure to follow the given methods very carefully. Furthermore, feel free to go with the <strong>Excel Repair<\/strong> <strong>Tool<\/strong> to fix file corruption that might be causing the Excel error.<\/p>\n<p style=\"text-align: justify;\">If I missed out on any resolution, then do share it with us on our\u00a0<a href=\"https:\/\/www.facebook.com\/MS-Excel-Repair-Tool-1569953153234271\" target=\"_blank\" rel=\"noopener\"><strong>Facebook<\/strong><\/a>\u00a0page.<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p><strong>References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/techcommunity.microsoft.com\/discussions\/excelgeneral\/issue-with-saving-macros-personal-macro-workbook-in-the-startup-folder-must-stay\/4077499\" target=\"_blank\" rel=\"noopener\">https:\/\/techcommunity.microsoft.com\/discussions\/excelgeneral\/issue-with-saving-macros-personal-macro-workbook-in-the-startup-folder-must-stay\/4077499<\/a><\/li>\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/answers\/questions\/4766330\/personal-macro-workbook-in-the-startup-folder-must\" target=\"_blank\" rel=\"noopener\">https:\/\/learn.microsoft.com\/en-us\/answers\/questions\/4766330\/personal-macro-workbook-in-the-startup-folder-must<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>In Microsoft Excel, the Personal Macro Workbook (Personal.xlsb) is a hidden file that saves macros you can use across any &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#more-9258\" aria-label=\"Read more about How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":9261,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[2004],"class_list":["post-9258","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-errors","tag-excel-personal-macro-workbook-in-the-startup-folder-must-stay-open-for-recording","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?<\/title>\n<meta name=\"description\" content=\"This guide revealing tips to fix Excel personal macro workbook in the startup folder must stay open for recording error...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?\" \/>\n<meta property=\"og:description\" content=\"This guide revealing tips to fix Excel personal macro workbook in the startup folder must stay open for recording error...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-07T16:29:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-07T16:45:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/Fix-Excel-Personal-Macro-Workbook-in-The-Startup-Folder-Must-Stay-Open-for-Recording-Error.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"310\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?\",\"datePublished\":\"2025-11-07T16:29:47+00:00\",\"dateModified\":\"2025-11-07T16:45:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder\"},\"wordCount\":1110,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/Fix-Excel-Personal-Macro-Workbook-in-The-Startup-Folder-Must-Stay-Open-for-Recording-Error.png\",\"keywords\":[\"Excel personal macro workbook in the startup folder must stay open for recording\"],\"articleSection\":[\"Excel Errors\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder\",\"name\":\"How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/Fix-Excel-Personal-Macro-Workbook-in-The-Startup-Folder-Must-Stay-Open-for-Recording-Error.png\",\"datePublished\":\"2025-11-07T16:29:47+00:00\",\"dateModified\":\"2025-11-07T16:45:03+00:00\",\"description\":\"This guide revealing tips to fix Excel personal macro workbook in the startup folder must stay open for recording error...\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/Fix-Excel-Personal-Macro-Workbook-in-The-Startup-Folder-Must-Stay-Open-for-Recording-Error.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/Fix-Excel-Personal-Macro-Workbook-in-The-Startup-Folder-Must-Stay-Open-for-Recording-Error.png\",\"width\":550,\"height\":310,\"caption\":\"Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\/\/www.repairmsexcel.com\/\",\"https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242\"],\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?","description":"This guide revealing tips to fix Excel personal macro workbook in the startup folder must stay open for recording error...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder","og_locale":"en_US","og_type":"article","og_title":"How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?","og_description":"This guide revealing tips to fix Excel personal macro workbook in the startup folder must stay open for recording error...","og_url":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder","og_site_name":"Excel File Repair Blog","article_published_time":"2025-11-07T16:29:47+00:00","article_modified_time":"2025-11-07T16:45:03+00:00","og_image":[{"width":550,"height":310,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/Fix-Excel-Personal-Macro-Workbook-in-The-Startup-Folder-Must-Stay-Open-for-Recording-Error.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?","datePublished":"2025-11-07T16:29:47+00:00","dateModified":"2025-11-07T16:45:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder"},"wordCount":1110,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/Fix-Excel-Personal-Macro-Workbook-in-The-Startup-Folder-Must-Stay-Open-for-Recording-Error.png","keywords":["Excel personal macro workbook in the startup folder must stay open for recording"],"articleSection":["Excel Errors"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder","url":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder","name":"How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/Fix-Excel-Personal-Macro-Workbook-in-The-Startup-Folder-Must-Stay-Open-for-Recording-Error.png","datePublished":"2025-11-07T16:29:47+00:00","dateModified":"2025-11-07T16:45:03+00:00","description":"This guide revealing tips to fix Excel personal macro workbook in the startup folder must stay open for recording error...","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/Fix-Excel-Personal-Macro-Workbook-in-The-Startup-Folder-Must-Stay-Open-for-Recording-Error.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/11\/Fix-Excel-Personal-Macro-Workbook-in-The-Startup-Folder-Must-Stay-Open-for-Recording-Error.png","width":550,"height":310,"caption":"Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-personal-macro-workbook-in-the-startup-folder#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"How to Fix \u201cExcel Personal Macro Workbook in The Startup Folder Must Stay Open for Recording\u201d Error?"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/9258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=9258"}],"version-history":[{"count":4,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/9258\/revisions"}],"predecessor-version":[{"id":9265,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/9258\/revisions\/9265"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/9261"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=9258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=9258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=9258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}