Ah, sorry, yes was forgetting that the updates only seem to affect the Excel 2010 bits.
I am running Excel 2013, and I’d have to say that I do find the PowerPivot designer in it buggy. I’ve often broken it. By comparison, the designer in SSDT seems really solid. Given that it looks like the same code, it just must be a challenge in being a complex Excel add-in. Does this setting help with the recalc problem: 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: Corneliu I. Tusnea [mailto:[email protected]] Sent: Tuesday, 9 April 2013 10:12 AM To: Greg Low Cc: ozDotNet Subject: Re: PowerPivot? Greg, I don't have SQL installed and I can't seem to find any update for PowerPivot for Excel 2013 (not 2012!). I'm also using PP with a remote OData feed not with SQL ... which makes it much slower (sidenode: the continuous refreshes while changing column formulas are really annoying :)) Regards. Corneliu. On Tue, Apr 9, 2013 at 9:14 AM, Greg Low <[email protected] <mailto:[email protected]> > wrote: PowerPivot updates come in the SP’s and CU’s for SQL Server. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 <tel:%2B61%20419201410> mobile│ +61 3 8676 4913 <tel:%2B61%203%208676%204913> fax SQL Down Under | Web: <http://www.sqldownunder.com/> www.sqldownunder.com From: Corneliu I. Tusnea [mailto:[email protected] <mailto:[email protected]> ] Sent: Tuesday, 9 April 2013 9:09 AM To: Greg Low; ozDotNet Subject: Re: PowerPivot? Is there an SP1 already for Office 2013? I'll check and install. On Tue, Apr 9, 2013 at 8:59 AM, Greg Low (GregLow.com) <[email protected] <mailto:[email protected]> > wrote: 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 <tel:%2B61%20419201410> mobile│ +61 3 8676 4913 <tel:%2B61%203%208676%204913> 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
<<image001.png>>
