Excel - dialog box stuck on "Closing: ..."

I'm having an issue when re-open an excel file (with macros) and it gets stuck on a dialogue box that says "Closing: ..." and will not go away.

This pops up after enabling macros and updating links. I tried leaving it for over 10 mins to no avail. The only way to resolve is to force quit and re-open a blank file, not to recover and open the problem file.

It seems to me that the macro (explained below) is causing excel to try and close a file that does not exist, thus causing the "Closing: ..." dialogue box issue that just loops.

Note: that the file I'm using is macro enabled and I have a macro script that:

1. saves macro file as xlsx (ActiveWorkbook.SaveAs FileName:="FILEPATH/", FileFormat:=xlOpenXMLWorkbook)

2. removes formulas with VAR.Cells.PasteSpecial xlPasteValues

3. saves the xlsx to dropbox and not onedrive so I don't have to wait for onedrive to upload the entire file

4. re-opens original macro file

5. closes the newly created xlsx file with - Workbooks("FILENAME.xlsx").Close SaveChanges:=False

6. Runs an apple script to copy the file from dropbox to onedrive using "AppleScriptTask("SCRIPT.applescript", "functionName", True)" & apple script using "duplicate POSIX FILE"

SPECS: Mac Excel version 16.57 | OS Big Sur 11.4 | Mac mini (M1, 2020)

Additionally here are some logs. I believe the SIGKILL was me force quitting as mentioned in original post. I replaced some data with X as not sure if sensitive info.

Coalition Cache Hit: app<application.com.microsoft.OneDrive.DownloadAndGo

(application.com.microsoft.Excel.XXXXXXXX.XXXXXXXX[35812]): Service exited due to SIGKILL | sent by loginwindow[151]

Microsoft Excel[59292]: getattrlist failed for /System/Library/Frameworks/OpenGL.framework/Resources//GLRendererFloat.bundle/GLRendererFloat: #2: No such file or directory

If anyone has seen this "Closing..." dialog box before please let me know.

Thanks so much!