Problem with BPL contest spreadsheet

so i downloaded this awesome looking spreadsheet:

http://www.backpackinglight.com/cgi-bin/backpackinglight/2005_trip_planning_spreadsheet_contest_winners.html

the problem i have is modifying items in the "gear list" to "yes" doesn't change anything in the "packing list" Ive installed the necessary add-ons but nothing… what am i doing wrong?

also weights on "pack list" are list as "N/A" on their totals…??

im sure its simple… im just not understanding how to filter i think…

BTW, im using excel '07