Skip to main content
M
MA_99653081-Visitor
1-Visitor
July 6, 2021
Question

Excel-Analysis loses Excel-spreadsheets and create new one

  • July 6, 2021
  • 2 replies
  • 3481 views

Dear Creo community,

i would like to control the lengths of my parts in an assembly with an excel spreadsheet.

That works with an excel analysis and relationships for a while.

 

But if I save and reopen the assembly and want to edit the Excel analysis, a new Excel spreadsheets is created with the existing lengths. The name is different.

Changes in the new Excel table have no effect on the model. Neither do changes in the linked Excel spreadsheets. Not even after editing the analysis and regenerating the assembly. if I want to edit the Excel again, a new Excel spreadsheets is created with the old lengths.

 

In the company we use Windchill. The Excel Excel spreadsheet is not saved in Windchill but on the desktop.

 

Do you have any idea how I can fix the link between Creo and Excel spreadsheets?

Do I need to save the Excel spreadsheet in Windchill? How would that work?

 

With best regards Morian

2 replies

tbraxton
22-Sapphire II
tbraxton22-Sapphire II
22-Sapphire II
July 6, 2021
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.
M
MA_99653081-VisitorAuthor
1-Visitor
July 7, 2021

Thanks @tbraxton for your answer. 

I found this logic in the manual. Can you tell me how to create this Config option?
What happend if it does not find any .xls file with this right name? 

Even if i save the File in my current work space (Creo_Work_dir)  it does not keep the link.  I got an Workspace in Windchill where i save my parts an Assemblys but i dont know how to upload an .xls file.
Does anybody know?

Greeting Morian

 

tbraxton
22-Sapphire II
tbraxton22-Sapphire II
22-Sapphire II
July 7, 2021

You can avoid the Windchill issues by launching a standalone Creo session (not linked to Windchill). 

 

The config option is defined in a config.pro file.

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

 

There are issues with Windchill and Excel analysis documented, refer to this document which may be relevant to your situation.

https://www.ptc.com/en/support/article/CS32944?&language=en&posno=1&q=cs32944&source=search 

S
SP_101149361-Visitor
1-Visitor
December 6, 2021

@MartinHanak can you provide solution to this?

 

Please explain this article.

https://www.ptc.com/en/support/article/CS32944?&language=en&posno=1&q=cs32944&source=search

 

M
mbuonfiglioli14-Alexandrite
14-Alexandrite
December 6, 2021

The solution is the one explained above, in terms of practice, you need to have a first initiated local excel file in your preferred folder, and never rename it.

After you need to maintain suppressed the excel analysis, and you will need to resume only when you need and after suppress it again.

This to avoid to make system to automatically recreate a new file in the attachment of Windchill, because this will fail, because another file already exist with the same name.

The solution described by me have the scope to save the result of the analysis when the model / Analysis change, without the needs of overwriting the excel file.

    Terms & ConditionsCookie settingsAccessibility statement