Does anyone know if it is possible to link data in another excel workbook to a power pivot table in another workbook?
i.e when the excel data is updated so is the table in power pivot
If it is not possible can anyone suggest the most streamlined manual way of doing this?
Any links to tutorials etc. would be much appreciated..