Skip to main content
J
Joeboy1-Visitor
1-Visitor
October 20, 2012
Question

Reference files do not automatically update

  • October 20, 2012
  • 5 replies
  • 8177 views

I am attempting to insert a file as reference inside another file. My undersatnding is that if I change a value in the reference file that value is automatically transferred to the other file. I do not fine that this occurs. The only way I get files to update is to go through the entire insert===> reference process again. Am I missing something ? I am attaching the files in question. Any help would be appreciated.

5 replies

P
ptc-11768911-Visitor
1-Visitor
October 20, 2012

Mathcad references only read in the data from a saved version of the reference, at the time that reference is calculated. So if you are referencing values from file A into file B, and you change values in A, then you have to SAVE A and re-calculate the reference call in B. You can do this re-calculation by clicking the reference and press F9, or by closing and re-opening the sheet. (Doing a full-sheet recalculation doesn't re-calculate the references for some reason).

It's not like Excel where references update "live" if you have the two files open at the same time. You actually have to save the referenced file, then re-calculate the reference.

-
-MFra-21-Topaz II
21-Topaz II
May 22, 2020

based on my experience, the updated data in the reference file will be accessible to the other files, only after saving it, but also after closing it. In addition, you must also close the file that uses it. Only after reopening the latter will you find the updated data, otherwise they will not be updated.

N
nick41-Visitor
1-Visitor
May 22, 2020

I can't even get to that. Can you try? Attached are the 2 files I downloaded.  I can convert one (computation ...) of them to mcdx using the converter but the other one  (sizing....)cannot be converted. 

 

Can you give it a go?

V
24-Ruby IV
ValeryOchkov24-Ruby IV
24-Ruby IV
October 20, 2012

One solution of this problem - reference on absolute address in internet

http://communities.ptc.com/servlet/JiveServlet/showImage/2-190482-38879/RefUnits.png

R
RichardJ19-Tanzanite
19-Tanzanite
October 21, 2012

You don't need to do another "insert", "reference", but you do need to select the reference and hit F9 (using Ctrl F9 to update the entire worksheet will actually not update the reference).

N
nick41-Visitor
1-Visitor
May 22, 2020

Hi, I  was unable to convert your sizing ammonia tower metric file.  It shows the file as corrupt. 

Any ideas you have to resolve that. 

L
LucMeekes23-Emerald IV
23-Emerald IV
May 22, 2020

The file IS corrupt. Unless Dixie has a backup of the file, it cannot be reconstructed fully. I haven't seen Dixie on this forum for two years.

See https://community.ptc.com/t5/PTC-Mathcad/XML-files-will-not-open/m-p/551326#M180821

Success!
Luc

N
nick41-Visitor
1-Visitor
May 22, 2020

what can be salvaged? I might be able to build on that.

L
LucMeekes23-Emerald IV
23-Emerald IV
May 23, 2020

The 'Sizing..' file as posted by Dixie Griffin is corrupt.

Here is a corrected version in the sense that it should load in mathcad.

Take care! It does not mean that the contents is complete, nor that it is correct.

 

Success!

Luc

    N
    nick41-Visitor
    1-Visitor
    May 25, 2020

    Thanks, Luc.

    I can work with that.

    What did you "change"?

     

    Nick

    L
    LucMeekes23-Emerald IV
    23-Emerald IV
    May 25, 2020

    Compare the two files and you will know.

     

    Luc

    Terms & ConditionsCookie settingsAccessibility statement