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.

MSP 2003 "Analyze Timescaled Data in Excel "Option

5 replies [Last post]
Fri, 2008-04-11 05:48
Tony McClennon
User offline. Last seen 23 weeks 5 days ago. Offline
Joined: 19 Nov 2002
Posts: 97
Groups: None
Hi All,

I’m probably having one of those "Friday moments", but I cannot find the "Analyze Timescaled Data in Excel" option to add to the toolbar.

MSP help says:

"On the View menu, click Gantt Chart.
If applicable, select the tasks you want to export.
On the View menu, point to Toolbars, and then click Analysis.
Click Analyze Timescaled Data in Excel."

However, when I point to Toolbars, Analysis is not there. Someone please tell me I’m not losing it completely!!

Thanks.
Top

Replies

Mon, 2008-04-14 05:17
#1
Tony McClennon
User offline. Last seen 23 weeks 5 days ago. Offline
Joined: 19 Nov 2002
Posts: 97
Groups: None
Hi Darren,

It appears that my registry files had been corrupted - a refresh has now brought the Analysis toolbar back into operation.

Many thanks for your assistance.

Regards,

Tony
Top
Mon, 2008-04-14 04:50
#2
Tony McClennon
User offline. Last seen 23 weeks 5 days ago. Offline
Joined: 19 Nov 2002
Posts: 97
Groups: None
Hi Darren,

Thanks again - unfortunately, when I get to:

"In the Customize dialog box check the ’Analysis option and click OK"

....there is no customise dialogue box shown.

It’s really annoying as the option has been available, but suddenly disappeared!!

regards,

Tony
Top
Fri, 2008-04-11 08:15
#3
Darren Kosa
User offline. Last seen 7 years 22 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None
Sorry Tony,

Should proof read my posts. :)

It should read

Tool > Customize > Toolbars and select the Toolbars tab
In the Customize dialog box check the ’Analysis option and click OK

Regards,

Darren
Top
Fri, 2008-04-11 07:11
#4
Tony McClennon
User offline. Last seen 23 weeks 5 days ago. Offline
Joined: 19 Nov 2002
Posts: 97
Groups: None
Darren,

Thanks for the reply. Everything works in the first part of the solution.

However, when I then go to:

Tool > Customize > Toolbars and select the Tools tab
In the Customise dialog box check the ’Analysis’ option and click OK

there is no Tools Tab, only Toolbars, Commands and Options - is there another step I should be taking.

Thanks and regards,

Tony
Top
Fri, 2008-04-11 06:57
#5
Darren Kosa
User offline. Last seen 7 years 22 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None
Hi Tony,

There are a number of reasons why this happens, but try this.

Tools > Customize > Toolbars and select the Commands tab
In the dialog box you’ll see two scroll bars.
On the left-hand side scroll down and select Tools
You’ll then see a number of options appear on the right-hand side
Scroll down the right-hand side and select COM Add-Ins...
Now drag the selection and add it to any of the Toolbars at the top of the screen
You should now have a COM Add-Ins... button on one of your Toolbars
Click the button and a COM Add-Ins dialog box will appear
Hopefully you will have ’Analyze Timescaled Data in Excel’ as one of the options
Check the option and then click OK

You then need to go

Tool > Customize > Toolbars and select the Tools tab
In the Customise dialog box check the ’Analysis’ option and click OK

Let me know if this helps as there are a still few things you can do if it doesn’t.

Regards,

Darren
Top