MSP 2003 "Analyze Timescaled Data in Excel "Option

Microsoft Project
T
Tony McClennon 👤 Member for 23 years 6 months
· Permalink

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

T
Tony McClennon 👤 Member for 23 years 6 months
· Permalink

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

D
Darren Kosa 👤 Member for 18 years 3 months
· Permalink

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

T
Tony McClennon 👤 Member for 23 years 6 months
· Permalink

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

D
Darren Kosa 👤 Member for 18 years 3 months
· Permalink

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

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts