
Completed
Posted
Paid on delivery
My long-running workbook is still in the old Excel 97-2001 (.xls) format and over time the formulas—especially anything tied to Data Validation—have started to misbehave across multiple yearly sheets. Formulas that should update automatically are either returning the wrong results or refusing to react when the source data changes. I’m not fully sure which validation rules are broken, but I can supply the entire file so you can see the behaviour first-hand. Here’s what I need: • Open the existing .xls file in a modern version of Excel, locate every formula that is failing, and correct it so the results match the intended logic. • Audit and repair all Data Validation rules so they apply consistently on every sheet and trigger the correct messages when breached. • Ensure the repaired workbook stays fully compatible with both legacy and current Excel versions—or let me know if an .xlsx migration is the more stable route. • Provide a short change log so I can follow exactly what was fixed or improved. Once the workbook calculates properly and validation behaves as expected, we’re done. If you spot any quick performance or clarity tweaks along the way, feel free to suggest them. I’ll send the file as soon as we start.
Project ID: 40138675
46 proposals
Remote project
Active 5 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello there, I understand you need an experienced Excel specialist to repair formulas and data validation across an older .xls workbook. I have 7+ years of experience in Excel, VBA, Excel Macros, and complex workbook repair, and I have mastered the required skill set. I will locate failing formulas, repair validation rules, and ensure compatibility across legacy and modern Excel. 1️⃣ Open the .xls in modern Excel and run diagnostic checks to list broken formulas and DV rules. 2️⃣ Trace and correct formulas (including INDIRECT, named ranges, and cross-sheet links) so results match intended logic, citing fixes from a multi-year budgeting workbook I repaired. 3️⃣ Audit and repair Data Validation, restoring consistent rules and messages across yearly sheets. 4️⃣ Recommend and implement safe compatibility fixes or a controlled .xlsx migration if stability requires it. 5️⃣ Deliver a concise change log, note VBA edits, and provide a short test script for you to verify calculations. I look forward to working with you. Best Regards, Rosita Iniesta.
$50 USD in 7 days
2.6
2.6
46 freelancers are bidding on average $114 USD for this job

With more than a decade of experience as a strategic consultant and technology specialist, I offer versatile expertise in Excel that perfectly aligns with your project needs. From managing pivot tables to crafting powerful excel macros using VBA, I've consistently delivered transformative solutions similar to the ones you seek. To address your project concerns directly, my proficiency in Data Analysis and Excel Automations allows me to locate broken formulas efficiently while simultaneously correcting them so your workbook calculates properly - leaving no room for discrepancies. I'll also audit and repair your Data Validation rules meticulously, ensuring they apply consistently across the yearly sheets. Additionally, I'll guide you on whether to proceed with the compatibility-centric .xls format or upgrade to the more stable .xlsx version. My change log will detail all the repairs made so you're fully aware of all improvements carried out on your workbook. Trusting me with this project means entering into an invaluable partnership that will enhance not only your data processes but also growth and efficiency across your entire enterprise.
$30 USD in 1 day
8.2
8.2

Hi James, Thank you for considering my proposal. With over 8 years of real-world experience and freelance work in Excel, I am well-equipped to assist you with your project. I have carefully reviewed your requirements for fixing the Excel 97-2001 workbook and addressing issues with formulas and data validation. I would like to connect with you in chat to discuss the project further and understand your specific needs. Once we have a chance to chat, I can provide you with a detailed plan on how I will approach fixing the workbook and ensuring it functions correctly. Looking forward to discussing this project with you. Regards
$30 USD in 1 day
6.2
6.2

Hi There! I have understood the requirements for the task. I have 8+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tables, and excel based formulas. My expertise is broad and versatile and includes: *Microsoft Excel- Advance formulas -Python -VBA/Macros -Dashboard -Data Analysis -Web-Scraping and Data Entry. *Adobe Acrobat-Fillable forms -Editing and Scripting. *Google Sheets-Advance formulas -Custom Scripts -Dashboard I am Proficient in Microsoft Excel, Adobe CS & CC Photoshop, Illustrator, InDesign, Adobe Acrobat and Google Sheets, and Wordpress I am waiting for a response from your side. Thanks Anjali
$150 USD in 3 days
6.0
6.0

Hello, I specialize in diagnosing and repairing legacy Excel workbooks, and I can quickly stabilize your .xls file by identifying every misfiring formula and broken Data Validation rule, then correcting them so calculations respond accurately to source changes across all yearly sheets. I’ll audit the logic end-to-end in a modern Excel environment, ensure validation rules and alerts apply consistently, and clearly advise whether staying in .xls or migrating to .xlsx is the most reliable long-term option—making any fixes compatible with your chosen path. You’ll receive a fully functioning workbook plus a concise change log detailing exactly what was repaired or improved, along with optional performance or clarity suggestions where quick wins are obvious. Regards, Zafar
$100 USD in 1 day
6.3
6.3

Hi, I hope you're doing well. I understand you're looking for Excel 97-2001 Workbook Fix I am the ideal candidate for your project. I have read the provided job description and I understand what you are looking for. I have over 10+ years of experience Visual Basic, Data Processing, Data Entry, Excel, Excel VBA, Excel Macros .Please feel free to further discuss the requirements and timeline for the project. I'd be happy to assist you. I am ready to start right now. ✅ No Upfront Payment ✅ Release Milestone After Completion ✅ 100% Project Completion Rate You can visit my Profile https://www.freelancer.com/u/HiraMahmood4072 Thank you
$100 USD in 2 days
6.3
6.3

Hi there,I am a Data Scientist is a professional responsible for extracting actionable insights and knowledge from large volumes of data Microsoft applications Development. I can write clean, Excel, Word, Access, PowerPoint, Power BI, Outlook and creating VBA macros. Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide a high quality of work, I am willing to fully devote my time and energy to improve the service offered, with timely, accurate and professional results, building trust and a long term relationship with customer is my main objective. https://www.freelancer.com/u/GdevDataSceince Choosing me for this project not only means benefiting from my extensive skills in Excel and data analysis but also entrusting your sales data with someone who values precision and confidentiality. Let's begin working together on this valuable project to deliver lasting results that will positively impact your business. Thanks Gdev
$30 USD in 2 days
5.1
5.1

Hello there! Do you want me to maintain full backward compatibility with the old .xls format, or are you open to migrating fully to .xlsx for better stability and modern Excel features? I will open your legacy workbook in a modern version of Excel, systematically locate and correct every failing formula to ensure calculations return the intended results, audit and repair all Data Validation rules so they function consistently across all yearly sheets with accurate messages, and provide a concise change log detailing every fix and improvement, while advising on whether an .xlsx migration would enhance stability and performance, and optionally suggesting small tweaks for clarity and efficiency—would you like me to also optimize any inter-sheet links or named ranges that could be contributing to formula errors? Here's my portfolio for your review: https://www.freelancer.com/u/Penmate Please feel free to message me so we can discuss the project in more detail. Best regards, Bryson Henniger.
$100 USD in 2 days
5.2
5.2

Hi James, I read your project and I am very much interested to help with Excel 97-2001 Workbook Fix task. I'm an Accountant, an Expert in MS Excel, Data Entry, PDF Conversion, Processing and formatting big sets of data. please send me a message through chat to discuss this task. Kind Regards, Moustafa
$30 USD in 1 day
5.1
5.1

Yo there, I can audit and repair your Excel 97–2001 (.xls) workbook so all formulas and Data Validation rules behave correctly again. I’ll open it in a modern Excel version, track down every failing or inconsistent formula, fix validation rules across all yearly sheets, and confirm results update as intended. I’ll also advise honestly whether staying on .xls is safe or if moving to .xlsx will give you better long-term stability. You’ll receive a fully working file plus a short change log explaining what was fixed or improved. Send the workbook and I’ll get started right away.
$119 USD in 1 day
4.8
4.8

Hi there! I specialize in diagnosing and repairing legacy Excel workbooks, including broken formulas and Data Validation issues across multi-sheet models. I’ll audit the file in a modern Excel version, fix all faulty logic, restore consistent validation, and provide a clear change log. You can share the file and I’ll start immediately. With 8+ years of experience in Excel, I deliver accurate, efficient, and well-structured data solutions—on time and within budget. I specialize in: Advanced Excel dashboards, formulas, and pivot tables Data cleaning, analysis, and visualization VBA/Macro automation to save time Google Sheets automation via Apps Script You’ll receive: Fully editable, documented files Clean, easy-to-use dashboards Fast communication and unlimited revisions View my profile and work: freelancer.com/u/muhammadj121 Looking forward to helping streamline your data processes! – Junaid
$30 USD in 3 days
3.6
3.6

With more than 12 years of experience as a full-stack software engineer, I've garnered exceptional skills in various technologies – including but not limited to Excel, Excel VBA, Data Entry, and Data Processing – that are essential for completing your project. My extensive knowledge working with both old and modern Excel versions will definitely come in handy while rescuing your workbook in the outdated .xls format. I guarantee impeccable attention to detail while locating formulas that aren't functioning correctly, even those tied to Data Validation. Equally important, I understand the need for complete transparency which is what you'll get throughout your project with me. As you mentioned about staying compatible with both legacy and current Excel versions, I am well-versed in finding solutions that work seamlessly within different interfaces while maintaining performance. Additionally, being an effective communicator ensures I will offer detailed elaborations on what was fixed or improved so you can follow along effortlessly no matter your technical background.
$60 USD in 5 days
3.4
3.4

Hello, With a core skill set in Data Processing, Excel, and Visual Basic, I have the unique ability to combine your need for Excel 97-2001 Workbook repair with my expertise in modern data manipulation. Having worked extensively with data and built scalable pipelines to clean, transform, and analyze raw data, I'm highly adept at pinpointing issues within complex datasets. This transfers well to your requirement of auditing and repairing formulas throughout multiple yearly sheets. Additionally, my proficiency in visualizing data through tools like Power BI and Tableau will ensure any quick performance or clarity tweaks will be identified and implemented effectively. My 5+ years in the field has taught me the importance of seamless system compatibility. In case migrating to .xlsx format seems more stable for your workbook's longevity, I can handle the transition without disrupting any crucial elements of your workbook. Ultimately, what sets me apart is not only my deep understanding of Data Engineering or Excel but how I've used these skills to bridge gaps between various aspects of data management and analysis: from building pipelines to automating processes. So let's bring that old workbook into the present together! Thanks!
$250 USD in 4 days
3.0
3.0

Hello! I understand that you're experiencing issues with your long-standing Excel 97-2001 workbook, particularly with formulas and Data Validation rules. It's crucial to have this fixed to ensure the workbook operates smoothly across multiple yearly sheets. I’ve successfully dealt with similar issues in the past, where I revitalized legacy Excel files by diagnosing and correcting faulty formulas and enhancing Data Validation. My previous clients have praised my attention to detail and the reliability of the solutions I provide. ✅My Plan: - Open the existing .xls file and conduct a comprehensive review to identify all problematic formulas. - Correct formulas to match the intended logic, ensuring updates happen automatically. - Audit and repair Data Validation rules for consistency across all sheets. - Confirm that the workbook remains compatible with both legacy and modern Excel versions. - Provide a detailed change log summarizing all adjustments. Could you share any specific formulas you're concerned about or any additional context on the data you’re using? Best regards, Hongqiang Chen
$230 USD in 2 days
3.2
3.2

Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific field, making me the ideal candidate to handle your project. My proficiency includesExcel VBA, Data Entry, Excel, Data Processing, Excel Macros and Visual Basic, which positions me as the best choice for the successful completion of your project. While I am well-prepared to begin, I have a few clarifying questions. Kindly drop me a message in the chat so that we can engage in a discussion regarding the project's budget and deadline. Thank you, and I look forward to the opportunity to collaborate on your project.
$150 USD in 3 days
2.9
2.9

Hello ❤️, Estimated cost: $120 USD | Timeline: 2–3 days I can carefully audit your legacy Excel 97-2001 (.xls) workbook, identify all broken formulas, and repair them so calculations update correctly across every sheet. I will also review and fix all Data Validation rules to ensure consistent behavior, error messages, and triggers. If necessary, I can migrate the file to .xlsx for improved stability while maintaining backward compatibility. A concise change log will be included to document all formula corrections and validation updates. Quick performance or clarity improvements will be suggested along the way. Thanks,
$120 USD in 3 days
1.7
1.7

Good day, I would be pleased to assist you with stabilizing and repairing your long-running Excel workbook. I have extensive experience working with legacy .xls files, complex formulas, and Data Validation issues that arise when older workbooks are used across multiple versions of Excel. I will carefully open and review your workbook in a modern Excel environment, identify every formula that is misbehaving, and correct it so the calculations reflect the intended logic across all yearly sheets. In parallel, I will fully audit all Data Validation rules, repair broken or inconsistent validations, and ensure that alerts and messages trigger correctly wherever rules are breached. I will also assess overall compatibility and clearly advise whether keeping the file in .xls format is safe or if migrating to .xlsx would provide better long-term stability. Once the fixes are complete, I will provide a clear, concise change log outlining exactly what was corrected or improved. If I notice any quick performance or clarity enhancements, I will point those out as well. You can share the file as soon as we begin, and I will take it from there with a structured and reliable approach. Thank you, Muhammad Hanif
$140 USD in 4 days
0.8
0.8

Hello, I can help you stabilise and repair your legacy Excel workbook so that all formulas and Data Validation rules behave correctly across every sheet. I have strong experience working with older .xls files as well as modern Excel versions, including debugging formulas that no longer recalculate properly and auditing complex Data Validation setups. My approach is to first observe the workbook’s current behaviour, understand the intended logic, and then apply targeted fixes so results update accurately and consistently. What I will do: Review the existing .xls file in a modern Excel environment and identify all failing formulas Correct formulas so they recalculate as intended when source data changes Audit and repair Data Validation rules across all relevant sheets, including messages and constraints Advise whether staying in .xls or migrating safely to .xlsx will provide better long-term stability Provide a clear change log detailing every fix or improvement made I work carefully and transparently, and I’ll keep you informed if any logic needs clarification before changes are applied. I’m available to start as soon as you share the file. Best regards, Zavqidin
$140 USD in 6 days
0.4
0.4

Surprising Coincidence!!! This is Hunter from Buckhannon, WV and I already have done very similar project to this one last month, so I have rich experiences and deep knowledge in Excel Macros, Excel VBA, Data Processing, Data Entry, Excel and Visual Basic. Let me share my detailed experience via chatting. I'll look forward to hearing from you. Thank you Hunter David
$155 USD in 1 day
0.0
0.0

Hello James W., We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Visual Basic, Data Processing, Data Entry, Excel, Excel VBA, Excel Macros Lets connect in chat so that We discuss further. Regards
$140 USD in 7 days
0.0
0.0

Hi there, I have carefully reviewed your project requirements and understand the task clearly. After analyzing the details and expected outcome, I am submitting this proposal with a focused and practical approach to your project. I will start by opening the existing Excel 97-2001 workbook in a modern version of Excel to identify and correct the misbehaving formulas, especially those related to Data Validation. By auditing and repairing all Data Validation rules, I will ensure they consistently apply on every sheet and trigger the correct messages when breached. I will also ensure that the repaired workbook remains fully compatible with both legacy and current Excel versions. Upon completion, I will provide you with a short change log detailing all the fixes and improvements made. If I come across any performance or clarity tweaks that can enhance the workbook, I will suggest them for your consideration. Let's discuss in detail through chat.
$50 USD in 1 day
0.0
0.0

Alpine, United States
Payment method verified
Member since Jan 11, 2026
$250-750 USD
₹1250-2500 INR / hour
₹600-1500 INR
₹100-400 INR / hour
₹750-1250 INR / hour
€12-18 EUR / hour
$30-250 USD
$10 AUD
$30-250 USD
₹12500-37500 INR
₹400-750 INR / hour
₹1000000-2500000 INR
$30-250 USD
₹12500-37500 INR
$15-25 USD / hour
$10-30 USD
₹1500-12500 INR
₹100-400 INR / hour
$30-250 USD
₹12500-37500 INR