Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X
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
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
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.
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
The Excel Analysis (later called "excel.A") feature files are uploaded as Attachments, and you can find in Content tab;
But is there a problem, because, when you create the first time the excel.A creo will look every time the same file, and even if you solved the problem of setting the correct path in the option, when you will save as your Creo model containing the excel.A, the system as first behavior, when you will try to modify or edit the excel.A, it will search for the file (later called "base.F)" you stored I.e in the working directory, and if you do not remove form that folder, or rename, the excel.A will work good;
Now is arriving the very big problem, when you will try to upload the 3d Model the system will fail, saying (Correctly), that the base.F conflict with the one existing in Windchill.
Now I fonund a temporary solution to this:
Pointing that you solved before and put the base.F, in reachable folder (in may case working directory), excel.A will not fail:
The result in Windchill should be the 3d Model, containing in the attachments the Datum.F that is the result of your updated analysis.
Remember that you must not rename or deleted the base.F from your set folder.
I call this a temporary solution because is not possible that another solution more linear exist.
@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
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.