
Closed
Posted
Paid on delivery
My financial-report templates rely on several nested IF, AND and OR formulas that should pull figures from other sheets in the same workbook, yet the numbers stay frozen when the source data changes. I need someone who can open the file, trace the internal links, correct any reference errors or circular logic, and make sure every total and subtotal refreshes instantly after data entry. You will be working only inside this one workbook—no external files or databases—so the focus is on sheet-to-sheet connections, range naming, and any settings (calculation mode, table expansion, etc.) that might block recalculation. Once the logic is solid I would like the templates cleaned up: remove any redundant helper columns, lock the finished formulas, and confirm the output matches a short test scenario I will provide. Deliverables: • Repaired nested IF/AND/OR formulas that update automatically • Verified links across sheets with no broken references • A brief change log so I can follow what was adjusted I’m on Excel 365, but compatibility with 2019 would be helpful. If you’re comfortable troubleshooting complex conditional formulas and polishing financial report templates, let’s get this wrapped up quickly.
Project ID: 40506287
18 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
18 freelancers are bidding on average ₹1,595 INR for this job

Hello I have several years of experience with Excel macros and formulas, including nested IF, AND, OR formulas. I am ready to start once you share spreadsheet to fix
₹1,004 INR in 2 days
7.2
7.2

Having worked intensely with Excel for several years, I have grown very experienced in troubleshooting complex formulas and tightening up financial-report systems. It is the kind of work I thrive on, as it allows me to showcase my prowess in conditional logic. With specific skills in tracing internal links and resolving any reference errors or circular logic, I am confident that I can deliver repaired nested IF/AND/OR formulas that will update automatically once the source data changes. What sets me apart from other freelancers is not just my comprehensive skill-set but also my approach towards meeting tight deadlines without compromising quality. I understand how business-critical your templates are and that a single broken formula can disrupt the entire process, which is why my services come with unlimited revisions and availability round-the-clock. Moreover, my range of experience ensures compatibility not only with Excel 365 but also with earlier versions like 2019. With this project, I take it upon myself to provide not just the solutions but also document the change log so you can easily follow what adjustments were made. Overall, hiring me means more than efficient troubleshooting; it means having a capable professional by your side committed to delivering top-quality services on time. Let's get this project "wrapped up quickly".
₹5,050 INR in 1 day
5.7
5.7

Hello, I’d be happy to help troubleshoot and repair your Excel workbook. I have an MBA background and extensive experience with: • Advanced Excel formulas (IF, AND, OR, INDEX/MATCH, XLOOKUP, SUMIFS) • Financial reporting templates • Formula auditing and debugging • Cross-sheet references and named ranges • Excel 365 and Excel 2019 compatibility I can help with: • Identifying and fixing broken references and formula errors • Tracing sheet-to-sheet links and dependencies • Resolving circular references and calculation issues • Verifying calculation mode and workbook settings • Ensuring all totals and subtotals update automatically when source data changes • Removing redundant helper columns where appropriate • Protecting and locking finalized formulas • Testing the workbook against your sample scenario to verify accuracy Deliverables: • Fully repaired workbook with automatic recalculation • Verified links and references across all sheets • Cleaned and optimized template structure • Brief change log documenting all fixes and improvements I focus on accuracy, efficiency, and creating reliable financial models that are easy to maintain and audit. I can start immediately and help get this resolved quickly. Best regards.
₹3,000 INR in 1 day
5.1
5.1

Hi , I am Syed Taha Hussain, and I can quickly fix your freezing Excel formulas. Automated spreadsheet modeling and technical data structure are my primary skills. I am an expert in auditing nested logic, specialising in debugging IF/AND/OR structures, tracing broken sheet to sheet links, and resolving circular references. I will clean up your redundant columns, lock the final formulas, and ensure total 365/2019 compatibility so your totals refresh instantly. I have successfully resolved numerous broken corporate models requiring absolute precision. You can message me in the chat so we can wrap this up today.
₹950 INR in 1 day
2.6
2.6

I specialize in diagnosing and resolving complex Excel logic issues, particularly nested IF/AND/OR functions and cross-sheet referencing, ensuring robust, automated financial templates. Proposal Hi! I can fix your frozen formulas and ensure your financial reports refresh instantly. I will trace every link, resolve circular logic, and optimize your nested IF/AND/OR functions. I’ll clean up helper columns, lock the final formulas, and provide a clear change log, all while ensuring Excel 2019/365 compatibility. Let’s get your templates working flawlessly!
₹1,000 INR in 7 days
0.0
0.0

I would be glad to look into your Excel workbook and fix the nested IF, AND, and OR formulas so they refresh seamlessly. Based on your description, the frozen numbers are likely caused by a broken sheet-to-sheet reference, circular logic, or your workbook’s calculation options being set to manual instead of automatic. I will systematically trace your internal links, clean up any redundant helper columns, lock the finalized logic to prevent future errors, and run your test scenario to ensure complete compatibility across Excel 365 and 2019. I am ready to start immediately and provide a clean, fully dynamic workbook along with a brief change log detailing every adjustment made
₹1,050 INR in 2 days
0.0
0.0

I am well versed with excel formula hence it's and easy task for me to deliver in a short span, I might take lesser time than proposed and can confirm once I have the excel
₹1,500 INR in 4 days
0.0
0.0

I look forward to troubleshooting your complex formulas to ensure smooth data retrieval and up-to-date reports. With my substantial experience as a Data Analyst and my advanced proficiency in Excel, I can confidently say that I'm the person you're looking for to fix and optimize your financial-report templates. I have a knack for identifying and rectifying errors in formulas, as well as optimizing performance and improving functionality. Moreover, my proficiency with SQL will be invaluable in checking and repairing the internal links on various sheets, removing any broken references, and ensuring seamless data integration within the workbook. With thoroughness being one of my core principles, I'll also provide you with a comprehensive change log documenting all the adjustments made. Lastly, My MBA finance knowledge reinforces my understanding of your project requirements. I know the importance of precise figures and accurate report generation for financial purposes. So rest assured that not only will all your formulas be fixed, but every total and subtotal will refresh promptly after data entry. Let's connect ASAP and get started on getting your workbooks on track!
₹699 INR in 1 day
0.0
0.0

I am very familiar with excel as a part of my day to day work on different project working for different entities. I usually work on most of the analytics part as my core field is data analysis so i work on if, and, or, vlookup, index, plots and many more. I think I might be the best fit for this projects. I can deliver the exact thing that you want and can deliver it ASAP according to your requirement.
₹1,050 INR in 1 day
0.0
0.0

Hi! I can quickly review and fix the broken formulas in your workbook so everything updates correctly. I will trace the logic across sheets, correct references, and ensure all IF/AND/OR formulas respond properly to changes in the source data. I’ll also clean up the structure and remove any unnecessary elements to keep the file stable and easy to maintain. I can complete this quickly and provide a summary of the changes made. Ready to start immediately.
₹1,050 INR in 2 days
0.0
0.0

When it comes to fixing your intricate Excel formulas and templates, my programming and data analysis skills make me an excellent fit for the job. With a solid background in Machine Learning and deep understanding of Excel, I have become especially adept at troubleshooting complex conditional formulas and streamlining processes for enhanced productivity - exactly what you need for this project. Over the years, I have gained extensive experience in data processing, which directly translates into my proficiency in tracing internal links, correcting reference errors, and troubleshooting circular logic - all necessary steps for ensuring seamless recalculations no matter how the source data changes. Your deliverables will not just include repaired nested IF/AND/OR formulas and verified links, but also a detailed change log enabling you to track every adjustment made. Moreover, my familiarity with Excel in both 365 and 2019 makes me highly adaptable to any environment. That coupled with my meticulous nature will ensure every output matches your test scenario. So let's get started on your workbook today. Embrace improved performance, automation, and user experience in just the way you need!
₹1,300 INR in 1 day
0.0
0.0

Hi, I specialize in debugging complex Excel formulas — especially nested IF/AND/OR chains across multiple worksheets. I'll fix your financial template so every total and subtotal updates instantly when source data changes. My process: 1. Open your workbook → trace all cross-sheet references and named ranges 2. Identify root cause: broken links, circular logic, calculation mode, or table expansion issues 3. Fix formula logic — ensure IF/AND/OR chains pull from correct sheets 4. Verify with your test scenarios — totals must match expected values 5. Clean up: remove redundant helper columns, lock formulas, confirm Excel 2019+365 compatibility Deliverables: ✅ All nested formulas fixed and auto-updating ✅ Zero broken references across worksheets ✅ Clean, optimized template — no extra clutter ✅ Change log documenting every adjustment made ✅ Compatible with Excel 365 & 2019 Bid: ₹1,200. Turnaround: 2 days. I understand financial templates and formula debugging deeply — this is exactly what I do best. Share the workbook and I'll return the first diagnosis within hours.
₹1,200 INR in 2 days
0.0
0.0

Sasvehalli, India
Member since Jun 11, 2026
$15-25 USD / hour
min $50 USD / hour
$10-30 USD
$15-25 AUD / hour
₹600-1500 INR
$30-250 USD
₹12500-37500 INR
₹75000-150000 INR
₹12500-37500 INR
₹750-1250 INR / hour
$10-30 CAD
$2-8 USD / hour
$10-30 USD
$750-1500 USD
$10-30 USD
$2-8 USD / hour
₹600-1500 INR
$30-250 USD
$15-25 USD / hour
₹8000-15000 INR