This Article will help you identify and resolve common Essbase VBA Run time errors.
Symptom:
Store is reporting that when they open their Sales & Labor projections, they get a Microsoft Visual Basic error that pops up before they can do anything.
Cause:
Excel is trying to calculate letters, symbols or spaces resulting in the Mismatch error.
Solution:
Check for any cell that does not have numbers in the cell.