Solved

Fill down formulas in Excel 2007 Table not working

Posted on 2011-09-14
2
369 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:StevenPMoffat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 125 total points
ID: 36540095
Hello,

you can repair the table this way:

click a cell in the table and then select Convert to Range on the Table Tools ribbon and select Yes when prompted
click Insert > Table to make the range a table again. Note that the table name has now changed. You can edit the table name in the name box on the Table tools ribbon.

cheers, teylyn
0
 

Author Closing Comment

by:StevenPMoffat
ID: 36540187
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.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question