PowerPivot in Excel 2013

Man O man!!!! I have recently started playing around with Office 2013 and I love it. It has a lot more facets that make regular excel user's lives easier. But this post is about an issue of using PowerPivot in Excel 2013. I started opening existing PowerPivot workbooks (created in Excel 2010) in Excel 2013 and whenever I navigated to the PowerPivot ribbon, all the options were always disabled. I thought for a second that there might have been a problem with the installation and I might have missed an option while installing Office 2013. But then barring the fact that Visio 2013 is still a seperate installation, there was  absolutely no problem with my Office 2013 installation. Then I tried reopening the workbooks in Excel 2010 to just verify that these were not corrupted in any fashion and thank the gods above!!! they weren't. So that got me thinking that the consumer preview of Office 2013 might not have PowerPivot enabled. Was just about to ping someone in the Office team when a post by Jason Volpe caught my eye..... It seems that PowerPivot for Excel 2010 and 2013 are two different add-ins. I probably would never have guessed this. So to enable PowerPivot in Office 2013....just follow the steps in Jason's post as mentioned in the URL below:

http://www.jasonvolpe.com/2012/07/how-to-activate-powerpivot-in-excel-2013/

I am now in the process of evaluating PowerView in Office 2013 (oh yeah!!! No longer only integrated with SharePoint) making it easier for offline users to create powerful visualizations with PowerPivot data.

So when you try and open a PowerPivot workbook (from 2010) without a pivot table or a pivot chart in it, you might run into a couple of issues with Excel 2013. Save the PowerPivot workbook (in 2010) with a Pivot chart or Pivot table in the workbook and the migration will be successful. The next issue while creating a Power View dashboard within 2013 might lead to a memory exception the first time. Close all the instances of Office 2013 and then open Excel 2013. Create a PowerPivot and a Pivot table or chart associated with the same or open an existing PowerPivot workbook. (Prior to this ensure that Microsoft PowerPivot for Office 2013 and PowerView is checked as shown in the screenshot below)

 After this when you click on the Power View option it will take a while for the Power View to jet start but once it does ......... lets get ready to Ruuuuuuuuumble!!!!!!!

Comments

Post a Comment

Popular posts from this blog

An Agile process evaluation

In the recent past, I have been working as a scrum master for one of the projects. And since there were two folds to this project, a portion being handled onsite as well as a portion being handled offshore, there were initial hiccups that gradually deteriorated away. But here comes the crux of the problem and where an Agile process has to be evaluated.         We had weekly sprints where a subset of tasks were to be completed and we have a daily scrum between the offshore and onsite team. But the onsite team were persistent on a daily mail sent with the changes being addressed. Now the point of the scrum is to take into account who, what and where the changes have to be made based on the product backlog. Now having status mails as part of the Agile process is indeed a flaw in the fundamental flow. After pointing out this fact, I was counter attacked with several points (some of which were valid to have a status update email) and finally left to comply. Now here comes the seconda
Read more

My entry into ET Prodigy

I would like to consider myself as some sort of a prodigy (ahem!!! cough persisting for some time). This is my entry into the ET prodigy contest that took place last month. I must say I could have presented my understanding better but I had to follow the competition guidelines to the "T". Here it is: Sustain World (SW) provides services towards existing small scale ventures that have a foothold in the market place or to educate individuals or institutes and channeling their energy into setting up their businesses. The maximum acceptable annual income of its target audience would be 45,000 Indian Rupees(INR). The variable costs for Sustain world to come into existence would be somewhere between 4 lakh INR. Now there is an extremely high probability that most of the small scale ventures undertaken by individuals in the case of SW will never evolve from the proof of concept stage or might die in the nascent stages of creation. SW more or less will have a well sustained and aggr
Read more

Rhino - ETL

Image
Using Rhino-ETL ( a C# based) framework for developing standard ETL's is pretty easy and one can do a lot of fun stuff with the underlying source data. I just wrote up a quick console app to generate data into a text file and push the same data into a table in SQL Server as well as an external file. Here are the following steps (for the external file push): 1. Create a new C# console application solution in Visual Studio. 2. Target the .Net framework as shown in the below screen shot in your project properties:- 3. Create 3 Sub Folders underneath your project as shown in the following screen shot DataObjects --> Contains the class files associated with each and every table/file in your environment. Example:- if your source file contains student data, then you would create a class file called Student with the individual properties (in relation to the properties) exposed (nouns). Operations --> This primarily contains the class files that contain the activities (a
Read more