Excel 2007 does not extend table automatically
Posted on 2010-09-16
I have several workbooks with data ranges. On my system (XP Pro SP3, Office 2007) after the data is retreived and I add columns to the data using VBA, those additional columns automatically get included in the table. This is necessary since I have other code that references the table by name.
Problem: Upon moving the workbooks to a different system (XP Pro SP3, Office 2007) the tables do not auto-extend when I add formulas.
I've been through every single option on both machines, they match or I've overlooked something. I've seen several articles referencing an option in Excel 2003 that doesn't exist in 2007.