Embedded project linked into Excel

[SarahB]

I have linked an embedded project into Excel. When changes are made to the
project plan I save it, then update the link so that excel picks up the
updates and mirrors the new plan. However if a row is added to the project
plan, excel will not pick up this change. Is there a way around this? I
don't want to be copying/pasting all the time.

 

[davegb]

I have linked an embedded project into Excel. When changes are made to the
project plan I save it, then update the link so that excel picks up the
updates and mirrors the new plan. However if a row is added to the project
plan, excel will not pick up this change. Is there a way around this? I
don't want to be copying/pasting all the time.

The only way I know of to get around this is to write an macro that
automatically copies the entire file to Excel. I don't know how to do
this, but one of the VBA gurus here probably will.

 

[John]

I have linked an embedded project into Excel. When changes are made to the
project plan I save it, then update the link so that excel picks up the
updates and mirrors the new plan. However if a row is added to the project
plan, excel will not pick up this change. Is there a way around this? I
don't want to be copying/pasting all the time.

SarahB,
I guess my question would be, why are you embedding the whole Project
plan in Excel? There is often good reason to export some of Project's
data to Excel (e.g. for more flexibility with data manipulation or for
customized reports) but it is very rare to truly have a need for the
whole Project plan in another application. Perhaps if you enlighten us
more, we can suggest a more appropriate solution.

John
Project MVP