
Closed
Posted
Paid on delivery
I need help fixing non-functional drop-down boxes in my Excel pricing sheets. They worked in an older version but stopped after purchasing the new Excel. Requirements: - Expertise in Excel, particularly in troubleshooting and fixing issues with drop-down lists. - Experience with the latest Excel updates on Windows. - Ability to work efficiently and provide a solution that restores the functionality of the drop-down boxes. Please ensure your bids reflect relevant skills and experience.
Project ID: 40799385
102 proposals
Remote project
Active 3 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
102 freelancers are bidding on average $335 CAD for this job

Hi, I am Adeel. Dropdowns that worked in an older Excel and broke after an upgrade usually come from one of a few causes: data validation pointing at a list that moved or a named range that broke, a workbook saved in a compatibility mode, add-ins or macros disabled by the new security settings, or a sheet protected in a way the new version handles differently. I would start by checking one broken sheet to see which of these it is, then fix the validation rules and their source lists so every pricing sheet behaves the same. The first decision is whether the sheets need to stay macro-free for your team. If they do, the fix is purely in validation and named ranges. If a VBA helper is the simplest route, we can agree that before I touch the file. I am just a message away whenever you want to talk through which sheets to start with.
$250 CAD in 3 days
8.2
8.2

⭐⭐⭐⭐⭐ Fix non‑functional drop‑down boxes in Excel pricing sheets ❇️ Hi My Friend, I hope you are doing well. I checked all of your project requirements and I can see you are looking for help fixing Excel drop‑down lists. You have no need to look any further as Zohaib is here to help you! My team is already doing 50+ similar projects for Excel troubleshooting. I will build a clean solution that restores the drop‑down functionality using the latest Excel features, and I will also give you a short guide on preventing future issues, all within the same budget. ➡️ Why Me? I can easily do your Excel fix as I have 5 years of experience in Excel, VBA, data validation, and Windows Office. Not only this, I have a strong grip on Excel formulas, macros, and latest updates. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. Looking forward to discussing with you in chat. ➡️ Skills & Experience: ✅ Excel ✅ VBA ✅ Data Validation ✅ Drop‑down Lists ✅ Macros ✅ Windows Office ✅ Troubleshooting ✅ Formula Auditing ✅ Sheet Protection ✅ Compatibility Fixes ✅ Automation ✅ User Guides Waiting for your response! Best Regards, Zohaib
$350 CAD in 2 days
8.0
8.0

Hello, I can help troubleshoot the drop-down lists in your existing Excel pricing sheets and restore their functionality in the new Excel version. Since the lists worked previously, I would first check the existing Data Validation settings, source ranges, named ranges, and any formulas or references used to populate the lists. I would also check for compatibility issues introduced by the Excel update. My experience includes working with Excel files, formulas, data validation, and automating Excel tasks. I can investigate the cause, apply the necessary fixes, and test the drop-downs to ensure they work correctly without disturbing the existing pricing calculations or layout. If you can share one affected workbook and your current Excel version, I can start by examining the problem.
$251 CAD in 1 day
8.1
8.1

Hi, I have 15 years of experience working with Excel, formulas, and spreadsheet troubleshooting. I can help identify why your pricing sheet drop-downs stopped working after upgrading Excel and get them functioning again. I’ll check the data validation settings, named ranges, source references, and any formulas linked to the drop-down lists. I’ll also look for compatibility issues with the newer Excel version and fix the underlying problem rather than just applying a temporary workaround. I’ll test the repaired drop-downs to make sure they display and select the correct options without affecting your existing pricing calculations or workbook layout. Could you share the Excel file and let me know which version of Excel you're currently using? Best regards, Ayaz Akhtar
$250 CAD in 1 day
6.9
6.9

Hi, I can help troubleshoot and restore the drop-down functionality in your Excel pricing sheets. I have extensive experience working with Excel, including data validation, dependent drop-down lists, formulas, named ranges, and spreadsheet troubleshooting. I’ll review the existing workbook to identify what changed after your Excel upgrade, check the data validation settings and any related formulas or references, and fix the issue while preserving your existing pricing structure and formatting. I’ll also test the drop-downs to ensure they work correctly in the latest Excel for Windows. I can start by reviewing your file and provide an efficient solution. Thanks & Regards, Mussadiq Hussain
$250 CAD in 7 days
6.7
6.7

Your pricing sheets need the drop-downs restored without changing the formulas and pricing logic behind them. Since they worked in an older Excel version, I’d first identify whether they use Data Validation lists or form/ActiveX controls; the fix depends on which type they are. I work with Excel on Windows and can check the list sources, named ranges, workbook compatibility, and any macro or control settings affected by the upgrade. I’ll repair the drop-downs, test selections across the affected sheets, and explain what changed so the issue is easier to avoid later. Could you share one affected workbook and the version of Excel you’re using?
$250 CAD in 1 day
7.0
7.0

Troubleshooting Excel dropdown lists is a strong match for my Excel, Excel Macros, VBA, and Visual Basic experience. I work with the latest versions of Microsoft Office, including Excel on Windows, and can investigate why lists that worked in an older version are no longer functioning. My background also covers Excel formulas, formatting, timelines, pivot tables, charts, and graphs, giving me a practical understanding of how pricing sheets and their data sources are structured. I can restore the dropdown functionality while preserving the existing sheet layout and pricing data, with careful attention to efficient, accurate support. Choose me to fix your Excel pricing sheets and return the dropdown boxes to reliable working order.
$500 CAD in 1 day
6.5
6.5

Hey, when dropdowns stop working right after moving to a new Excel, it's usually one of a few specific causes, and the fix depends on which kind of dropdown your sheets use. If they're driven by macros or ActiveX controls, the most common culprit is Microsoft's newer security default: Excel now blocks macros in files that came from email or the internet, often silently, and some ActiveX controls are disabled by recent updates. The file looks normal, but the dropdowns don't respond. Saving a macro file as a regular .xlsx also strips the code without warning. If they're Data Validation lists, they typically break when the list points to another workbook, a named range that no longer resolves, or a dependent-dropdown formula that the new version handles differently. I'd find which one applies to your sheets, fix it properly rather than just turning off security, and where it makes sense, replace fragile controls with standard dropdowns that work in any current Excel. You'd get the fixed files back with a short note explaining what was wrong. When you click a dropdown now, does nothing happen at all, or does the list appear empty or show an error? Juan Pablo
$250 CAD in 7 days
6.4
6.4

Hello, I can troubleshoot and restore the non-functional dropdown lists in your Excel pricing sheets. I’ll inspect the data validation rules, source ranges, workbook compatibility, protection settings, and any changes introduced by the newer Windows Excel version. I’ll work efficiently to identify the underlying issue, correct the dropdown behavior, and verify that the solution works reliably throughout the pricing sheets. I can also explain the cause and provide practical steps to prevent similar compatibility problems in future Excel updates. I’m ready to review the workbook and focus on restoring the existing functionality with minimal disruption to your pricing process. Best regards
$250 CAD in 2 days
5.5
5.5

Hi, dropdowns that die right after an Excel upgrade usually come down to one of a few causes. The most common one now is that newer Microsoft 365 and Office 2024 turn off ActiveX controls by default, so old combo boxes just stop responding. Others are macros blocked on files that came from email, or a list that points to a file that moved. I'll open your pricing sheets, find which one it is and fix it. If the old boxes can't be trusted anymore, I'll swap them for normal Excel dropdowns that work the same way. Your prices and formulas stay as they are. I've built Excel planning tools through User Solutions that run at GE and Cummins. I also have 26 reviews on Freelancer for work like this. I can have it done within a day of getting the files. If your timing is different, message me and I'll adjust. Is your new Excel Microsoft 365 or Office 2024?
$250 CAD in 1 day
5.3
5.3

Excel, Excel VBA, and Visual Basic are the core skills I use to troubleshoot spreadsheet behavior, making me well suited to restore the non-functional drop-down lists in your pricing sheets. I can investigate the validation settings, source ranges, named references, and compatibility issues that may have changed after your Excel upgrade. My data analysis background also supports careful work with pricing data, so the existing sheet structure and values can be preserved while the drop-down functionality is corrected. I will focus on an efficient, practical fix for Excel on Windows and leave the sheets working as intended. Choose me to resolve this Excel issue with a clear, reliable solution.
$250 CAD in 3 days
5.3
5.3

Resolving software-version issues and restoring broken functionality is a core part of my work as a full-stack developer with 7+ years of experience. Your Excel pricing sheets need careful troubleshooting of their non-functional drop-down lists after the upgrade, and my background in bug fixing, optimization, version upgrades, and data processing is directly relevant. I have delivered 130+ projects involving reliable business solutions, error resolution, and maintainable data workflows. This experience allows me to investigate whether the issue comes from data validation, workbook settings, compatibility, or changed Excel behavior on Windows, then apply a practical fix that preserves the pricing sheet’s usability. Choose me to restore your Excel drop-down functionality efficiently and professionally.
$500 CAD in 5 days
4.7
4.7

Hi Your Excel pricing sheets’ non-functional drop-down boxes after the Excel upgrade are a fast, fixable troubleshooting job. I have spent the last 10 years solving exactly this type of problem. We will trace how the data validation lists were originally built, then repair the sources and ranges (including structured references, named ranges, table columns, and spill/filtered behaviors), validate Data Validation settings, confirm correct sheet/workbook recalculation, and address any Excel compatibility changes from the new version. PORTFOLIO: https://www.freelancer.com/u/zeeshanmomin722?w=f Let’s turn your ideas into reality! I’d love to chat about your project, understand your vision, and bring it to life. We can discuss the budget and timeline over chat. Best regards, Zeeshan
$250 CAD in 1 day
4.5
4.5

Let's Do This Right The First Time✔️ You mentioned fixing non-functional drop-down boxes in your Excel sheets. The key here is to troubleshoot the current settings so I'll identify the source of the issue and restore functionality. I understand it can be frustrating when updates disrupt your work. A common issue with newer Excel versions is compatibility with older files, which could be affecting your drop-downs. • I'll examine your spreadsheet settings to find conflicts. • I'll implement fixes to restore your drop-down functionality. If you want, I could take a look at your files and steer you in the right direction? Best, KurtSiebritz.
$350 CAD in 5 days
1.1
1.1

The challenge of non-functional drop-down boxes after an Excel update can be frustrating, especially when they previously worked seamlessly. It's essential to identify whether the issue stems from compatibility changes or settings adjustments in the new version. To tackle this, I propose a two-step approach. First, I'll review your Excel sheets to pinpoint the exact cause of the malfunction. This may involve checking the data validation settings or any linked ranges. Once identified, I’ll implement the necessary fixes to restore full functionality. To ensure you're satisfied with the solution, I can provide a test case after the first phase, allowing you to verify that everything works as intended before finalizing the fix. What specific functionality do you need to ensure is preserved in the drop-downs?
$350 CAD in 7 days
0.0
0.0

Upgrading Excel often breaks legacy dropdowns, particularly when newer releases handle Data Validation formulas, named ranges, or older ActiveX controls differently. For your pricing sheets, I will check whether the issue stems from broken source references, security settings blocking legacy controls, or deprecated VBA code, and update the sheets to ensure smooth compatibility with your current Excel build. Are your dropdowns built using standard Data Validation lists or embedded ActiveX combo boxes? Kind regards, Sonny Dube
$500 CAD in 7 days
0.0
0.0

North York, Canada
Payment method verified
Member since Nov 2, 2026
₹12500-37500 INR
₹750-1250 INR / hour
$15-25 USD / hour
₹150000-250000 INR
₹400-750 INR / hour
₹12500-37500 INR
₹12500-37500 INR
₹600-1500 INR
$30-250 USD
$30-250 USD
₹12500-37500 INR
$15-25 USD / hour
$10-60 USD
$10-30 AUD
$10-30 USD
$750-1500 USD
$250-750 USD
₹12500-37500 INR
$30-250 USD
$250-750 CAD