I have a spreadsheet with 35 columns, 6 of which have formulas. The data has been converted to a named table. If I insert a new row, the formulas in 4 of the 6 columns are copied to the new row. It does not matter how I insert the row, shortcut keys or using the Ribbon or using a macro, the results are the same. Even more puzzling, there are 4 copies of this spreadsheet for each of our divisions. The other 3 copies work beautifully. They were all created from the same initial spreadsheet. I have tried copying formatting from the "working" sheets to the "non-working" sheet with the same result. I have copied the VBA code from the "working" to the "non-working", same result. I have found no help on any forum or Microsoft site. It has to be a setting somewhere on these 2 columns but I've exhausted everything I can think of.

Thank you in advanced.

Kim