
This blog post sets out how to prevent or fix #SPILL errors in Excel Tables. Contrary to what Microsoft Help says, they might sometimes be fixable.
Continue reading “How to fix #SPILL errors in Excel Tables”This blog post sets out how to prevent or fix #SPILL errors in Excel Tables. Contrary to what Microsoft Help says, they might sometimes be fixable.
Continue reading “How to fix #SPILL errors in Excel Tables”Excel Tables (capital T) have been part of Excel since the 2007 edition. Given it is now well into adolescence, why is it still common to see spreadsheets holding and calculating data but not using Tables?
A quick internet search will reveal tonnes of articles about why you should use Excel tables.
Here is a really good one, for example.
However, in this post, I thought I would explore this from a different angle, to try to understand people’s reluctance to use this amazingly useful tool.
Continue reading “Why aren’t you using Excel Tables?”