Forum Discussion
Table Formulas Not Expanding
Morning all - need assistance with table formulas not expanding. I've spent a few hours troubleshooting and changing the various settings under Options one at a time, as well as changing cell format...
Final update here Hans - ended up rebuilding the sheet, tab by tab. Copied all user tabs one by one into a new workbook, then the "template", then recreated the user list (the problem tab) from scratch in the new workbook. that worked so i'm making the same assumption that it was a somehow corrupted file causing the formatting error. Thanks again, as always!
A lot of work, but it paid off. Well done!