Microsoft Office Forums

Microsoft Office Forums (https://www.msofficeforums.com/)
-   OneNote (https://www.msofficeforums.com/onenote/)
-   -   Embedded Excel files now opening with Macros disabled (https://www.msofficeforums.com/onenote/50199-embedded-excel-files-opening-macros-disabled.html)

LoneStarPiper 01-06-2023 07:19 AM

Embedded Excel files now opening with Macros disabled
 
Hello,

For years, we've used a template in OneNote that has a macro-enabled Excel doc in it. Now, one of our computers was just updated and when we open the file it opens in protected mode. We have double checked all of our trust settings in Excel, which are set to allow macros.

I have tried tons of things, but cannot get around it. Because we can't mark it as safe by right click the file in OneNote (like you can on a desktop), there's no way for us to run the workbook.

Side note: if you move the file to the desktop and double click it, it runs fine. Move it back and open it and it opens in safe mode.

Please help!!!

Roach2012 01-28-2023 12:56 PM

Same issue here, Microsoft Please fix this !

LoneStarPiper 01-28-2023 01:21 PM

Quote:

Originally Posted by Roach2012 (Post 173039)
Same issue here, Microsoft Please fix this !

The only workaround I’ve found is to stop updates and roll back to the previous version. It’s fairly painless to do, but obviously limits future updates.

Roach2012 01-28-2023 01:33 PM

Quote:

Originally Posted by LoneStarPiper (Post 173040)
The only workaround I’ve found is to stop updates and roll back to the previous version. It’s fairly painless to do, but obviously limits future updates.

are you referring to the windows 23H2 update? - this could be an option for the short term, thanks!

I've been moving the file to my desktop and back again but its also not ideal as there are a lot of shared computers

LoneStarPiper 01-28-2023 01:34 PM

No, just Microsoft office. Not windows. If you have trouble I’ll find the link and post it later when I’m back at my office.


All times are GMT -7. The time now is 05:35 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft