Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read SiteMap

Tags: , , ,

Sponsored Links



Why won't Project Import/Export to/from Excel

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 16-07-2008
rich
 
Posts: n/a
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
Reply With Quote
  #2  
Old 18-07-2008
JulieS
 
Posts: n/a
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



Reply With Quote
  #3  
Old 22-07-2008
carricka
 
Posts: n/a
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

>
>
>

Reply With Quote
  #4  
Old 22-07-2008
JulieS
 
Posts: n/a
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

>>
>>
>>



Reply With Quote
  #5  
Old 22-07-2008
carricka
 
Posts: n/a
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
> >>
> >>
> >>

>
>
>

Reply With Quote
  #6  
Old 22-07-2008
JulieS
 
Posts: n/a
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
>> >>
>> >>
>> >>

>>
>>
>>



Reply With Quote
  #7  
Old 22-07-2008
carricka
 
Posts: n/a
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
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>

>
>
>

Reply With Quote
  #8  
Old 22-07-2008
JulieS
 
Posts: n/a
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
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>

>>
>>
>>



Reply With Quote
  #9  
Old 18-12-2008
Member
 
Join Date: Dec 2008
Posts: 1
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.
Reply With Quote
  #10  
Old 19-12-2008
Imatreehugr
 
Posts: n/a
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
>
>

Reply With Quote
  #11  
Old 19-12-2008
JulieS
 
Posts: n/a
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
>>
>>



Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project


Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 10:27 PM.