[LINK] Bizarre lameness in Microsoft Excel 2002

[Ivan Trundle]

On 06/11/2008, at 11:45 AM, Richard Chirgwin wrote:

> Ivan,
>
> This may be a dumb question, however: since the data is coming out of
> the DB into Excel, rather than trying to cope with Excel's (stupid)  
> copy
> limitations, why not link the Excel cells to the database? That way,  
> you
> can easily populate the spreadsheet without having to copy big slabs
> from one sheet to another ...

This is where Link is worth all the effort. As a wise person once  
said: there is never a dumb question, and only dumb answers.

Thanks for the lateral thinking, Richard. It's not quite so simple as  
a 'cut-and-paste' job (password protection notwithstanding), but I'll  
look at it now. Great tip. Cheers.

iT