HOME  |  KNOWLEDGE BASE  |  HOW TO BUY  |   MY PROFILE 

US & Canada 1-800-786-8545 / International 1-360-292-4050
SEARCH:


X-Links That Cannot Be Updated in Excel

  • Print this page
    Print this page
  • Remove Highlighting
    Remove Highlighting
  • Edit this Article
    Edit this Article
  • Export to PDF
    Export to PDF
X-Links That Cannot Be Updated in Excel

If you receive this dialog, your excel sheet workbook page may contain broken links when trying to read data from PIPE-FLO. By pushing the Update button, it should update your links automatically.


If your links do not get updated automatically, you will receive the following dialog. You may choose to view your excel worksheet with broken links by clicking Continue, otherwise you will need to update the location of your source file by clicking Edit Links...




How to Update the Location of Your Source File:

1. If you have received the dialog indicating, "This workbook contains one or more links that cannot be updated," click Edit Links...



2. Click Change Source...



3.
In your file browser, find your PIPE-FLO Professional install folder. (The default location is C:\Program Files\Engineered Software\PIPE-FLO Professional) If you are unsure where your PIPE-FLO Professional folder is installed or if you cannot access it, please contact your network administrator to help you locate or access your PIPE-FLO Professional folder.



4. After you have found PIPE-FLO Professional install folder, select the file Query_addin.xla. Click OK.



5. Close Edit Links dialog.


Your links should now be updated.

If your X-Links are still not working correctly, you will need to re-install X-Link. Close Excel and PIPE-FLO. Download the file attached to this article called XLINK.EXE and double click it to run the X-Link installer. You may need to repeat the "How to Update the Location of Your Source File" steps if your links are still broken.

If your X-Links are still broken, please contact Technical Support.

Related Articles

No related articles were found.

Attachments

Article Details

Last Updated
29th of December, 2009

Version
2005, 2007, 2009

Program
PIPE-FLO Professional

Operating System(s)
Windows 2000, Windows XP

Would you like to...

Print this page Print this page Email this page Email this page Remove Highlighting Remove Highlighting Edit this Article Export to PDF

User Opinions (0 votes)

No users have voted.

How would you rate this answer?



Thank you for rating this answer.

Visitor Comments

No visitor comments posted. Post a comment

Post a comment

To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.

Entering your email address is optional. It will not be displayed on this page, but may be used by our staff to contact you regarding your comment.

For technical support, please do not use this form. Use our Web Support Form or email solutions@eng-software.com, instead.

   Name:
   Email:
* Comment:
* Enter the code below: