|
| |||||||||
| Tags: excel, importexport, project, tofrom |
![]() |
| | Thread Tools | Search this Thread |
|
#1
| |||
| |||
| Why won't Project Import/Export to/from Excel
Hello, I have a group of Project users who need to import/export to/from Excel however, they all get "Operation Failed" errors. We think it may be because of patch KB948962. Does anyone know anything about this? TIA, Rich |
|
#2
| |||
| |||
| Re: Why won't Project Import/Export to/from Excel
Hello Rich, Have you tried changing the "Allow legacy file formats" on the security tab in Tools > Options. I don't recall if this was in the SP-3 push or the security fix you mention, but I believe project works with earlier versions of Excel than 2003 when exporting. I am using Project 2003 with SP-3 and when I turn off the option to allow loading, I get a message saying I have to enable it. I hope this helps. Let us know how you get along. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project "rich" <rich@discussions.microsoft.com> wrote in message news:1A504728-906F-4671-AD6F-3A516CC22053@microsoft.com... > Hello, > > I have a group of Project users who need to import/export to/from > Excel > however, they all get "Operation Failed" errors. We think it may be > because > of patch KB948962. Does anyone know anything about this? > > TIA, > > Rich |
|
#3
| |||
| |||
| Re: Why won't Project Import/Export to/from Excel
Hi Julie - I'm getting the exact same problem, just a dialogue box with 'Operation Failed' and nothing else. I've tried using an existing map and a new map but it's all the same. I don't appear to have the "Allow legacy file formats" option on the security tab in Tools > Options. Peace. ANTHONY "JulieS" wrote: > Hello Rich, > > Have you tried changing the "Allow legacy file formats" on the > security tab in Tools > Options. I don't recall if this was in the > SP-3 push or the security fix you mention, but I believe project works > with earlier versions of Excel than 2003 when exporting. I am using > Project 2003 with SP-3 and when I turn off the option to allow > loading, I get a message saying I have to enable it. > > I hope this helps. Let us know how you get along. > > Julie > Project MVP > > Visit http://project.mvps.org/ for the FAQs and additional information > about Microsoft Project > > "rich" <rich@discussions.microsoft.com> wrote in message > news:1A504728-906F-4671-AD6F-3A516CC22053@microsoft.com... > > Hello, > > > > I have a group of Project users who need to import/export to/from > > Excel > > however, they all get "Operation Failed" errors. We think it may be > > because > > of patch KB948962. Does anyone know anything about this? > > > > TIA, > > > > Rich > > > |
|
#4
| |||
| |||
| Re: Why won't Project Import/Export to/from Excel
Hi Anthony, Do you have SP-3 installed? Try installing that and enabling legacy formats and see if that helps. I hope this helps. Let us know how you get along. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project "carricka" <carricka@discussions.microsoft.com> wrote in message news:2156B51E-931D-42FC-819B-871D3459366E@microsoft.com... > Hi Julie - > > I'm getting the exact same problem, just a dialogue box with > 'Operation > Failed' and nothing else. I've tried using an existing map and a > new map but > it's all the same. > > I don't appear to have the "Allow legacy file formats" option on the > security tab in Tools > Options. > > Peace. > ANTHONY > > "JulieS" wrote: > >> Hello Rich, >> >> Have you tried changing the "Allow legacy file formats" on the >> security tab in Tools > Options. I don't recall if this was in the >> SP-3 push or the security fix you mention, but I believe project >> works >> with earlier versions of Excel than 2003 when exporting. I am >> using >> Project 2003 with SP-3 and when I turn off the option to allow >> loading, I get a message saying I have to enable it. >> >> I hope this helps. Let us know how you get along. >> >> Julie >> Project MVP >> >> Visit http://project.mvps.org/ for the FAQs and additional >> information >> about Microsoft Project >> >> "rich" <rich@discussions.microsoft.com> wrote in message >> news:1A504728-906F-4671-AD6F-3A516CC22053@microsoft.com... >> > Hello, >> > >> > I have a group of Project users who need to import/export to/from >> > Excel >> > however, they all get "Operation Failed" errors. We think it may >> > be >> > because >> > of patch KB948962. Does anyone know anything about this? >> > >> > TIA, >> > >> > Rich >> >> >> |
|
#5
| |||
| |||
| Re: Why won't Project Import/Export to/from Excel
Hi Julie - No, we're on SP2. I'll talk to the system administrator and will get back to you as and when it's installed. Thanks for the prompt reply - it's much appreciated. Peace, ANTHONY "JulieS" wrote: > Hi Anthony, > > Do you have SP-3 installed? Try installing that and enabling legacy > formats and see if that helps. > > I hope this helps. Let us know how you get along. > > Julie > Project MVP > > Visit http://project.mvps.org/ for the FAQs and additional information > about Microsoft Project > > > "carricka" <carricka@discussions.microsoft.com> wrote in message > news:2156B51E-931D-42FC-819B-871D3459366E@microsoft.com... > > Hi Julie - > > > > I'm getting the exact same problem, just a dialogue box with > > 'Operation > > Failed' and nothing else. I've tried using an existing map and a > > new map but > > it's all the same. > > > > I don't appear to have the "Allow legacy file formats" option on the > > security tab in Tools > Options. > > > > Peace. > > ANTHONY > > > > "JulieS" wrote: > > > >> Hello Rich, > >> > >> Have you tried changing the "Allow legacy file formats" on the > >> security tab in Tools > Options. I don't recall if this was in the > >> SP-3 push or the security fix you mention, but I believe project > >> works > >> with earlier versions of Excel than 2003 when exporting. I am > >> using > >> Project 2003 with SP-3 and when I turn off the option to allow > >> loading, I get a message saying I have to enable it. > >> > >> I hope this helps. Let us know how you get along. > >> > >> Julie > >> Project MVP > >> > >> Visit http://project.mvps.org/ for the FAQs and additional > >> information > >> about Microsoft Project > >> > >> "rich" <rich@discussions.microsoft.com> wrote in message > >> news:1A504728-906F-4671-AD6F-3A516CC22053@microsoft.com... > >> > Hello, > >> > > >> > I have a group of Project users who need to import/export to/from > >> > Excel > >> > however, they all get "Operation Failed" errors. We think it may > >> > be > >> > because > >> > of patch KB948962. Does anyone know anything about this? > >> > > >> > TIA, > >> > > >> > Rich > >> > >> > >> > > > |
|
#6
| |||
| |||
| Re: Why won't Project Import/Export to/from Excel
You're welcome Anthony. Good luck. Julie "carricka" <carricka@discussions.microsoft.com> wrote in message news:9D103683-F62D-4347-BAD0-AA96420AF200@microsoft.com... > Hi Julie - > > No, we're on SP2. I'll talk to the system administrator and will get > back to > you as and when it's installed. > > Thanks for the prompt reply - it's much appreciated. > > Peace, > > ANTHONY > > "JulieS" wrote: > >> Hi Anthony, >> >> Do you have SP-3 installed? Try installing that and enabling >> legacy >> formats and see if that helps. >> >> I hope this helps. Let us know how you get along. >> >> Julie >> Project MVP >> >> Visit http://project.mvps.org/ for the FAQs and additional >> information >> about Microsoft Project >> >> >> "carricka" <carricka@discussions.microsoft.com> wrote in message >> news:2156B51E-931D-42FC-819B-871D3459366E@microsoft.com... >> > Hi Julie - >> > >> > I'm getting the exact same problem, just a dialogue box with >> > 'Operation >> > Failed' and nothing else. I've tried using an existing map and a >> > new map but >> > it's all the same. >> > >> > I don't appear to have the "Allow legacy file formats" option on >> > the >> > security tab in Tools > Options. >> > >> > Peace. >> > ANTHONY >> > >> > "JulieS" wrote: >> > >> >> Hello Rich, >> >> >> >> Have you tried changing the "Allow legacy file formats" on the >> >> security tab in Tools > Options. I don't recall if this was in >> >> the >> >> SP-3 push or the security fix you mention, but I believe project >> >> works >> >> with earlier versions of Excel than 2003 when exporting. I am >> >> using >> >> Project 2003 with SP-3 and when I turn off the option to allow >> >> loading, I get a message saying I have to enable it. >> >> >> >> I hope this helps. Let us know how you get along. >> >> >> >> Julie >> >> Project MVP >> >> >> >> Visit http://project.mvps.org/ for the FAQs and additional >> >> information >> >> about Microsoft Project >> >> >> >> "rich" <rich@discussions.microsoft.com> wrote in message >> >> news:1A504728-906F-4671-AD6F-3A516CC22053@microsoft.com... >> >> > Hello, >> >> > >> >> > I have a group of Project users who need to import/export >> >> > to/from >> >> > Excel >> >> > however, they all get "Operation Failed" errors. We think it >> >> > may >> >> > be >> >> > because >> >> > of patch KB948962. Does anyone know anything about this? >> >> > >> >> > TIA, >> >> > >> >> > Rich >> >> >> >> >> >> >> >> >> |
|
#7
| |||
| |||
| Re: Why won't Project Import/Export to/from Excel
Hi Julie - SP3 installed on Project and all working fine. Thanks for your help!! ANTHONY "JulieS" wrote: > You're welcome Anthony. Good luck. > > Julie > > "carricka" <carricka@discussions.microsoft.com> wrote in message > news:9D103683-F62D-4347-BAD0-AA96420AF200@microsoft.com... > > Hi Julie - > > > > No, we're on SP2. I'll talk to the system administrator and will get > > back to > > you as and when it's installed. > > > > Thanks for the prompt reply - it's much appreciated. > > > > Peace, > > > > ANTHONY > > > > "JulieS" wrote: > > > >> Hi Anthony, > >> > >> Do you have SP-3 installed? Try installing that and enabling > >> legacy > >> formats and see if that helps. > >> > >> I hope this helps. Let us know how you get along. > >> > >> Julie > >> Project MVP > >> > >> Visit http://project.mvps.org/ for the FAQs and additional > >> information > >> about Microsoft Project > >> > >> > >> "carricka" <carricka@discussions.microsoft.com> wrote in message > >> news:2156B51E-931D-42FC-819B-871D3459366E@microsoft.com... > >> > Hi Julie - > >> > > >> > I'm getting the exact same problem, just a dialogue box with > >> > 'Operation > >> > Failed' and nothing else. I've tried using an existing map and a > >> > new map but > >> > it's all the same. > >> > > >> > I don't appear to have the "Allow legacy file formats" option on > >> > the > >> > security tab in Tools > Options. > >> > > >> > Peace. > >> > ANTHONY > >> > > >> > "JulieS" wrote: > >> > > >> >> Hello Rich, > >> >> > >> >> Have you tried changing the "Allow legacy file formats" on the > >> >> security tab in Tools > Options. I don't recall if this was in > >> >> the > >> >> SP-3 push or the security fix you mention, but I believe project > >> >> works > >> >> with earlier versions of Excel than 2003 when exporting. I am > >> >> using > >> >> Project 2003 with SP-3 and when I turn off the option to allow > >> >> loading, I get a message saying I have to enable it. > >> >> > >> >> I hope this helps. Let us know how you get along. > >> >> > >> >> Julie > >> >> Project MVP > >> >> > >> >> Visit http://project.mvps.org/ for the FAQs and additional > >> >> information > >> >> about Microsoft Project > >> >> > >> >> "rich" <rich@discussions.microsoft.com> wrote in message > >> >> news:1A504728-906F-4671-AD6F-3A516CC22053@microsoft.com... > >> >> > Hello, > >> >> > > >> >> > I have a group of Project users who need to import/export > >> >> > to/from > >> >> > Excel > >> >> > however, they all get "Operation Failed" errors. We think it > >> >> > may > >> >> > be > >> >> > because > >> >> > of patch KB948962. Does anyone know anything about this? > >> >> > > >> >> > TIA, > >> >> > > >> >> > Rich > >> >> > >> >> > >> >> > >> > >> > >> > > > |
|
#8
| |||
| |||
| Re: Why won't Project Import/Export to/from Excel
Super Anthony. I'm glad all worked well. You're welcome for the assist and thanks for the feedback. Julie "carricka" <carricka@discussions.microsoft.com> wrote in message news:C38FD68A-AC6A-45AF-9D66-E15BD9E5310C@microsoft.com... > Hi Julie - > > SP3 installed on Project and all working fine. Thanks for your > help!! > > ANTHONY > > "JulieS" wrote: > >> You're welcome Anthony. Good luck. >> >> Julie >> >> "carricka" <carricka@discussions.microsoft.com> wrote in message >> news:9D103683-F62D-4347-BAD0-AA96420AF200@microsoft.com... >> > Hi Julie - >> > >> > No, we're on SP2. I'll talk to the system administrator and will >> > get >> > back to >> > you as and when it's installed. >> > >> > Thanks for the prompt reply - it's much appreciated. >> > >> > Peace, >> > >> > ANTHONY >> > >> > "JulieS" wrote: >> > >> >> Hi Anthony, >> >> >> >> Do you have SP-3 installed? Try installing that and enabling >> >> legacy >> >> formats and see if that helps. >> >> >> >> I hope this helps. Let us know how you get along. >> >> >> >> Julie >> >> Project MVP >> >> >> >> Visit http://project.mvps.org/ for the FAQs and additional >> >> information >> >> about Microsoft Project >> >> >> >> >> >> "carricka" <carricka@discussions.microsoft.com> wrote in message >> >> news:2156B51E-931D-42FC-819B-871D3459366E@microsoft.com... >> >> > Hi Julie - >> >> > >> >> > I'm getting the exact same problem, just a dialogue box with >> >> > 'Operation >> >> > Failed' and nothing else. I've tried using an existing map >> >> > and a >> >> > new map but >> >> > it's all the same. >> >> > >> >> > I don't appear to have the "Allow legacy file formats" option >> >> > on >> >> > the >> >> > security tab in Tools > Options. >> >> > >> >> > Peace. >> >> > ANTHONY >> >> > >> >> > "JulieS" wrote: >> >> > >> >> >> Hello Rich, >> >> >> >> >> >> Have you tried changing the "Allow legacy file formats" on >> >> >> the >> >> >> security tab in Tools > Options. I don't recall if this was >> >> >> in >> >> >> the >> >> >> SP-3 push or the security fix you mention, but I believe >> >> >> project >> >> >> works >> >> >> with earlier versions of Excel than 2003 when exporting. I >> >> >> am >> >> >> using >> >> >> Project 2003 with SP-3 and when I turn off the option to >> >> >> allow >> >> >> loading, I get a message saying I have to enable it. >> >> >> >> >> >> I hope this helps. Let us know how you get along. >> >> >> >> >> >> Julie >> >> >> Project MVP >> >> >> >> >> >> Visit http://project.mvps.org/ for the FAQs and additional >> >> >> information >> >> >> about Microsoft Project >> >> >> >> >> >> "rich" <rich@discussions.microsoft.com> wrote in message >> >> >> news:1A504728-906F-4671-AD6F-3A516CC22053@microsoft.com... >> >> >> > Hello, >> >> >> > >> >> >> > I have a group of Project users who need to import/export >> >> >> > to/from >> >> >> > Excel >> >> >> > however, they all get "Operation Failed" errors. We think >> >> >> > it >> >> >> > may >> >> >> > be >> >> >> > because >> >> >> > of patch KB948962. Does anyone know anything about this? >> >> >> > >> >> >> > TIA, >> >> >> > >> >> >> > Rich >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> |
|
#9
| |||
| |||
| Re: Why won't Project Import/Export to/from Excel
Great, this solution worked for me as well. In combination with the hint about saving to web page, then renaming to xls, this now serves my purpose rather nicely. |
|
#10
| |||
| |||
| Re: Why won't Project Import/Export to/from Excel
Someone please share the solution.....I need to do this and have no idea how to make it work! Thanks "w8rn8r" wrote: > > Great, this solution worked for me as well. > In combination with the hint about saving to web page, then renaming to > xls, this now serves my purpose rather nicely. > > > -- > w8rn8r > ------------------------------------------------------------------------ > w8rn8r's Profile: http://forums.techarena.in/members/w8rn8r.htm > View this thread: Why won't Project Import/Export to/from Excel > > http://forums.techarena.in > > |
|
#11
| |||
| |||
| Re: Why won't Project Import/Export to/from Excel
Hi Imatreehugr, Click on the following link to view the entire thread at the techarena site: Why won't Project Import/Export to/from Excel I hope this helps. Let us know how you get along. Julie Project MVP Visit http://project.mvps.org/ for the FAQs and additional information about Microsoft Project "Imatreehugr" <Imatreehugr@discussions.microsoft.com> wrote in message news:C26ADBFA-9DE7-4A6C-B42B-363A67649080@microsoft.com... > Someone please share the solution.....I need to do this and have > no idea how > to make it work! Thanks > > "w8rn8r" wrote: > >> >> Great, this solution worked for me as well. >> In combination with the hint about saving to web page, then >> renaming to >> xls, this now serves my purpose rather nicely. >> >> >> -- >> w8rn8r >> ------------------------------------------------------------------------ >> w8rn8r's Profile: http://forums.techarena.in/members/w8rn8r.htm >> View this thread: >> Why won't Project Import/Export to/from Excel >> >> http://forums.techarena.in >> >> |
![]() |
|
| Thread Tools | Search this Thread |
| |
Similar Threads for: "Why won't Project Import/Export to/from Excel" | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Export Sheet Excel to MS Project | aelmalki | Microsoft Project | 14 | 20-04-2011 08:49 PM |
| Export MS Project 2007 to Excel | Tim | Microsoft Project | 6 | 13-02-2009 10:34 PM |
| Import / Export across project plans | Craig | Microsoft Project | 3 | 15-10-2008 09:35 AM |
| Project Notes Export to Excel | Andy Thomas | Microsoft Project | 1 | 26-04-2008 02:03 AM |
| Export Project Data to Excel | dknight555@yahoo.co.uk | Microsoft Project | 3 | 20-06-2007 08:56 AM |