Hello. I have an excel spreadsheet that I use to create pivot table reports. Once the reports are refreshed they are copied to a new workbook to send to each individual salesperson to evaluate. The problem I am having is the drop down menus that are originally in the reports before copying to a new work book are lost once they are moved to a new workbook. I understand that this is because the cell reference is in the original workbook but is there a way to have these drop downs stay in the work sheet?