Excel 2003 vs Excel 2010 with Smartview – Big data templates

A few days ago some customers of mine had troubles with Excel sheets created in Excel 2003 and opening in Excel 2010 with Smartview .

Excel will freeze, and will not work anymore. After some debugging and created a SR with Oracle we came across the following which solved the problem.

Open Excel - Smartview -> Options -> Advanced-> under Compatibility enable

"reduce excel file size"
"Improve metadata storage"