It's just today that I ran into that error in a file processed by a macro and after some testing found a workaround. So maybe it will help some of you out there...
Smart View 220.127.116.11
XLS 2010 using Citrix (I suppose W2008?)
Here is how:
Why does it work?
By using the alterantive above we show Essbase where to find the actual retrieval area. Essbase assigns a name to the Excel area you selected and identifies it by its name. To manipulate the area Essbase uses/recognizes, use Excel's >Formula >Name Manager. Some more interesying testing can be done with that....
The binary spreadsheet table token error is caused by passing more than 65,535 consecutive blank cells to the Essbase Grid API (which is used under the covers by Smart View). By defining a name for the retrieval range, you no longer have that many consecutive blank cells.
Applied OLAP, Inc
We have started to advise the following steps:
- Place all POV-members manually into one single row above the refresh area, i.e. eliminate all members from the POV window in case this holds four your analysis
- Add a new worksheet to your workbook in Excel (you may even want to start with an entirely new workbook)
- Connect the new worksheet to the database in question and select ad-hoc analysis (or refresh) to establish an active connection and to test it. Delete all members from the sheet. (This step may seem superfluous, but helped to prevent a new Binary-error in some of the cases we had.)
- Copy the entire refresh area from the 'corrupted' sheet with the Binary error to the newly added sheet. Be sure to include all members from the header, the columns and the rows.
- Run a refresh