format cells box is taking a long time to open on all my spreadsheets( even a new/blank workbook)

To anyone experiencing this on Tahoe: Please report to Microsoft using Help> Feedback in the Excel menu. Compatibility issues are often present when early releases of new operating systems are adopted.

If expeiencing the problem on any other version of macOS please start a new thread stating all particulars.

FWIW I'm running 16.102.1 on Sequoia 13.7.1 without any such issue. The Format> Cells dialog launches instantly in any workbook file.

The Offoce 16.102.2 update now is available to the Current Channel. It has corrected a number of UI issues imposed by Tahoe, perhaps that will improve this as well.

Hi Alan,

Thank you for responding, I am here to help you.

Possible cause of the problem is conflicting add-ins, corrupted settings, or an overloaded Excel cache.

Try this steps to help fix the problem:

Check the latest updates for Microsoft 365.

Disable and Re enable Add-ins

Open Excel app on Windows then click File and choose Options. Click on add-ins Select COM Add-ins, and click Go. Clear all the check boxes in the list, and click OK. Reopen Excel app on Windows check if there is any improvement.

For more information you can check this article:

https://support.microsoft.com/en-us/office/excel-not-responding-hangs-freezes-or-stops-working-37e7d3c9-9e84-40bf-a805-4ca6853a1ff4

I hope you find this information helpful. Please let us know if you have any further questions If the answer is helpful, please click "Accept Answer".

Best regards,

Jansher

Are you using the locally installed desktop software or the online web app?

Are your flavor of macOS & Office fully updated? Please provide present Version Numbers of both.

Hi Alan,

Thank you for responding for MAC if ever you try to update your MAC OS or disable and reenable your Add-Ins try this next step:

Repair Office: To repair Office on a Mac, you can follow these steps:

Quit all Microsoft Office applications.

Open the Applications folder, and then open the Microsoft Office folder.

Control-click the Microsoft Office app that you want to repair, and then click "Show Package Contents."

Open the "Contents" folder, and then open the "SharedSupport" folder.

Double-click "Microsoft Office Setup Assistant."

I hope you find this information helpful. Please let us know if you have any further questions If the answer is helpful, please click "Accept Answer". 

Best regards, 

Jansher