Re: LINK WORKSHEETS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 15:19:52 +0100

[snip]
> relative formulas have solved the sorting problem only in the actual
> worksheet. when i sort the original (source) worksheet and the
> formulas become updated, only the columns containing links are sorted
> and the remaining ones are not. as a result data get mixed up. is
> there a way to solve this problem or do i have to avoid sorting the
> original worksheet? and if this is true is there a way to <<lock>>
> sorting? Sorting, however, is a very useful tool when working with
> data in excel!
>
> pls help me!

AFAIK no chance to do this. So yes you have to avoid sorting in the
original sheet as Excel does not link the contents of a row (in your
second sheet) together as one dataset (as a database would do)

Frank

Relevant Pages

  • Re: Adding a KeyID column for sorting
    ... MAKE SURE when sorting that you select ALL the data before sorting, ... I have a worksheet ... So after I do a sort and perform a few ... > tasks I want to click on a KeyID column and see the original order that I ...
    (microsoft.public.excel.newusers)
  • Re: Disallow sorting of data.
    ... Protection =>Worksheet. ... I believe sorting is not an option for a protected ... not allow the sort itself. ...
    (microsoft.public.excel.programming)
  • Re: charting different tpes of lumber on a list. (SEE PIC)
    ... you know, on second thought, i know this is charting, worksheet ... Anyway, i thought about it, and instead of sorting the list, ... Prev by Date: ...
    (microsoft.public.excel.charting)
  • Adding a KeyID column for sorting
    ... I'm using MS Windows XP and Excel 2003. ... I intend to do a lot of sorting on these ... I want to be absolutely certain that the original order is ... from say 1 to 10,000 or to the last row in the worksheet)? ...
    (microsoft.public.excel.newusers)
  • Incorrect data in a sort 4192735
    ... I am sorting a spreadsheet of a list of names ... alphabetically descending. ... new worksheet. ... easier way to fix this or has seen this before? ...
    (microsoft.public.excel.worksheet.functions)