Mac Excel v16.85 crashes when opening workbooks modified by our add-on about office-js

[keyur32]

assigning to @XuanZhouMSFT to help investigate.

[JessieChenMS]

Hi Scott, thanks for reporting the issue, we are actively looking at the issue now. At the same time, wondering is it ok for you to help check whether this repro on 16.86 version? We got that version on hand and cannot repro against that version. So could be a quick mitigation to upgrade to 16.86 if also cannot repro on your end.

[heather-TillerMoney]

I'm the product owner for Tiller - I'm not seeing the 16.86 available for my Mac. I can try updating my OS if needed but figured I'd try just Office apps first.

[heather-TillerMoney]

I was able to update to 16.86 using the beta channel updates. However, now when I open a workbook that has some more advanced formulas/calcs I get this error.

[eschwieb]

Hi Scott and Heather,

We made a change on May 7 to no longer allow unsigned code in our process space in order improve security. This broke a different well-known 3rd party addin, so we reverted the change on May 16. That would explain why the issue went away in the next insiders release. We will be making this change again at some point in the future for Mac Office, so I would like to work with you offline to figure out why this broke your addin as well and how we can mitigate the issue. Please contact me directly at [email protected] -- thanks!

[JessieChenMS]

[like] Jessie Chen reacted to your message:

…

________________________________ From: Erik Schwiebert ***@***.***> Sent: Wednesday, May 22, 2024 4:43:38 PM To: OfficeDev/office-js ***@***.***> Cc: Jessie Chen ***@***.***>; Comment ***@***.***> Subject: Re: [OfficeDev/office-js] Mac Excel v16.85 crashes when opening workbooks modified by our add-on (Issue #4486) Hi Scott and Heather, We made a change on May 7 to no longer allow unsigned code in our process space in order improve security. This broke a different well-known 3rd party addin, so we reverted the change on May 16. That would explain why the issue went away in the next insiders release. We will be making this change again at some point in the future for Mac Office, so I would like to work with you offline to figure out why this broke your addin as well and how we can mitigate the issue. Please contact me directly at ***@***.******@***.***> -- thanks! — Reply to this email directly, view it on GitHub<#4486 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BHW4SZ5TFYNT2R7PHRLDDTDZDTDLVAVCNFSM6AAAAABICQVO66VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMRVGI3TSMRTGA>. You are receiving this because you commented.Message ID: ***@***.***>

[shanshanzheng-dev]

Hi @ScottMaxson and @heather-TillerMoney, The change was in a beta (pre-release, insider) build, and the fix was in the next insider build. If you are using Insider delivery services, you need to update to the latest insider release. The production version of Mac Office never had the bug. Could you try this if it works? Thanks.

[heather-TillerMoney]

I'm still getting this error when opening a workbook that has a more complex template in it and I'm running 16.87

[ScottMaxson]

@shanshanzheng-dev Just to clarify: we're not running insider builds of Mac Office/Excel.

[shanshanzheng-dev]

Hi @heather-TillerMoney, @ScottMaxson I'd like to confirm with you, about this issue "Mac Excel v16.85 crashes when opening workbooks modified by our add-on" is working on production, right? But when you open a workbook that has some more advanced formulas/calcs, you get an alert? And heather-TillerMoney, could you provide us more detailed information, such as advanced formulas/calcs? Thanks.

[heather-TillerMoney]

This is a dummy data sheet where I get an alert after opening and before updating to 16.86 a few days ago the workbook would immediately crash. I believe it's related to the worksheet called "Debt Payoff Planner" - there is a hidden area to the right with a bunch of formulas that you can review. A contractor built this for us so I'm not familiar with all the formulas/calcs that it's using, but it seems to be a common denominator. There are likely other templates built by our community that are failing similarly.

The other action that was crashing the add-in was when we were installing templates that were simple. This seems to be fixed in 16.86 and above. I ran a test and installed all our core sheets (Transactions, Categories, Balance History, Accounts, Balances) and never received the alert. I installed Debt Payoff and it installed fine, but when I went to save the workbook (for the first time) I got the "out of resources alert" so I deleted that sheet save and closed the workbook. Then I re-opened the workbook and did not get the alert so seems pretty narrow to whatever is in that Debt Payoff template at least in our supported templates list. There are others related to budgeting I haven't installed/tested yet. But our default Foundation template opens without issue so I don't think there is an issue with those.

dev-foundation-Jan24.xlsx

[shanshanzheng-dev]

Hi @heather-TillerMoney, Thanks for so much detailed information. Yes, about this issue "Mac Excel v16.85 crashes when opening workbooks modified by our add-on #4486", just like you mentioned, we have fixed. And I think the problem you are facing the alert is different. In order to triage your issue better, could you please create another issue? we'll follow normal process to triage your issue？And then we'll close this issue. Thanks.

[heather-TillerMoney]

Thank you for the reply here. Can you let me know if 16.86 has been pushed to current channel or is it only available for beta channel still?

[heather-TillerMoney]

We have confirmed with some of our internal teammates that they're not on the beta channel and they are still not able to get 16.86. Do you know when this will be broadly available? Until then many customers that do not want to update on beta channel are completely blocked from using our product.

[shanshanzheng-dev]

Hi @heather-TillerMoney Sorry, I think there is only available for beta channel, and I'm not sure when 16.86 will be broadly available. But according to https://learn.microsoft.com/en-us/officeupdates/update-history-office-for-mac#release-history-for-office-for-mac (release each month), I guess we can get 16.86 at Mid -June.

[microsoft-github-policy-service]

This issue has been automatically marked as stale because it is marked as needing author feedback but has not had any activity for 4 days. It will be closed if no further activity occurs within 3 days of this comment. Thank you for your interest in Office Add-ins!

[microsoft-github-policy-service]

This issue has been closed due to inactivity. Please comment if you still need assistance and we'll re-open the issue.