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

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

  • March 4, 2021
  • 1 reply
  • 2541 views

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.

 

Best answer by Werner_E

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.

1 reply

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.

ssato15-MoonstoneAuthor
15-Moonstone
March 4, 2021

Hello Werner-san

 

Thank you very much for your response.

Your attached file is no problem.