Is there a way to refresh a Pvt table while the workbook is in share mode? If there isn't let me know that too. Thanks Vick