Tracking down and erasing circular references in Excel

I have a massive Excel file, where I for some mysterious reason gets hundreds of circular reference errors. I need to erase the errors (allowing for circular references slows the file down heavily), and though I am skilled in Excel, I can not find the problem.

I have had plenty of interest, the file is now being looked at by my preferred bidder. If he can solve it, I'll award the job to him. Impossible to reply to everyone, I am sorry.

Adding the file here...

Taidot: Excel

Näytä lisää: erase circular reference, circular reference excel find, excel spreadsheet loan pipeline tracking, tracking excel, excel 2007 circular reference, excel problem, excel workbook team workload tracking, file tracking excel, excel fetch data web site need log, excel work log project tracking, excel spreadsheet time management tracking, excel tracking, reference excel, problem utf create excel, vba excel add list references, excel macro check references, File tracking, need excel experts

Tietoa työnantajasta:
( 1 arvostelu ) Oslo, Norway

Projektin tunnus: #4259063

13 freelanceria on tarjonnut keskimäärin 99 $ tähän työhön


Hi I am a finance professional and I have built 100s of sophisticated financial models over last 16 years. Pls see PMB.

250 $ USD 10 päivässä
(14 arvostelua)

I have 15 years of excel experience.

175 $ USD 1 päivässä
(11 arvostelua)

Hello, I am a .NET, VBA and VSTO software developer. I have nine years of experience in programming. I rest-assure that I will complete the work on time and deliver you the completed work to your satisfaction.

100 $ USD 5 päivässä
(14 arvostelua)

I have much Excel experience and excellent ratings.

200 $ USD 7 päivässä
(8 arvostelua)

Circular references can be a real pain. A lot of times the circular reference is tie to a Range. For the past 15 years I have worked with Excel/MS Access and 11 years with MS SQL Server 7.0 and 2005. I have been Lisää

60 $ USD 2 päivässä
(20 arvostelua)

Greetings..!! Please check your PM..!!

30 $ USD 1 päivässä
(6 arvostelua)

Hi Formula expert here.

30 $ USD 0 päivässä
(5 arvostelua)

Yes, this problem can be solved. Thanks for posting the file. I have quoted the time frame to allow for a bit of brute force work. We will have to talk about this of course. Please see my attached notes before acceptin Lisää

100 $ USD 5 päivässä
(7 arvostelua)

Hi, I've dealt with this kind of Excel issue and I'm ready to start working on this project.

30 $ USD 3 päivässä
(0 arvostelua)

can handle it for you

60 $ USD 1 päivässä
(0 arvostelua)

Hy there, It'll be easier if you attach the excel file.

50 $ USD 3 päivässä
(0 arvostelua)

Greetings, I am very interested in your project. There are several techniques for fixing the circular reference warnings you are receiving. Can you forward me your spreadsheet so that I may have a look to better u Lisää

75 $ USD 1 päivässä
(0 arvostelua)

Been working with Excel for twenty years. Quick look at your file suggests fastest solutoin will be for you to explain what the sheets should do so that I can "rebuild" until the first circular reference appears. Lisää

123 $ USD 7 päivässä
(1 arvostelu)