I'm already in Manual mode as Automatic makes it really useless as it's calculating/refreshing almost on every click in a cell. Even in Manual it does a lot of odd refreshes/updates whenever I change formulas or change the column names in the grids without actually recalculating ...
On Tue, Apr 9, 2013 at 10:23 AM, Greg Low (GregLow.com) <[email protected]>wrote: > 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 4913fax > **** > > SQL Down Under | Web: 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]> 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 mobile│ +61 3 8676 4913fax > **** > > SQL Down Under | Web: www.sqldownunder.com**** > > **** > > *From:* Corneliu I. Tusnea [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]> > 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 mobile│ +61 3 8676 4913fax > **** > > SQL Down Under | Web: www.sqldownunder.com**** > > **** > > *From:* [email protected] [ > mailto:[email protected] <[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]> 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]> 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>>
