+ Reply to Thread
Results 1 to 2 of 2

Excel table insert row - fills automatically a value but from where???

  1. #1
    Registered User
    Join Date
    03-10-2021
    Location
    NL
    MS-Off Ver
    Office 365
    Posts
    2

    Question Excel table insert row - fills automatically a value but from where???

    Hi All,

    Using Excel 365 on the office. We have a table in the sheet and when inserting a row a value is filled automatically in one of the cells. All other cells are behaving as expected.
    Problem is that we don't know where this value is coming from. It is filled with a very simple formula ( =650/1) but again, we don't know where this is coming from.
    Is there a way to find out where an inserting table row is getting it's "info" when inserting a new row? It doesn't matter where in the table I insert the new row, neither does the method (insert row or insert table row above) and the surrounding rows do not have such a value in them (in fact they all have a formula in them that should be on the place where now 650/1 is presented).

    Looking forward to your thoughts on this.

    Evert

  2. #2
    Registered User
    Join Date
    03-10-2021
    Location
    NL
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Excel table insert row - fills automatically a value but from where???

    I solved it myself. Not knowing what caused it but the most important thing is that it is fixed.
    I copied the whole tab to a new tab and it was solved. Copying cells only within the tab itself doesn't do the trick, I had to copy the whole tab.

    As said, not knowing what caused this and how to solve another way.

+ 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. creating a new sheet that automatically fills a new column in.
    By rochea in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2020, 11:48 AM
  2. automatically fills the cells where the test needs be be done
    By leonv01 in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 10-21-2019, 09:19 AM
  3. Calendar fills cells automatically
    By dw_22801 in forum Excel General
    Replies: 4
    Last Post: 08-09-2019, 03:36 PM
  4. [SOLVED] Button that automatically fills row?
    By Battletoads in forum Excel General
    Replies: 1
    Last Post: 04-17-2018, 09:47 AM
  5. 1 independent variable and making a chart which fills automatically
    By red-eye-rob in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-25-2014, 11:24 AM
  6. [SOLVED] macro to automatically insert table in excel
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2013, 03:37 AM
  7. Need a table, which fills in numbers automatically depending on text in column
    By Hotsoup666 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2013, 03:13 AM

Tags for this Thread

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