Skip to main content

How to Paste Links to Source Cells Instead of Values.

You have finished your calculations and now you are about to present your results? Well built Excel models usually separate the calculations from the results. Therefore “Paste Links” might be helpful for you, especially when your colleagues should not mess your data source. This article describes how to paste links to cells instead of values and the next steps for also applying formatting with just a few klicks (or better: key strokes…).

Comments

Popular posts from this blog

Debugging Perl

The standard Perl distribution comes with a debugger, although it's really just another Perl program, perl5db.pl. Since it is just a program, I can use it as the basis for writing my own debuggers to suit my needs, or I can use the interface perl5db.pl provides to configure its actions. That's just the beginning, though. read more...

How To Set Up A Cisco Lab On Linux

After a quick search I found the wonderful Dynamips project that goes beyond what other simulators do by running actual Cisco IOS images, as well as the PEMU project which allows for running of Cisco PIX images. To integrate the various pieces of software... more .