does anyone know why we can not extract data from a shared workbook? or did i miss something? can not pivot table.