+ Reply to Thread
Results 1 to 7 of 7

Formulas not added as table expands

  1. #1
    Registered User
    Join Date
    11-07-2017
    Location
    Binghamton, NY
    MS-Off Ver
    2016
    Posts
    15

    Formulas not added as table expands

    I use Excel tables a LOT, and and have grown to love what they add to the capabilities with Excel. I'm stumped by a particular table that I have, and could use some insight. Typically, as information is added to any of the fields immediately below or to the right of a table, the range of the table will expand to accommodate the new fields. If I have formulas in my table and add a new row to the bottom, the formulas and formatting typically copy down into the new range as well. I have a particular table for which this has not proven true. Each time I add new data, I have to copy all of my formulas and formatting, and this has become frustrating. As yet, I have not found any particular settings that would control this behavior of Excel. Geniuses, what say you?

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Formulas not added as table expands

    Are you sure this table is actually a 'Table', created by clicking Table on the Insert Tab ?
    Easiest way to tell is by right clicking anywhere within the table, do you see 'Table' on the menu that expanded upon right click ?

  3. #3
    Registered User
    Join Date
    11-07-2017
    Location
    Binghamton, NY
    MS-Off Ver
    2016
    Posts
    15

    Re: Formulas not added as table expands

    It is most definitely a table. It is called BankAccts, and was added using ctrl + T.

  4. #4
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: Formulas not added as table expands

    hi mjcarman01, I'm guessing you might manually enter the formula in the column row by row at first and subsequently adding additional rows will not auto-calculate the formula in the previous row. Try drag the formula for the first row of the column and copy down, then see if inserting next row will auto generate the formula..
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin

  5. #5
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Formulas not added as table expands

    Can you attach a sample book?
    Remember to desensitize the data.
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,056

    Re: Formulas not added as table expands

    Is there data validation in the Table? Is it in the first column? Is that the only table with DV in the first column?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  7. #7
    Registered User
    Join Date
    11-07-2017
    Location
    Binghamton, NY
    MS-Off Ver
    2016
    Posts
    15

    Re: Formulas not added as table expands

    This was the fix. Thank you alvin-chung.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 02-23-2024, 02:11 PM
  2. [SOLVED] Maintaining formulas in a table range when a new rows is added
    By elronino in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2015, 11:54 AM
  3. Copy formulas and formatting into new rows added to a table when they are inserted
    By robwebber in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2015, 05:01 AM
  4. Replies: 3
    Last Post: 03-28-2014, 12:04 PM
  5. Replies: 0
    Last Post: 06-20-2012, 07:46 AM
  6. Formula so that Chart expands as data is added
    By rushdenx1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2010, 06:34 PM
  7. formulas and rows being added
    By jcornish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-09-2007, 09:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1