Runtime error

[Sandra]

We have a large Excel document with many tabs that
intertwine via functions. However, when we open it and
click on the first tab which contains a chart (that pulls
data from the other tabs), we get this message: "Runtime
Error 13; type mismatch."

This error seems to be throwing garbage data into the
cells of that document and any other Excel worksheets that
are open at the time. It is causing us a lot of grief and
I would appreciate if anyone could help out. Another
employee seems to think he once saw an error message pop
up about something wrong in Visual Basic, but I could not
even find any macros currently running (my VB skills are
very weak at this time). Thanks!

Sandra

 

[Kevin Stecyk]

We have a large Excel document with many tabs that
intertwine via functions. However, when we open it and
click on the first tab which contains a chart (that pulls
data from the other tabs), we get this message: "Runtime
Error 13; type mismatch."

This error seems to be throwing garbage data into the
cells of that document and any other Excel worksheets that
are open at the time. It is causing us a lot of grief and
I would appreciate if anyone could help out. Another
employee seems to think he once saw an error message pop
up about something wrong in Visual Basic, but I could not
even find any macros currently running (my VB skills are
very weak at this time). Thanks!

Sandra,

Error 13 type mismatch is a VBA error.

You need to find the vba code and resolve the problem.

Best regards,
Kevin