VBA & Macro Problems

Fix Excel Error: Two Input Coordinates Have the Same Values

Maira Mehtab Sep 30, 2026 868 views

Question details

The user is encountering a persistent error message stating 'two input coordinates have the same values' in an Excel workbook used for calculations.

How to Fix Excel Error: Two Input Coordinates Have the Same Values

Product: Microsoft Excel
Device & OS: not provided
Scenario: Performing aeronautical calculations and modifying formulas in a complex workbook.
Observed behavior: A popup or message repeatedly appears complaining about identical input coordinates, which does not stem directly from standard worksheet cells or standard charts.

Before you start

Save a backup copy of your workbook before modifying or disabling any VBA macros or add-ins to ensure no calculation data is permanently lost during troubleshooting.

Solution 1Recommended

Disable Macros to Identify the Source

Since this specific error is typically generated by custom VBA scripts rather than native Excel, disabling macros will help confirm if the background code is the culprit.

Native Excel formula errors usually appear as standard codes like #VALUE! or #REF!. Custom text dialogs are almost always triggered by user-defined VBA logic or external add-ins.

Open Trust Center

Go to 'File' > 'Options' > 'Trust Center', and then click on the 'Trust Center Settings' button.

Disable VBA Macros

Select 'Macro Settings' from the left menu and choose 'Disable VBA macros without notification' to temporarily block all scripts from running.

Restart and Test

Restart Excel and reopen the workbook. Make the same formula changes. If the error stops appearing, the issue is confirmed to be within the workbook's VBA code.

Macro Identification: Once confirmed, remember to re-enable macros if your aeronautical calculations rely on them to function properly.

Solution 2

Inspect the VBA Code for Coordinate Validation

If you confirmed a macro is causing the error, you need to locate and debug the specific script triggering the coordinate validation message.

Solution 3

Check and Disable Calculation Add-ins

If the error persists even with macros disabled, a third-party calculation add-in might be generating the prompt.

Free Microsoft Office alternative

Use WPS Office for Complex Data Calculations

If you are experiencing frequent macro errors or performance issues in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible environment for advanced worksheets and VBA scripts.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open Your Workbook: Launch WPS Spreadsheet, click 'Open', and select your calculation .xlsm or .xlsx file.
3. Enable Macros: If prompted by the security warning, choose to enable macros to allow your aeronautical calculations to run.
4. Test Your Data: Input your coordinates and run your formulas to enjoy a smooth, lightweight calculation experience.

Fully compatible with Microsoft Excel formats (.xlsx, .xlsm, .csv) for seamless migration.Lightweight design ensures fast loading of complex aeronautical calculation sheets.Supports VBA macros allowing you to execute your custom scripts without rewriting them.Familiar user interface requires no learning curve to master.

microsoft office alternative - wps office

Frequently Asked Questions

Why does a VBA macro throw coordinate errors instead of Excel natively?

Native Excel formula errors usually appear as standard codes like #VALUE! or #REF!. Specific, plain-text messages like 'two input coordinates have the same values' are custom data validation checks programmed into VBA scripts or third-party add-ins by the workbook's creator.

How do I find which macro is running in the background automatically?

You can open the VBA Editor by pressing Alt + F11, then check the 'ThisWorkbook' or individual 'Sheet' modules. Look for event handlers like 'Worksheet_Change' or 'Workbook_Open', which are designed to trigger scripts automatically when data is modified or the file is opened.

Can I run my Excel VBA calculation macros in WPS Office?

Yes, WPS Office supports VBA macros. You can open your .xlsm files in WPS Spreadsheet and execute your custom calculation scripts, provided the VBA environment module is installed with your WPS version.

What if disabling macros doesn't stop the coordinate error message?

If the error continues with all VBA macros disabled, the source is likely a third-party COM Add-in or standard Excel Add-in installed on your system. Go to File > Options > Add-ins to manage and disable them one by one to find the culprit.

Excel & Data Problems