1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to prevent !SPILL error?

Hi all,
I'm making a spreadsheet and I keep getting a SPILL error in one of my boxes.

I'm taking some of my data from one tab on another excel to calculate a % change but each time I do it, the tab spills over one extra cell for no apparent reason? Annoyingly it is just returning the same value also so there's no reason I can see for it to spill?

As I move through the months the amount of cells it spills into increases. It's infuriating, can anybody help at all?
Thanks

https://preview.redd.it/rplx7e6i79vg1.png?width=1657&format=png&auto=webp&s=eea0d48c6edecb7a8699aa4e057ed47fc0bbca99

submitted by /u/Ok-Let-5155
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article