+ Reply to Thread
Results 1 to 4 of 4

adding rows to tables replicates existing formulas sometimes, sometimes only some, or none

  1. #1
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468

    adding rows to tables replicates existing formulas sometimes, sometimes only some, or none

    I could provide an example but each time it's a different sheet or different table. There is just no rhyme or reason, that I know of. Anyone know how this works so I can control it from now on? right now some formulas are being automatically added, others not.
    Excel 1.0.1 (16.0.14326.20140) (Android)
    Excel 2010 14.04.4760.1000

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: adding rows to tables replicates existing formulas sometimes, sometimes only some, or

    If all the rows in a column have the same formula, then the formula will be replicated. If the column has mixed data or formulas, then the formula will not be replicated.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468

    Re: adding rows to tables replicates existing formulas sometimes, sometimes only some, or

    how about =E83+60? since this is relative is it "mixed" as you say?

  4. #4
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    468

    Re: adding rows to tables replicates existing formulas sometimes, sometimes only some, or

    I also notice that if I add a row from the bottom it will reproduce the formulas, well, some of them, but then if I "insert" the row somewhere in the middle it will NOT reproduce the formulas. Is this a rule? And just to rehash, for example, =e83+60 is not reproducing in one table, but in another it does. So if anyone knows what determines this please share. thanks!



    actually, it wasn't adding formulas by adding rows from bottom. so I converted the table out then recreated it and it works as intended. SO... what so often causes my tables to stop linking the formulas to the next created rows?
    Last edited by juntjoo; 07-22-2016 at 07:14 PM.

+ 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. Adding Formulas to Tables
    By rkorinko in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2015, 06:02 PM
  2. [SOLVED] Adding two rows after every existing row
    By Hitch75 in forum Excel General
    Replies: 11
    Last Post: 10-15-2014, 03:07 AM
  3. [SOLVED] Adding formulas to modify the existing data by vba
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-20-2013, 08:00 PM
  4. Adding Auto Number after two blank Rows
    By Maniko in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-30-2013, 06:45 AM
  5. [SOLVED] Excel 2007 : adding new cell reference to existing formulas
    By LegionLord in forum Excel General
    Replies: 5
    Last Post: 05-08-2012, 12:15 PM
  6. Replies: 3
    Last Post: 02-02-2011, 10:41 AM
  7. Adding rows to excel and keep existing formulas
    By laddyboy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-23-2008, 08:17 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