We have an Excel file made in Excel 2007 that uses Data Validation (List) to generate a drop-down list from a range of cells on a different sheet:
When opening the file in Excel 2013, the drop-down box is empty because the cell range has been changed to B98:B101, where the data is located in cells B62:B65 on the 'Lookup Tables' sheet. Opening in Excel 2007 (on a non-upgraded workstation), the drop-down list is showing correctly, with the correct cell range, but in 2013, the cell range has shifted 36 rows down. Any idea why this would be and should I be worried that other formulas/lookups in the file may have also shifted?
This issue was explored extensively here:
http://www.ozgrid.com/forum/showthread.php?t=150080
Per the final posting on this thread this can be resolved by downloading the MS Office Compatibility pack. Regards,