[LINK] Bizarre lameness in Microsoft Excel 2002
ivan at itrundle.com
Thu Nov 6 12:36:04 AEDT 2008
On 06/11/2008, at 11:45 AM, Richard Chirgwin wrote:
> 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)
> limitations, why not link the Excel cells to the database? That way,
> 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.
More information about the Link