I don't know....I'm sorry that I wasn't able to help.
I opened it up and used the Scrap Sales 2011.xls before I attached it and it worked for me.

Hopefully someone more knowledable in VBA will chime in and help us figure out why it won't work for you.