Thanks for posting the code! I seem to be having trouble with the refresh freezing on PowerPivot tables that are sourced from Excel files located on a network share and a SharePoint document library. Is the code designed to handle those types of data sources or will I need to modify it? |