🛠️ Bridge Application Troubleshooting Guide
Data Validation Errors
Error: Header validation failed. Cannot continue Bridge operation.
Solution:
- Check that all required column headers are present in the first row
- Ensure headers are not empty or contain only spaces
- Verify that header names match the expected format
- 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:
- Check the "Type" column values
- Ensure all Type values are one of:
Dimension, SumY, SumN, Result, Key
- Remove any empty cells in the Type column
- Verify spelling and capitalization of Type values
Duplicate Key Values
Error: Duplicate Key values detected. Cannot continue Bridge operation.
Solution:
- Review all rows where Type = "Key"
- Ensure each Key value is unique
- Check for hidden characters or extra spaces
- Consider using a different naming convention if needed
Duplicate Result Values
Error: Duplicate Result values detected. Cannot continue Bridge operation.
Solution:
- Review all rows where Type = "Result"
- Ensure each Result value is unique
- Check for hidden characters or extra spaces
- Consider renaming duplicate result items
Formula and Operator Errors
Invalid Operators
Error: Invalid operator(s) detected. Cannot continue Bridge operation.
Solution:
- Check all formulas for valid operators only
- Valid operators are:
$, =, +, -, *, /, (, )
- Remove any unsupported operators or functions
- 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:
- Review the highlighted cell(s) containing invalid characters
- Remove any unsupported characters from formulas
- Use only alphanumeric characters, valid operators, and parentheses
- Check for accidentally inserted special characters
Error: Formula validation failed.
Solution:
- Check all formulas for proper syntax
- Ensure variable names exist in the data
- Verify formula logic and structure
- 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:
- Ensure the "Data" worksheet exists and is named correctly
- Check that the worksheet is not hidden
- Verify worksheet names are spelled correctly (case-sensitive)
- If worksheet was renamed, restore the original name
Data Copy Errors
Error: Error while copying data between worksheets.
Solution:
- Ensure source and destination worksheets exist
- Check for protected worksheets that prevent copying
- Verify sufficient memory and Excel resources
- 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:
- Ensure Microsoft Excel is installed and properly licensed
- Close all Excel instances and restart the Bridge application
- Check if Excel is being used by other applications
- Run the application as Administrator if necessary
- Verify Excel COM components are registered correctly
PasteSpecial Errors
Error: PasteSpecial operation failed or encountered issues.
Solution:
- Ensure the clipboard contains valid data before pasting
- Check that the destination range is not protected
- Verify the paste format is compatible with the destination
- Try copying the data again before attempting to paste
- 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:
- Save the current workbook to the expected location
- Open the correct workbook file
- Verify the file path in the Bridge application settings
- Check for multiple instances of the same file
Additional Troubleshooting Tips
General Troubleshooting Steps
- Save your work: Always save your Excel file before running Bridge operations
- Check data integrity: Ensure your data is complete and properly formatted
- Review console output: Check the Bridge console for detailed error messages
- Restart if needed: Close Excel and Bridge, then restart both applications
- 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.