Spilled array formulas are not supported in an Excel table. Move the formula out of the table or convert the table to a range: Click Table Design > Tools > Convert to range.

We explain how to fix the issue when Excel is not auto-calculating formulas. Excel is an advanced tool when calculating formulas for statistics.

There’s a fix, and it’s simpler than you might think. My Online Training Hub uncover the one thing Excel tables consistently get wrong: their inability to reliably lock column references.

Quick Fixes for “Retrieving Data. Wait a Few Seconds” in Microsoft Excel Wait for a Moment and Try Again: The most immediate and sensible fix would be to give Excel a second or two to breathe.