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"
"reduce excel file size"
"Improve metadata storage"
