If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cross-sheet formula and sort data
Not sure if this is a new issue with Excel 2007 or if it was there before.
When entering a formula into a worksheet (call it Sheet1), I firstly clicked open a second sheet before going back to the first sheet. The resulting formula was then Sheet1!(formula). I realised that Sheet1! wasn't necessary, but didn't think it would be an issue. How wrong I was! When I later sorted the worksheet into a different order, the cell formulae were not amended to reflect the new order. To correct this it was necessary to delete all reference to Sheet1! Is this by design, or a flaw in the program? |
Thread Tools | |
Display Modes | |
|
|