Forum Discussion

Copper Contributor

Apr 03, 2023

Fixing #SPILL on Dashboard by auto-added new row when I add row to Table

I have a dashboard that I populate with data from chunks of data I've named in the Name Manager. (Note the data is also in tables.) Everything is set up and working on the dashboard, but the problem ...

excel

Formulas and Functions

mathetes

Silver Contributor

Apr 03, 2023

amcckey

I have a feeling this is a super simple fix for Excel wizards...but this is a new area for me so trying to figure this out. I hope the screen shots are helpful.

Sadly, screen shots -- despite the cliche about pictures being worth a thousand words -- are far less helpful than the real thing. So if my suggestion doesn't resolve it, since it looks like this is all dummy data anyway, why don't you post the real thing on OneDrive or GoogleDrive, and paste a link here that grants edit access.

But here's my suggestion: reverse the sequence of items on your Dashboard. Move the formula that produces a dynamic array -- that incurs the SPILL error when blocked -- below all of the named ranges data elements.

Or off to the side.

In short, design the Dashboard so that the area that needs to be open-ended is open-ended.