+ Reply to Thread
Results 1 to 7 of 7

Circular reference in excel

  1. #1
    Registered User
    Join Date
    05-12-2017
    Location
    India
    MS-Off Ver
    Office 2007
    Posts
    5

    Circular reference in excel

    Dear All

    Please have a look at the link of excel file attach . Till row no 980 everything is fine in column F

    But in row no 981 , the value in column f it does not add "Reheat Function" and so on

    please help

    https://docs.google.com/spreadsheets...gid=1642180982

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Circular reference in excel

    Attach the file, rather than linking to a document which needs permissions...
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,277

    Re: Circular reference in excel

    If you attach file its more better. google drive access denied.
    For attach
    >Click "Go Advanced"
    >Click Manage Attachment
    >Brows file from respective folder
    >Click on upload
    >After complete uploading file click on closed this windows.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Registered User
    Join Date
    05-12-2017
    Location
    India
    MS-Off Ver
    Office 2007
    Posts
    5

    Re: Circular reference in excel

    Dear All

    Have uploaded the file , as the file size was big , so have deleted some rows , please add rows till 985

    After 980 final column result not getting it right

    please help
    Attached Files Attached Files

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,277

    Re: Circular reference in excel

    I gone through your file, after row 980 its work. which result you required as per your formula is corrected data show.

  6. #6
    Registered User
    Join Date
    05-12-2017
    Location
    India
    MS-Off Ver
    Office 2007
    Posts
    5

    Re: Circular reference in excel

    Dear Avk

    As file size was big had to delete some record .

    The file which i have uploaded is only till 880 record , please create more 150 record

    And the the result after 980 record

  7. #7
    Registered User
    Join Date
    05-12-2017
    Location
    India
    MS-Off Ver
    Office 2007
    Posts
    5

    Re: Circular reference in excel

    Can you please share that file , as at my end it is not working

+ 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. [SOLVED] Excel Circular Reference problem
    By Antlarin in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-06-2017, 06:42 PM
  2. [SOLVED] Excel Circular Reference Problems
    By dragon324 in forum Excel General
    Replies: 8
    Last Post: 03-18-2016, 02:49 PM
  3. Excel Newbie - Circular Reference Troubles
    By southaja in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 03-15-2016, 11:26 AM
  4. Replies: 2
    Last Post: 02-23-2014, 06:06 PM
  5. Eliminate Excel Circular Reference Warning
    By Matt W in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-07-2011, 04:32 PM
  6. Replies: 1
    Last Post: 08-21-2007, 07:22 PM
  7. [SOLVED] circular reference (Excel 2000)
    By peaspud in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2005, 02:20 PM

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