Sep 16 2023 06:19 AM
Sep 16 2023 06:19 AM
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 formats in the table itself, but nothing has worked. Short version - this table helps my supervisors automate tracking of employee attendance. column A and B are ID and Name, columns C-F are formulas. When tabbing across the last row to the point the table successfully creates a new row below, only the formula in column F copies down and applies to the new row.
I've turned all these settings on and off individually with no luck - under File > Options >:
-Formulas > Formula AutoComplete
-Proofing > AutoCorrect > AutoFormat As You Type > Automatically as you work > Fill Formulas in tables to create calculated columns
-Advanced > Enable Autocomplete for cell values > Automatically Flash Fill
I've even copied the entire tab to a fresh workbook. In the new workbook, with the user list as the only sheet, the formulas copy perfectly in C-F when adding a new row to the table. I'm attaching the de-identified copy for review, but it doesn't show the same behavior as the main file - which of course i can not post since it houses employee information.
Does anyone have any tips for troubleshooting this issue?
Sep 16 2023 07:12 AM
Try the following:
Sep 16 2023 09:58 AM
Sep 16 2023 10:06 AM
I'm stumped - this behavior is controlled by the second setting you mentioned in the first post:
Perhaps the workbook has become corrupted...
Sep 16 2023 10:08 AM - edited Sep 16 2023 10:11 AM
i was beginning to wonder that, but really hope not... i don't want to have to start this thing from scratch again, it was a beast to build over a few years. I have seen notes of differing autofill auto correct auto complete settings conflicting with one another, but very few mentions.
And since i built this thing myself, i'll only have so much company/IT support available to root cause it. But will keep digging and if all else fails here, maybe get lucky with a contact in my company. not giving up yet, but thanks. And open to any ideas...