Share via

spreadsheet with disabled macro saved in Onedrive

Daniel Mingossi Mantovani 21 Reputation points
2022-11-23T16:07:29.983+00:00

I use office 365 and a few weeks ago the excell spreadsheets that contained macros, stored in Onedrive, stopped working. Authorization is not required to enable macros. It just tells you that macros have been disabled.

I am being forced to download the spreadsheet that I am going to use, to a local folder, carry out my work and at the end send it to Onedrive again.

The spreadsheet works normally if I open OneDrive and the spreadsheet through the Edge browser

What can I do?

263428-capturar.png

263474-capturar.png

OneDrive Management
OneDrive Management
OneDrive: A Microsoft file hosting and synchronization service.Management: The act or process of organizing, handling, directing or controlling something.
1,503 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,929 questions
0 comments
Accepted answer
  1. Charles Qi_MSFT 976 Reputation points
    2022-11-24T08:12:16.667+00:00

    Hi, @Daniel Mingossi Mantovani

    If the macro is from internet it will be blocked. Please refer to this document internet-macros-blocked

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in email-notifications to enable e-mail notifications if you want to receive the related email notification for this thread.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Daniel Mingossi Mantovani 21 Reputation points
    2022-11-24T12:42:11.71+00:00

    I found the solution... 263952-capturar.png

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.