Unable to import/export Excel spreadsheets

Issue:

I have Microsoft Office and Excel 2003 / 2007 properly installed on my computer. I’m getting an error message, “Could not perform this operation because Microsoft Office Excel is not installed on this machine”, when I try to import employee data from an Excel spreadsheet or exporting reports to Excel.

Resolution:

Solution

If you are having difficulty with the latest version of Snap Schedule, then you might want to re-install the Microsoft Office .NET Primary Interop Assembies (PIA). On some machines the Microsoft PIA may not get installed when the Office software is installed. If there is no .NET framework installed on the machine when Office is installed, then sometimes Microsoft Office installer will not install the PIAs. If, however, there is a .NET framework on the machine, then the Microsoft Office installer would install the PIAs.

Snap Schedule 2010 is a .NET software application and requires the PIA to work with Office products. So if the PIAs are not installed, Snap Schedule cannot communicate with Microsoft Office and in fact doesn’t even know that Office has been installed.

Schedule Faster with Snap Schedule
Scheduling, timesheets, attendance & cost controls, shift trade/pickup and more.

No installation. No download. Work anywhere, anytime, on any device.

Office 2003

To resolve this situation if you have Office 2003, re-run your Office 2003 setup and make sure that the .NET Programmability Support option is checked. Refer to Microsoft Knowledgebase article http://msdn2.microsoft.com/en-us/library/aa159923.aspx for more information.

The basic idea is to:

  • Run the Microsoft Office 2003 setup and select the “Add or Remove Features” option
  • Select the “Choose advanced customization of applications” option and click Next
  • Expand the “Microsoft Office” and then the “Microsoft Office Excel” options and set the “.NET Programmability Support” option to “Run from My Computer”
  • Click the Update button

This will add the PIAs for Excel to your Office installation. You can also add PIAs for the other Office family products if you wish, but Snap Schedule does not use them.

If you don’t have access to the Microsoft Office CD, you can download the PIAs from the link below:

http://www.microsoft.com/downloads/details.aspx?familyid=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&displaylang=en

Office 2007

For Office 2007, the Office setup program will install the PIAs by default if the .NET Framework is present on the machine at the time of installation. If the PIAs were not installed, you can downloaded the PIAs from Microsoft using the link below:

http://www.microsoft.com/downloads/details.aspx?FamilyID=59daebaa-bed4-4282-a28c-b864d8bfa513&displaylang=en

Comments are closed.

Take Control of Your Employee Scheduling Today!
We'll Show You How.

Our product specialists will customize a demo that addresses each challenge, question, and goal you have—all at your convenience. No obligation. No risk.