Forum Discussion
Excel table does not autofill formulas
Thanks for your response. In the meantime, I realized that the formula that would not auto-fill was first created before the column was included in the table. Apparently, when a formula is created outside the table and later becomes part of a table, Excel will not deal with it properly. I eventually re-did the formula for that column from within the table, and now it does auto-fill as expected.
- Thank goodness you posted this. I was really circling around trying to figure this out. recursion is not a given I guess?
jmaxwell1337 adding my experience with this to perhaps help. I had a table with a reference to a constant cell ($C$12). when the table expanded down the referenced cell did not. Interestingly the rest of the formula did expand, but the $C$12 became C7, C8,C9 respectively. I tried changing the reference to an Index(C12,1,1) but again, this part of the formula was overridden when expanding down. What worked for me was to convert the table back to a normal rage, and then select and insert it again using the same table name.
- Glad to hear that it worked. Point notee for my excel skills as well 😊👍
