Skip to Content
0
Former Member
Dec 29, 2011 at 03:57 PM

Error during Preview...Too many rows?

39 Views

Hi All,

I am running Xcelsius 2008 SP3 build 12,3,0,670.

When I try to preview or export my dashboard, I get a message that an error has occurred and to contact the administrator. I have researched the forums and tried everything that was suggested, uninstalling/reinstalling, exporting my spreadsheet and reimporting to reduce size etc.

In troubleshooting, I have determined that the error starts when I change my VLOOKUP formulas from looking at 1000 rows to 5000 rows. Unfortunately my dashboard will have about 6000 aggregated rows handling 22 metrics for 11 facilities, each facility having 9 units by the end of the year. This information is to be displayed in a scorecard fashion.

What is driving up my record count is that the users want a 'top 10' listing for each facility / unit. This information will display separately, however it does add to my record count.

Can anyone suggest how I can get around this issue? Would upgrading to SP4 help in any way?

Thank you in advance