Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
ms project

ResolvedVersion 2003

Jackie has attended:
Project Intro Intermediate course

MS Project

How does OLE work ?

RE: MS Project

Hi Jackie,

Object Linking and Embedding (OLE) is a mechanism that allows you embed part of one document in another document. For example in Project you can click in the Select All square (top left corner) to select all of your tasks. From the edit menu choose Copy Task then switch to another application such as Excel and from the Edit menu choose Paste > Special. The dialogue box will show that Excel has recognised the data in its clipboard as a Project object. Choosing this and clicking OK will result in an embedded version of the Gantt chart appearing in your Excel sheet. If Project is installed on the machine double clicking on the embedded chart will will open MS Project within Excel allowing you to browse and manipulate the data.

For a detailed explanation of OLE and how it works take a look at this article on the Microsoft website:

http://support.microsoft.com/kb/86008

MS Project tip:

MS Project 2010 Scroll to Task

Ever feel lost on a large project file? In Gantt view, Task ribbon, Editing, click on the Scroll to Task tool to centre the task bar on your screen.

Shortcut Ctrl+Shift+F5

Same as Go to Selected Task in MS Project 2003.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.