I created a file in excel 2016 in which 3 tables from 3 separate tabs are pulled into one table. There are some calculations that I created to the right of the appended table that need to automatically update when new lines are added to the raw data tables. This functionality works fine when I do it in excel 2016.

However, I sent the file to someone with Excel 2013 (They have the power query add-in) and for some reason when they update the file all of the calculations to the right of the appended tab read "#NAME?" The formulas show up in the cell however it is not pulling the information from the appended table correctly.

Is there different steps to updating a file using excel 2013?



Any Feedback is appreciated!