I am using EPM 126.96.36.199 and I have office 2010 and excel addins 188.8.131.52. While retrieving I am getting the below error. I tried the solution provided in the link "http://oraclebrasil.wordpress.com/2011/11/09/error-essbase-has-encountered-an-internal-excel-error-when-retrieving-in-excel-with-essbase-excel-add-in-11-1-1-3/" but since I am having around 500 columns I am loosing the the columns after 256 while saving it as 'Excel 97-2003 Workbook’ .
Error: “Essbase has encountered an internal Excel error. Your sheet will not be overwritten and none of your data will be lost. However, you are strongly urged to exit Excel and restart in order to clear up the problem”
Can you please advise.
Think about using Smartview (since you are having 500 columns, that's too many columns if you ask me). Or split your sheets in such a way that it has only 256 columns.