My What-if data table is showing the right values

MacyInvests 

 

How nice! 🙂

 

Your sample workbook contains formulas that refer to another workbook, so they all return #REF!