Hi Corneliu,
Have you applied the SP1 and/or CU updates to PowerPivot? I found the designer in Excel painful at times. It certainly doesn’t have the stability of basically the same designer in SSDT. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: <http://www.sqldownunder.com/> www.sqldownunder.com From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of Corneliu I. Tusnea Sent: Tuesday, 9 April 2013 8:24 AM To: ozDotNet Cc: ozDotNet Subject: Re: PowerPivot? No VSTO. Just clean Excel + PP. no development tools installed at all. The crashes are all while editing formulas in the grids not when running pivots. Also my connection for data is over OData from a remote server which has a bit of lag at times. Regards, Corneliu. On 08/04/2013, at 8:25 PM, Arjang Assadi <[email protected] <mailto:[email protected]> > wrote: Are you using it through VSTO? on it' own I have only used it 1 per workbook and not with millions of records. 5000 records should very well be easy to handle. On 8 April 2013 18:34, Corneliu I. Tusnea <[email protected] <mailto:[email protected]> > wrote: Hi, Is PowerPivot considered a "Production" product? I'm running it on a W8+Office2013 and it's crashing like a beta product. I only have 9 worksheets and up to about 5000 rows in each and it's unusable. Once I start entering formulas it's practically crashing every few minutes. I now got it to a point where I can't even open it properly. <image.png> This is quite disappointing right now :( Am I missing something? Regards, Corneliu
