If you are new to ExcelStartup PowerShell module please read the previous post Shortcuts to start Excel with or without PowerPivot add-in.
A very good observation from Dan English (blog | twitter) made me do a small but important change in the behavior of the ‘Excel only’ shortcut.
Here’s the excerpt from the Dan’s full post that you can read here http://denglishbi.wordpress.com/2010/10/08/where-did-my-excel-powerpivot-tab-go-follow-up/
“One thing to watch out though is that if you don’t use the shortcuts to access Excel the next time that it will load up the last option that you ran. This means that if you do the ‘Excel Only’ shortcut, close Excel, and then click on the Excel shortcut in the start menu that Excel will load normally (without PowerPivot add-in). To enable the PowerPivot add-in you can follow my steps in the posting above or simply close Excel and then double-click the ‘Excel with PowerPivot’ shortcut on your desktop.”
So, as of v1.1 the “Excel only” shortcut has been changed to disable PowerPivot add-in for the current Excel session (process) only. This enables users to start Excel with PowerPivot by clicking on Excel associated files or just typing Excel in run dialog etc.
If for any reason you want to switch to the old behavior edit the ‘Excel only’ desktop shortcut, click on the Shortcut tab and remove the parameter -reset from the shortcut target.
The link to the download is here: ExcelStartup PowerShell module installation guide.
Thank you all for your interest and support.
You love PowerPivot but you hate waiting for Excel to load just to do something quick-and-dirty?
Thought so, me too! Here’s a quote from Dan English’s blog (blog | twitter) I came across while my PowerPivot add-in wouldn’t load (btw., I had to edit the registry to resolve the situation but that’s another topic):
The other day I launched Excel 2010 to do a quick calculation and changed my mind. By changing my mind I didn’t mean that I didn’t want to perform the calculation anymore, just decided I didn’t want to wait for Excel 2010 to load. The reason that it takes a while now to load is the additional add-ins that I have installed which includes PowerPivot. As long as theses are activated they need to be loaded each time. Needless to say I am somewhat impatient and decided I would simply use another application to perform the calculation so I cancelled Excel during the load process.
You can read the full post here: http://denglishbi.wordpress.com/2010/06/21/where-did-my-powerpivot-excel-2010-tab-go/.
Dan has been kind enough to write an update of the mentioned post and you can read it over at his blog: http://denglishbi.wordpress.com/2010/10/08/where-did-my-excel-powerpivot-tab-go-follow-up/. Thanks Dan.
Well, it’s been more than a month now since I’ve created some PowerShell scripts that would get called by clicking on my two custom desktop shortcuts. And finally as I’m off work for the last couple of days , I was able to wrap it all up for others to download and use.
ExcelStartup custom desktop shortcuts
Feel free to download the ExcelStartup PowerShell module installer and do provide some feedback over here or contact me on twitter.
I’ve written here the ExcelStartup PowerShell module installation guide to help you through the setup.
Note: As this is my first PowerShell script I probably haven’t done things in the way an experienced scripter would, so If you are such a person I would love to hear your comments and suggestions.
Special thanks goes to Dan who inspired me to write this script and kindly allowed me to use his name in this blog post.