Solved

Project 2010 - Unable to Create a new project from an existing xlsx file

Posted on 2012-03-14
2
769 Views
Last Modified: 2012-04-17
When I click on the icon to create from existing spreadsheet, my open file dialog box appears , I choose my workbook file and then ... nothing.

I tried "repairing" my installation of project 2010 to no avail.
0
Comment
Question by:brothertruffle880
2 Comments
 
LVL 12

Expert Comment

by:thausla
ID: 37759921
Hi,

not sure how to answer this based on the information given. Can you please add some more information about the Excel file you try to open? Has this file been exported from MSP2010 before, have you used an export map to create it? Or can you upload the file here?

Regards

Thomas
0
 
LVL 18

Accepted Solution

by:
xtermie earned 500 total points
ID: 37783201
Hey...seems like you are trying to import into Project 2007 or 2010 something in xlsx format.  Note that Project 2007 or 2010 can import information from .xls format that Excel 2003 supports but not from .xlsx format.

You can try:
(1) save the .xlsx file as Excel 97-2003 in order to be able to import it in MS Project 2007.
(2) save the .xlsx file in csv format is also a valid workaround.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Agile and Scrum have almost become synonymous. Have you wondered what's the difference? Scrum is just one way to be Agile. It is the most popular which leads to the common confusion. Agile actually refers to a philosophy shared by group of developme…
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question