jump to navigation

Paste Link and DDE May 15, 2011

Posted by Ivor's Window to the IT and CRM World in Microsoft Office.

Who uses Paste Link extensively?

Do you remember way back in the early 90’s DDE was touted as a tool to enhance productivity. DDE stood for Dynamic Data Exchange see: http://en.wikipedia.org/wiki/Dynamic_Data_Exchange however I have seldom seen business users making use of this technology in the “Real World”.

Everyone uses Cut and Paste, this is just an advanced way of using this function.To practically use this, a user can copy a cell in Excel, a Word in Word, or in fact any item or object in any Microsoft Office package and then use Paste Link in another product to paste the item. This then keeps the target updated with the value or values within the source.

So for example let us say you have an Excel Worksheet with the number of sales made this month, and every month you need to send out a management report with this number. You would use Paste Link to your Word report and it would update automatically. You would use a report template with the embedded link.

I can remember having data coming from a Lotus Notes Database into a Worksheet which was calculating values and then the final values were included in a monthly report and a monthly PowerPoint presentation of the monthly figures. This was all done automatically and saved a secretary a considerable amount of time each month.

The concept of using dynamic data is all around us and is in most applications, however I don’t believe it has been adopted as a productivity toolset by users of these applications, and certainly I have not seen much evidence of this in my role as a CRM Consultant where I meet with many business users and sales administration staff.

My challenge for today, look closely at Paste Link



No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Microsoft Dynamics CRM

Everything CRM and other cool stuff

Microsoft Dynamics 365 Team blog

Everything CRM and other cool stuff

Hosk's Dynamic CRM Blog

All views and opinions are personal opinions of the Hosk

%d bloggers like this: