How to Fix the Unable to Record Macro Error in Excel 2013?
![](/images/site-logo.png)
How to Fix the Unable to Record Macro Error in Excel?
Summary: You may encounter the “Unable to record macro” error in MS Excel when using Personal Macro Workbooks. In this post, we’ll discuss the possible causes behind this error and the ways to fix it. We’ll also mention a professional Excel repair tool that can help fix the error if it occurs due to corrupted workbook.
A personal macro workbook (Personal.xlsb file) is a hidden workbook in Excel that stores all macros in a single workbook. This allows you to automate processes while working in Excel. Sometimes, when recording macro codes in the personal macro workbook, you may get the message “Personal Macro Workbook in a startup folder must stay open for recording”. When you click on the OK button, it will show the “unable to record” error. This prevents you from recording the macros. Below, we’ll see the causes behind this error and discuss how to resolve this error.
Causes of Unable to Record Macro Error
You may be unable to record macros in Excel due to several reasons. Let’s take a look at the possible causes that can lead to this issue.
- The location of personal.xlsb file is changed.
- Personal.xlsb file is corrupted.
- Macros are disabled.
Methods to Fix the “Unable to Record Macro” Error in Excel
Here are some possible solutions that can help you resolve the unable to record macro error in Excel.
Method 1: Check the Path of XLStart Folder
You may be unable to record macros if the path of XLStart folder is incorrect. It is a folder where the Personal.xlsb file is stored by default. Follow these steps to find out the path of this folder:
- Open MS Excel. Go to File > Options.
- Click Trust Center > Trust Center Settings.
- In the Trust Center Settings window, click on Trusted Locations.
- Verify the path of the XLSTART folder and modify it if there is an issue.
- Once you are done, click on OK.
Method 2: Change Macro Security
The “Unable to record macro” error can occur if macros are disabled in the Macro Security settings. You can try changing the macro settings using the below steps:
- In MS Excel, go to File > Options > Trust Center.
- Under Trust Center, click on Trust Center Settings.
- Select “Enable all macros” and then click OK.
Method 3: Check Add-ins for Disabled Items
If there are any items in add-ins that are disabled, they may prevent Excel from functioning properly. You can check and enable the items in MS Excel using the below steps:
- Click File > Options.
- In Excel Options, click on the Add-ins option.
- Select Disabled Items from the Manage section and click on Go.
- The Disabled Items window is displayed.
- Click on the disabled item and then click Enable.
- Restart Excel for the changes to take place.
Method 4: Repair your Excel File
You may fail to record macros if there is corruption in the workbook. In such a case, you can use the “Open and Repair” utility in MS Excel to repair the corrupt workbook. To use this tool, follow these steps:
- Open your Excel application.
- Click File > Open.
- Browse to the location where the corrupted file is stored.
- In the Open dialog box, choose the corrupted workbook.
- From the Open dropdown list, click Open and Repair.
Excel will prompt you to repair the file or extract data from it. Click Repair to retrieve maximum data. If the Repair option fails, then click on the Extract Data option to recover the data without formulas and values.
If the Microsoft utility “Open and Repair” fails to repair the corrupted Excel workbook, then try a professional Excel repair tool such as Stellar Repair for Excel. It is an advanced tool that can easily repair severely corrupted Excel (XLSX and XLS) files. It can recover all the file items, including chart sheets, cell comments, tables, macros, formulas, etc. without impacting the properties and cell format of the Excel file.
Closure
You may receive the “unable to record” error in Excel while creating or storing macros in Personal Macro Workbooks. There are several reasons that can lead to this error. You can try the methods covered in this post to resolve the error. If the error appears due to corruption in workbook, then try to repair it using the Open and Repair utility. Alternatively, you can use Stellar Repair for Excel – a professional tool that can help you repair an Excel file with problematic macros. Also, it allows recovery of all the file components with complete integrity. The tool is compatible with Excel 2021, 2019, 2016, and older versions.
Also read:
- How to Restore Deleted Infinix Note 30 VIP Racing Edition Contacts An Easy Method Explained.
- 2 Ways to Transfer Text Messages from Xiaomi Redmi Note 12 Pro 5G to iPhone 15/14/13/12/11/X/8/ | Dr.fone
- How to recover old call logs from your HTC ?
- How to recover old messages from your Motorola Edge 40 Neo
- How To Restore Missing Photos Files from Nubia Z50S Pro.
- How to Recover Deleted Photos from Android Gallery App on Tecno Pop 7 Pro
- How to retrieve erased call logs from Nokia G310?
- How to Rescue Lost Videos from Tecno
- How to restore wiped videos on Motorola Edge 2023
- How To Repair System Issues of iPhone 14 Pro Max? | Dr.fone
- How to play AVCHD MTS files on Samsung Galaxy A24?
- How To Restore Missing Music Files from Xiaomi Civi 3 Disney 100th Anniversary Edition
- How to Recover Deleted Screenshots on iPhone 6 Plus? | Stellar
- How to identify some outdated your hardware drivers with Windows Device Manager in Windows 11/10
- How to fix videos not playing with my Huawei Enjoy 70?
- How to get back lost photos from Infinix .
- How to Recover Deleted Photos from Android Gallery App on Tecno Spark 20
- How to Fix the #Value! Error in Excel 2003? | Stellar
- How to Restore Deleted Lava Blaze 2 5G Pictures An Easy Method Explained.
- How to Recover Deleted Notes from iPhone 8 Plus? | Stellar
- How to restore wiped videos on HTC U23
- How to Restore Previous Version of Excel 2003 File? | Stellar
- 4 Ways to Transfer Music from Nubia Red Magic 9 Pro to iPhone | Dr.fone
- How to Recover Deleted Data from iPhone 8 using Stellar Data Recovery for iPhone? | Stellar
- In 2024, How To Reset the Security Questions of Your Apple ID From Your Apple iPhone X
- In 2024, How to Transfer Contacts from Samsung Galaxy A24 to Other Android Devices Using Bluetooth? | Dr.fone
- In 2024, 10 Free Location Spoofers to Fake GPS Location on your Oppo A78 5G | Dr.fone
- 9 Solutions to Fix ZTE Blade A73 5G System Crash Issue | Dr.fone
- Fix the Error of Unfortunately the Process.com.android.phone Has Stopped on Vivo S18 | Dr.fone
- 2024 Approved Creating AI Videos With AI Avatars
- Bypass iPhone 13 mini activation lock without Apple ID
- In 2024, Apple iPhone 12 Pro Asking for Passcode after iOS 17/14 Update, What to Do?
- In 2024, Best Pokemons for PVP Matches in Pokemon Go For OnePlus 12 | Dr.fone
- 3 Effective Ways to Bypass Activation Lock on iPhone 14 Plus
- Three Solutions to Hard Reset Infinix Hot 30i? | Dr.fone
- Full Guide to Bypass Lava Storm 5G FRP
- Title: How to Fix the Unable to Record Macro Error in Excel 2013?
- Author: Nova
- Created at : 2024-05-19 18:32:11
- Updated at : 2024-05-21 02:34:23
- Link: https://blog-min.techidaily.com/how-to-fix-the-unable-to-record-macro-error-in-excel-2013-by-stellar-guide/
- License: This work is licensed under CC BY-NC-SA 4.0.