How to keep relation of excel and Creo always irrespective of Excel File location

[SM_9791973]

Hi,

I have created a 3rd model and I have created relations to drive its dimensions through excel.

I have called the excel into creo through Excel analysis tab available in analysis tab and created different Analysis feature so that it can take value from the excel & after that I have used that analysis feature in the relation so that it can drive its dimensions.

But once I changed the location of the Excel than the relations are not working. 

so, how to resolve this issue did I need to make new relations or how can we make the excel file location independent so that it does not affect the relations created inside the creo enviroment.

Any suggestions are welcomed...

Regards,

Shubham Mehta

[tbraxton]

You can define a path using a config option and place your excel file in this location.

When you save an Excel analysis or create an Excel Analysis feature, the system saves the complete path to the .xls file. When you retrieve an Excel analysis or when an Excel Analysis feature is regenerated, the system searches for the .xls file in these locations in the following order:

• The original location of the file from which it was selected for the analysis

• The current working directory

• The directory specified by the configuration option excel_analysis_directory.

[SM_9791973]

Thanks for the answer!

Could you help me by letting me know where I can define the path using the config option also where I can find that config option in the Creo?

Regards,

Shubham Mehta 

[tbraxton]

You can define the config option in your config.pro file. Here is the support link on config options.

https://support.ptc.com/help/creo/creo_pma/usascii/index.html#page/fundamentals%2Ffundamentals%2Ffund_five_sub%2FAbout_config_pro_options.html%23 

the config option can be found using the find option in the configuration editor. Use the full pathname for your folder.

The syntax will look like this

excel_analysis_directory full pathname

[tbraxton · Accepted solution]

It seems a solution has been provided for you. Please respond to the solution post so that it is marked as solved.