+ Reply to Thread
Results 1 to 2 of 2

Update formula on table

  1. #1
    Registered User
    Join Date
    10-21-2018
    Location
    Brazil
    MS-Off Ver
    16
    Posts
    22

    Update formula on table

    Hello,
    I have this problem all the time... Every time I create a Table that use any formulas, I've to convert the table back to Range, then alter the formula and convert again to Table. If not, it does not update in the automatically formulas when I create a new row.

  2. #2
    Registered User
    Join Date
    11-03-2018
    Location
    mpls
    MS-Off Ver
    360
    Posts
    29

    Re: Update formula on table

    Check the Formulas,Calculation Options button to see if you have Automatic except for Tables selected.

+ 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. New entry in Table to update formula columns
    By mikehk in forum Excel General
    Replies: 3
    Last Post: 01-27-2019, 06:11 AM
  2. Auto Update Formula Containing Worksheet Name in a Table
    By rcl126062 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2017, 03:09 AM
  3. Replies: 1
    Last Post: 01-08-2015, 07:02 PM
  4. Formula update needed by referring to another table
    By Deenah in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-07-2011, 01:11 PM
  5. Replies: 1
    Last Post: 03-31-2011, 10:23 PM
  6. SumIf - need update formula + pivot table
    By nitr0 in forum Excel General
    Replies: 8
    Last Post: 08-12-2010, 09:34 AM
  7. Replies: 2
    Last Post: 06-30-2008, 10:56 AM

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