Excel 2003 bug

G

Guest

If you have a formula that pulls data from two worksheets
in the same workbook and try to sort the data, the sort
doesn't always work.

If this formula is on worksheet 2 (WK2) and links to
worksheet 1 (WK1), then the results are sorted on this
formula, it will fail. WK2!D1 is cell D1 on worksheet 2
and the rest is the formula for the cell. The formula is
then copied from D1 down through D10 then sorted.

WK2!D1=WK1!D1+WK2!C1

Make this change and it works fine sorting.
WK2!D1=WK1!D1+C1

Please explain why this doesn't work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Formula's based on drop down list value 3
Simplified SUMPRODUCT formula ! 3
Store formulas in Vlookups? (another try ;) 6
concantenate then index match 2
Conditional Time Calculation 10
IF function 2
Linked Cells, Increment Sheet Number Ref. 3
Worksheet to Worksheet skip blanks 3

Top