Problem:

A Named Range in an Excel spreadsheet can theoretically have 1,048,576 rows and 16,384 columns. However the Microsoft ODBC driver will only process the first 256 columns.

Issue:

As one would expect, a Named Range of this size can have performance implications when uploading a spreadsheet to the iDashboards Cloud.

Resolution:

iDashboards has imposed the following Excel Named Range constraints:

A Named Range cannot have more than 255 columns. If it does, iDashboards will stop reading after 255 columns. Customers will get a warning about this when uploading a spreadsheet.

Customers can still use column ranges (where the whole column is selected to create the Named Range) but 200 consecutive blank rows in a named range will be interpreted by iDashboards as the end of the named range. That is, no data after 200 consecutive blank rows in a Named Range will be processed. This ‘truncation’ is silent, no warning will be issued to the user.

The following articles discuss Excel specifications and limits.  This link speaks to Excel 2003.

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx

This link speaks to Excel 2010.

http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx

Applies To:

• Eval Cloud
• Cloud Standard
• Cloud PAL
• Private Cloud