Hi;

I have a Bill of Material excel file that has a title block. Most of the cells in that block are linked to properties. The excel properties exctract the metadata from the project folder that the file resides in. Everything is good.

Sometimes we have to create multiple iterations of the BOM, so we copy the tab over and add a -XXX to the BOM number for the tab name and in the title block, make the needed changes, and then save it. When you look over the cells that have the properties they appear OK.

If I now make changes or add to the metadata in the project folder the properties for the excel file capture this and populate the appropriate cells. Except this only happens on the original tab and not any of the new tabs. And it won't even happen on the first tab unless you save the file with the first tab active.

Is there some way to make it so that the properties update through all the worksheets and that I don't have to have everyone always save on the original tab?

Thanks;