How can I prevent Excel for mac from corrupting VBA on several worksheets?

VBA macros aren't working for multiple runs after the recent update to Excel 16.99 for Mac. I use an M4 iMac, MacOS 15.5.

After a successful Excel VBA execution, when I rerun the Excel VBA code I get error #6, overflow. With nothing changed if when I close and restart Excel and rerun the VBA macro, the same error occurs. When I restart the computer everything is sometimes OK, for the 1st execution.

The issue doesn't seem to be specific to a single workbook, but to several workbooks I've tried.

What does work for a single execution is to reset Excel to it's original state with Microsoft Office Reset.

Example error:

z1 = Cdbl(f(k)) <-- Overflow ERROR, but both z1 & f(k) have valid values.

f(k) is an Array variant, z1 as double

I can get correct answers if after this error I click "debug" and "continue" and work my way to completion with repeats of that manual process for all similar errors.

1. Does anyone else have this problem?
2. Any ideas on what's going on?

Here's what I've tried...with no success:

1. Using option explicit and adding required Dim's

2. Reinstalling Office (only 1st execution is good)

3. Avoiding use of Array data definition

4. Forcing a double: z1 = Cdbl(f(k) +0#)