I use Excel 2002 (10.6501.6735)SP3 and Windows 2000. When using Excel's Paste
Special Paste Links command for a range in a database I found that the pasted
range contains relative not absolute references. There is no simple way of
changing these reference types for an entire range as the F4 command only
works for single cells. I had to use a macro. This could be avoided by EITHER
modfying the Paste Special Paste Links command to allow the user to select
between absolute or relative cell references OR modifying the F4 option so
that it can be applied to a range of cells.

This miust be quite a common problem when you want to display various
versions of a database sorted in different ways but with the contents all
driven from the original.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming