🛠️ Bridge Application Troubleshooting Guide

Data Validation Errors

Header Validation Errors

Error: Header validation failed. Cannot continue Bridge operation.

Solution:

  1. Check that all required column headers are present in the first row
  2. Ensure headers are not empty or contain only spaces
  3. Verify that header names match the expected format
  4. Make sure there are no special characters in header names
Note: Headers are case-sensitive and must exactly match the expected format.

Data Type Validation Errors

Error: Data Type validation failed. Cannot continue Bridge operation.

Solution:

  1. Check the "Type" column values
  2. Ensure all Type values are one of: Dimension, SumY, SumN, Result, Key
  3. Remove any empty cells in the Type column
  4. Verify spelling and capitalization of Type values

Duplicate Key Values

Error: Duplicate Key values detected. Cannot continue Bridge operation.

Solution:

  1. Review all rows where Type = "Key"
  2. Ensure each Key value is unique
  3. Check for hidden characters or extra spaces
  4. Consider using a different naming convention if needed

Duplicate Result Values

Error: Duplicate Result values detected. Cannot continue Bridge operation.

Solution:

  1. Review all rows where Type = "Result"
  2. Ensure each Result value is unique
  3. Check for hidden characters or extra spaces
  4. Consider renaming duplicate result items

Formula and Operator Errors

Invalid Operators

Error: Invalid operator(s) detected. Cannot continue Bridge operation.

Solution:

  1. Check all formulas for valid operators only
  2. Valid operators are: $, =, +, -, *, /, (, )
  3. Remove any unsupported operators or functions
  4. Ensure parentheses are properly balanced
Warning: Do not use Excel functions like SUM(), AVERAGE(), etc. in Bridge formulas.

Invalid Characters in Formulas

Error: Invalid characters found in formula cells.

Solution:

  1. Review the highlighted cell(s) containing invalid characters
  2. Remove any unsupported characters from formulas
  3. Use only alphanumeric characters, valid operators, and parentheses
  4. Check for accidentally inserted special characters

Formula Validation Errors

Error: Formula validation failed.

Solution:

  1. Check all formulas for proper syntax
  2. Ensure variable names exist in the data
  3. Verify formula logic and structure
  4. Test formulas in a separate Excel cell if needed

Worksheet and Data Errors

Missing Worksheets

Error: Unable to find required worksheet (Data, Process, etc.)

Solution:

  1. Ensure the "Data" worksheet exists and is named correctly
  2. Check that the worksheet is not hidden
  3. Verify worksheet names are spelled correctly (case-sensitive)
  4. If worksheet was renamed, restore the original name

Data Copy Errors

Error: Error while copying data between worksheets.

Solution:

  1. Ensure source and destination worksheets exist
  2. Check for protected worksheets that prevent copying
  3. Verify sufficient memory and Excel resources
  4. Close other Excel instances if running low on memory

Excel Application Errors

Excel Instance Errors

Error: Error obtaining Excel instance or connecting to Excel.

Solution:

  1. Ensure Microsoft Excel is installed and properly licensed
  2. Close all Excel instances and restart the Bridge application
  3. Check if Excel is being used by other applications
  4. Run the application as Administrator if necessary
  5. Verify Excel COM components are registered correctly

PasteSpecial Errors

Error: PasteSpecial operation failed or encountered issues.

Solution:

  1. Ensure the clipboard contains valid data before pasting
  2. Check that the destination range is not protected
  3. Verify the paste format is compatible with the destination
  4. Try copying the data again before attempting to paste
  5. Ensure sufficient memory is available for the operation
Note: PasteSpecial operations require both source and destination to be accessible and properly formatted.

Workbook Path Mismatch

Error: Current workbook path does not match the target path.

Solution:

  1. Save the current workbook to the expected location
  2. Open the correct workbook file
  3. Verify the file path in the Bridge application settings
  4. Check for multiple instances of the same file

Additional Troubleshooting Tips

General Troubleshooting Steps

  1. Save your work: Always save your Excel file before running Bridge operations
  2. Check data integrity: Ensure your data is complete and properly formatted
  3. Review console output: Check the Bridge console for detailed error messages
  4. Restart if needed: Close Excel and Bridge, then restart both applications
  5. Contact support: If problems persist, provide the error message and console output to support
Important: This is a sample troubleshooting guide. Please update the content and URLs to match your actual documentation system.