PDM can only deliver data to the ‘custom properties’ of the Excel file.
From there, you have to use Exel functions to map that custom property to a cell within the file itself. There are several Excel functions that push/pull data between custom properties and cells. These functions can also vary between the many versions of Excel that run out there, so it’s also important to consider ensuring all users in your environment have the same version MS Office.
Thanks Nadia for your response.
i couldn't get what you mean exactly, i really know the cycle for PDM with Excel files.
data card value to custom property value to cell value
but at last step if the cell is equal to another cell, nothing happened.
is this a limitation ? or there is something to do.
Sorry for shorthand, on phone.
Open the excel file, go to file, info and you should see a link named ‘properties. Click on that, navigate to the tab named ‘custom’.
(can’t figure out how to insert photo from
If you see data there from PDM, PDM has done it’s intended job successfully. To push this data from this location into a cell within Excel file, it requires a Excel function that PDM has no ability to control. Similar to Solidworks Drawings, the file itself may need to be rebuilt or reloaded for the Excel function to execute. Most common Excel function used is ‘Link to Content’ but this may not be function consistently with older versions of excel. Other Excel functions are available as well that only push (or pull) data from custom property to cell, thus creating a one direction data push.
If data is missing from PDM is missing from that custom property tab on the Excel file itselr, you’ll want to look at your PDM card and variable configuration.