Hi Everyone - I am just curious - how long does it take your dashboards to load for a preview?
I am averaging about 2 minutes to get to the "Maximum rows message", then about another 1:30 to load the preview. The processer is pegged at 100% with 1.2 GB in the page file on average during the whole time. No other apps are running.
I think my company pc is ancient (specs below), but this just seems awful slow to me. All data is static on the sheet- no DB ties, and I have less than 200 rows on the longest tab. I converted all my nested IF statements & vloookups to index & match, but no noticeable performance boost.
System Specs:
Dell D600 Laptop
XP Pro SP3 (all updates installed)
1.86 GhZ Pentium M
2 GB Ram
Flash Player 10.0.22.87
Office 2003