Clearing cache

To clear the cache, select Tools > Clear Cache then Active Worksheet, Active Workbook, or All Open Workbook.