Skip to main content
G
gatlas11-Garnet
11-Garnet
February 19, 2022
Solved

Why am I getting a zero in the Excel Component B1 cell?

  • February 19, 2022
  • 1 reply
  • 1131 views

Team,

Why am I getting a zero in the Excel Component B1 cell?

 

Note that I have been using Mathcad for decades. However, I've just started using Mathcad Prime.

 

Kindly see the attached worksheet. 

 

Best answer by Werner_E

Chances are you once double clicked the excel component and somehow change A1 in Excel. Whenever you did this, the value will remain until you manually change it again.

I created the very same component from scratch in your sheet and did not experience the zero I also see in the component you created.

Werner_E_0-1645287305907.png

 

1 reply

W
Werner_E25-Diamond IAnswer
25-Diamond I
February 19, 2022

Chances are you once double clicked the excel component and somehow change A1 in Excel. Whenever you did this, the value will remain until you manually change it again.

I created the very same component from scratch in your sheet and did not experience the zero I also see in the component you created.

Werner_E_0-1645287305907.png

 

G
gatlas11-GarnetAuthor
11-Garnet
February 19, 2022

Thanks! I tried it again and it worked. I don't recall "double clicking."

\

Terms & ConditionsAccessibility statement