Exel BOM

Please excuse my ignorance but when you save a BOM as 2007 Excel file you lose all associatively with the assembly it was derived from and you cannot link columns to custom properties like in a design table. Is that correct or am I missing something. I know I’m looking like the dummy right now but if I don’t ask I won’t know.

SolidworksBill Of Materials