Link to home
Start Free TrialLog in
Avatar of StevenPMoffat
StevenPMoffat

asked on

Fill down formulas in Excel 2007 Table not working

I have a spreadsheet with a table in it.   The formula in one column would automatically fill down when I created a new row in the table.    Sometime later that spreadsheet was changed.   Now when I add a new row, the formula doesn't get copied down.   I am includnig a copy of before (where it works) and where after (where it doesn't work).   Please help me find what the difference is that is causing the problem.  I am sure it is probably obvious, but I can't seem to find it.   Table-V1.0.xlsx Table-1.1.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of StevenPMoffat
StevenPMoffat

ASKER

Thank You.  That worked, but by any chance do you know why it got broken?   I had copied and pasted a bunch of information from the older table into the newer table and I am wondering if that might have caused the problem somehow.