Hi, this question was asked by my manager. If anyone can help me, that would be great

My Office was using Excel 2003 like till the previous year. They had 2 excel 2003 files, whenever there is a change in one file, the other file would update with the same changes and it would provide a dialog box before proceeding to confirm the changes or update.

But, we've recently switched to Excel 2007. So, we've an old Excel 2003 file and Excel 2007 file. Whenever there is a something changed in Excel 2007, Excel 2003 updates without any confirmation. There is no dialog box that asks to link the files. Is there a setting that I should enable or maybe there is no such setting in Excel 2007.

Please help. I will be waiting for an answer....