Formula not being replicated when new row added to table

Hi,

I have two sheets in a workbook with what are pretty much identical tables containing data. Unfortunately though they are not behaving in the same way.

Essentially in both tables the final column contains an important formula. When I insert a new row into Table 1, a new row is added and importantly, the formula in the last column is added. When I insert a new row into Table 2, a new row is added with the correct formatting BUT the formula does not get added to the row’s cell in the last column.

I have also noticed that when I add a new row in Table 2, I get the formatting brush pop up with options such as ‘Format Same as Above’. This does not happen when I add a new row in Table 1.

I’ve tried converting Table 2 to range and formatting as table again but to no avail. Both are using the same custom table.

I’d be very grateful for any ideas. I’m using Excel 2010.

Hello Laser,
Try this option:

1. Go to "File" tab on the ribbon.
2. You'll find "Options" there. Click on it.
3. A window will pop up. On the right of it select "Proofing".
4. There will be "AutoCorrect Options..." button. Click on it.
5. Choose the tab "AutoFormat As You Type".
6. Check the 3rd (the last) item "Fill formulas in tables to...".
7. Press "OK" and again "OK".

That's all. I hope it will work. Good luck!

Originally Posted by Esbi

Hello Laser,
Try this option:

1. Go to "File" tab on the ribbon.
2. You'll find "Options" there. Click on it.
3. A window will pop up. On the right of it select "Proofing".
4. There will be "AutoCorrect Options..." button. Click on it.
5. Choose the tab "AutoFormat As You Type".
6. Check the 3rd (the last) item "Fill formulas in tables to...".
7. Press "OK" and again "OK".

That's all. I hope it will work. Good luck!

Thank you for your reply however that hasn’t worked unfortunately. The box was already checked.

As mentioned in my OP the issue is only affecting one of my sheets.

Any other suggestions greatly appreciated.