Re the spreadsheet, it's actually not macro execution that is the problem, but the auto-calc. You can force a manual recalc by pressing F9 (on a PC) or cmd= (on a Mac), or change the setting to auto-calc. I usually save them as auto-calc, but I forgot in a few versions.
To see fares other than business class, choose the appropriate class from the in-cell drop-down menu.