![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 83%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHV%3C/text%3E%3C/svg%3E)
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 22%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Thank you for posting your question in the Microsoft Q&A forum.
I understand you’re having trouble activating macros in Excel. I’d like to ask a quick questions to better understand your situation and assist you effectively:
- I noticed you posted this under the Business tag, so the steps provided are for business accounts. If your issue is actually with a personal email account, could you confirm that so I can adjust my guidance accordingly?
- Does this issue occur with all Excel files, or only with a specific file?
- When you say macros are not working, do you mean:
- They are disabled by Excel’s security settings, or
- They run but don’t perform as expected?
- If possible, could you share a screenshot of the error or warning message? (Please hide any sensitive information.)
- Was the Excel file created by you, or was it shared by another user in your organization?
- Have you try add the file location to Trusted Locations
- Go to: File then find Options, you will see the Trust Center tab choose Trust Center Settings
- Trusted Locations.
- Add the folder where your Excel file is stored.
- Files in trusted locations will run macros without prompts.
- Go to: File then find Options, you will see the Trust Center tab choose Trust Center Settings
You could refer to this article : Enable or disable macros in Microsoft 365 files - Microsoft Support
Thank you again for your time and understanding. While my initial response may not resolve the issue immediately, I’d like to gather more details about your situation so I can assist you more effectively.
I really appreciate your patience, and I’m here to help. Looking forward to your response.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread