This semester I am taking a Statistics class from Florida Tech, and our textbook from Pearson includes a statistics addon for Excel called PHStat2. It is apparently included in many Pearson textbooks, so even students not in a statistics class may need to use it. I have been running Office 2010 since the Tech Preview release, and am now running Office 2010 Beta x64 on my computer. It works great and has even run some other addons (especially ones for Outlook) without any problems. However, when I installed PHStat2 and tried to start it, I was greeted with this friendly error:
Ouch. I knew it had installed properly, but just to be sure, I reinstalled it and sure enough, I received the same error message. I didn’t want to reinstall Office 2007 just for this class, so I tested it on Office 2010 x86 (the standard 32 bit version) in Virtual PC. Guess what? It worked! Turns out, the only problem before was that the addin wouldn’t work correctly in the 64-bit version of Excel.
Will PHStat2 run on your version of Office 2010?
If you’re also running Office 2010 beta on your computer this semester, you likely can still use PHStat2. Here’s what I’ve found from testing in various configurations:
- PHStat2 runs perfectly in Office 2010 Beta Professional and Home and Business. This includes the standalone x86 (32-bit) standard installer and the Click2Run (C2R) installer that “streams” the apps from the internet. I encountered no problems whatsoever with it.
- PHStat2 does not run in Office 2010 Professional 64-bit (x64). It comes up with an error message stating that it cannot find the required PHStat2 file. This is not entirely surprising, as it is known that many plugins/addons do not work in the 64 bit edition.
- PHStat2 does not run in Office 2010 Starter edition. This edition does not support/run macros, and when you try to open the PHStat2 file it says it does not recognize the filetype.
Otherwise, every version of Office (and Excel) from 97 – 2007 should work fine. And, like I said, the standard install of Office 2010 beta works fine as well.
If for some reason you do not have a copy of Microsoft Office or Excel on your computer, you can actually download a free beta copy of Office 2010 from. This will run until October 2010, so while not a full fix, it will at least more than get you through this semester.
Also, if you have a Mac and are running Office 2003 or 2008, I do not believe PHStat2 will run on your computer. However, if you have a copy of Windows running in Bootcamp or Parallels/Fusion, then you could run Office 2010 beta in it (free download from http://us1.office2010beta.microsoft.com/default.aspx?culture=en-US – will run until October 2010) or an older version of Microsoft Office and just do the exercises in the Windows version of Excel.
Also, there may be an update for the version of PHStat2 that came with your textbook, so check their website at http://www.prenhall.com/phstat/ to see if one’s available. There was an update for mine, and my book was recently published, so be sure to check.
Macro Security
Please note that you may have to accept an “Enable Macros” dialog whenever you run PHStat2. You can change your security settings to always accept the PHStat2 addin by going to File, Options, Trust Center (click on the “Trust Center Settings” button in this dialog), and then select the Trusted Locations tab. Click on the “Add New Location…” button, and browse to PHStat2’s folder (usually C:\Program Files\PHStat2). Once you’ve pressed Ok in the dialogs, PHStat2 should be fully approved and you should not have to click through the “Enable Macros” dialog for it again.
If you encounter any issues with this, let me know and I’ll see if there’s a solution. Have fun with statistics!
…………………………
Related posts:
- Students: Upgrade to Office 2010 and Windows 7 the Cheap and Easy Way
- What’s new in Office 2010?
- Get a Steal on Office 2010 today
- More free eBooks from Microsoft Press
- How to install a network printer on Windows 7 x64
