Excel macros are getting disabled after uploading file to blob storage.

Question

Hi we have uploaded an excel file to blob storage. this file contains macros written and few cells are formatted as numbers.

All these settings gets disabled when file is stored in blob storage. When we try to access the file, we have to again manually enable the setting.

How can we keep the excel format as it is in blob?

Answer 1

Hi,

Unfortunately Excel macro cannot be run in Azure Blob Storage, this is by design behavior.

If you have any feedback or suggestion about this behavior, you can try to give a feedback to Microsoft about your requirement.

Microsoft values your opinion. Your feedback goes directly to our engineers and helps us shape the future of Microsoft products and services for all our users.

---

If the response is helpful, please click "Accept Answer" and upvote it.

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.

Answer 2

@Gupta, Garima Additionally, you can share your feedback / feature request to improve how Excel files are handled in Azure Blob Storage, here: https://feedback.azure.com/d365community/forum/a8bb4a47-3525-ec11-b6e6-000d3a4f0f84

That would help product team prioritize it based on the number of votes.