There is probably a simple answer to this question.

I have just recently got Excel Bom's working (didn't work for years, I found out yesterday that our ACT! program was to blame) and tried to use an old BOM I had created years ago.  The problem I'm having is I'm getting the file name under Part No. instead of the actual part number.  I have my part numbers listed in the parts custom properties and the name box is labeled PartNo.  I'm not sure what I'm missing? I'm not very strong in Excel and I'm wondering if it's something simple I'm missing?  I have used regular boms for years but I would like to explore the possibilities of using Excel Boms...  Thanks for your time