I established a data connection from work Excel File to Another - both on SharePoint. The master file has a pivot table that was created from the data connnection file. When I add a line of data to the connection file, it does not update to the master file. I believe that it has something to do with a range becuase if I edit an existing row of data in the connection file, this change will reflect on the master file pivot table. It seems that only new lines of date will not update. I do not see anywhere in the conneciton file edit area that a range is involved.