circular reference in excel

[jimsan]

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/spreadsheet...VKeWm5_tzhy22vzklA-KfCCMM/edit#gid=1642180982

 

[mole999]

your google drive is not public

 

[jimsan]

Dear All

Since file size was big , have deleted some row , please add rows till 985

So till 980 getting final result as desired , but after 980 rows . Not getting proper result

https://ufile.io/p4vxv

please help

 

[mole999]

I think you are hitting the cell size limit > https://support.office.com/en-gb/ar...d-limits-1672b34d-7043-467e-8e27-269d656771c3

F880 contains 29288 chars

 

[jimsan]

Thanks so much for reply , what is solution to it , as i cant break my file

 

[mole999]

I don't believe you can work beyond that physical limit, so adding the previous value to make a new value will not proceed beyond what you are doing currently. Maybe some can work something out but I fail to see the concept of adding more and more. If it were in a database then it may take longer to reach a maximum limit

 

[jimsan]

But i refered to this page and it say that total character allowed

Total Character in cell - [FONT=&quot]32,767[/FONT]

https://support.office.com/en-gb/ar...-467e-8e27-269d656771c3#ID0EBABAAA=Excel_2007


please advice

 

[mole999]

and you are at 29,000 plus after you deleted rows. so 3000 characters currently left. Maybe I missed something