Two spread sheets created in excel 2007 - spread sheet 1 has drop downs that look up data in spread sheet 2 on the C: drive. When we copy these spread sheets to excel 2013 in windows 8 the drop downs do not work. Note: We dragged and dropped sheet 2 to the C: drive as windows 8 didn't seem to want the file saved to the C: drive.

I hope this makes since to you pros out there - any questions, please let me know.

Thanks.