Notifications
Clear all
Excel Tables
2
Posts
2
Users
0
Reactions
28
Views
Topic starter
I just finished watching this video and decided to try to convert 1 Excel worksheet in a workbook to a table, as an experiment for ease of reading (Banded Rows etc).
The conversion has created #SPILL! errors all over the worksheet...
Any ideas where to start to fix the errors greatly appreciated. TIA
Posted : 20/05/2025 10:38 pm
Structured tables don’t allow dynamic array functions that spill results into multiple cells. It defies the whole nature and purpose of structured tables. Hence the SPILL error.
Can you give an example of the formula(s) that spill their result? Shouldn’t be too difficult to transform them into formula(s) that don’t spill but will work in tables. Upload your file. That would make it easier.
Posted : 20/05/2025 11:07 pm
