Skip to main content
ssato15-Moonstone
15-Moonstone
March 4, 2021
Solved

A server error occurred or the specified sheet name is invalid(mathcad15)

Hello everyone,

 

I attached data file.

 

I have error that is "A server error occurred or the specified sheet name is invalid".

 

Previously, this error did not occur.
What is the cause?

 

Thank you.

 

Werner_E
Werner_EAnswer
25-Diamond I
March 4, 2021

I had no problem opening your sheet, but the cause for problems sure is the embedded Excel component. I had a variety of strange errors in the past when I was using this component and consider it unstable an unreliable. When I had to use an Excel table as input I used the READEXCEL function.

Its also not necessary (and overkill IMHO) to rely on a full Excel installation just to provide the data embedded in the worksheet as Mathcad provides the tables for that purpose (menu: Insert - Data - Table).

I copied the data from your Excel component to a data table, deleted the Excel component and resaved the worksheet. It should open without problems, I guess.

View in thread

2 replies

Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
March 4, 2021

I had no problem opening your sheet, but the cause for problems sure is the embedded Excel component. I had a variety of strange errors in the past when I was using this component and consider it unstable an unreliable. When I had to use an Excel table as input I used the READEXCEL function.

Its also not necessary (and overkill IMHO) to rely on a full Excel installation just to provide the data embedded in the worksheet as Mathcad provides the tables for that purpose (menu: Insert - Data - Table).

I copied the data from your Excel component to a data table, deleted the Excel component and resaved the worksheet. It should open without problems, I guess.

Translate
    ssato15-MoonstoneAuthor
    15-Moonstone
    March 4, 2021

    Hello Werner-san

     

    Thank you very much for your response.

    Your attached file is no problem.

     

    Translate
    Terms & ConditionsAccessibility statement