I’ve been modifying an Excel workbook for our employees as it stopped calculating properly. I copied and pasted the data from the original workbook to a fresh one to work with and got it to calculate and function properly (the issue appears to be that the original workbook was calling upon a URL that no longer works to get data for some of the calculations).

However, even though the workbook now works properly on my device, when I send it to a colleague, they are no longer able to use the picklists that are contained in the workbook. I’ve tried this out and encountered the same problem when opening on a different device. How can I ensure that the picklists work properly? I’ve attached the error that occurs for one such picklist.

All devices that have been involved so far are Windows devices.

​I’ve been modifying an Excel workbook for our employees as it stopped calculating properly. I copied and pasted the data from the original workbook to a fresh one to work with and got it to calculate and function properly (the issue appears to be that the original workbook was calling upon a URL that no longer works to get data for some of the calculations). However, even though the workbook now works properly on my device, when I send it to a colleague, they are no longer able to use the picklists that are contained in the workbook. I’ve tried this out and encountered the same problem when opening on a different device. How can I ensure that the picklists work properly? I’ve attached the error that occurs for one such picklist. All devices that have been involved so far are Windows devices.   Read More

​