When I ended up getting this error, the first thing I checked was whether there are any hidden instances of EXCEL and there were none!!!
I was thinking that probably “Reduce Excel File size” option was causing the problem (not sure why I thought that way, maybe because it was not reducing the file size), so I disabled it and went ahead with a refresh.
I was under the impression that I’ll get the same error but to my surprise the refresh went fine!!!
Now I wanted to prove that it is because of “Reduce Excel file size”. I enabled the option, performed a refresh believing that I’ll get the error and I could file a bug (or even curse people).
Nope again no errors!!!! This was a forgotten story and then yesterday a colleague of mine called up and asked “Have you seen this error?” (You should have seen the smile on my face).
He was going to re-create the sheet and I advised him not to, “Just perform a refresh”. (with a heavy tone) (He might have thought this guy is crazy, didn’t say anything and went with the refresh).
He didn’t get the error and his refresh returned data from Essbase.
Back of my mind I wanted him to get the error and prove that it was because of “Reduce Excel file size”. But it seems like that is not the reason.
If you are getting this error, wait for some time (or even disconnect your connections), and perform a refresh.
I’m listing out possible solutions for the error here.
- Check whether you’ve a correct version of Smart View/ EXCEL Add-in
- Check for hidden EXCEL instances, close them and perform a refresh.
- Perform a refresh and see whether it solves the issue.
- Check whether you’ve any EXCEL formulas that is returning strings.
- If there is another solution please post it here. 🙂