Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Right-click export to Excel -> other layout doesn't give any activities

4 replies [Last post]
Mi Mo
User offline. Last seen 5 years 21 weeks ago. Offline
Joined: 5 Mar 2019
Posts: 8
Groups: None

Hi everybody,

I have been searching for this everywhere, but no succes..

So I always had succes when I used the right-click -> export to excel option.

Now, I have saved some different layouts and when I use a different layout I get an Excel export without any activities.

It does show the title columns.

I tried different view-filters and by accident I had one activity already marked as 'in progress', now this one was shown in the dump.

 

Anyone any idea what the problem is?

Replies

Zoltan Palffy
User offline. Last seen 29 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

highlight them first then rigth click export to excel  

Santosh Bhat
User offline. Last seen 21 weeks 4 days ago. Offline
Joined: 15 Apr 2005
Posts: 381

Why are you right clicking? In your activity view, press CTRL+A to select all, then CTRL+C to copy to clipboard, then Past einto an Excel worksheet.

Mi Mo
User offline. Last seen 5 years 21 weeks ago. Offline
Joined: 5 Mar 2019
Posts: 8
Groups: None

I have DD+3D filter OR status 'in Progress'

It works to get the right view in P6, but when I export to Excel it doesn't give any results.

Mi Mo
User offline. Last seen 5 years 21 weeks ago. Offline
Joined: 5 Mar 2019
Posts: 8
Groups: None

Wait...

 

It doesn't have to do with the righ-click methode.. It doesn't export at all.

It is a 3 day lookahead filter, so I think it has someting to do with the date.