| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Referencing Error
I have a complex spreadsheet with many sheets linked together. Sometimes
when I delete rows on one sheet the links do not update. For example, if cell Sheet2!b7=Sheet1!g10 and then I delete rows 2 & 3 on "Sheet1", the formula in Sheet2!b7 does not update to Sheet1!g8 but still references row 10 even though everything has moved up on Sheet1. Does anyone know what this happens? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing a different tab by referencing a list in the current s | Excel Worksheet Functions | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| Cell Referencing Code Error? | Excel Worksheet Functions | |||
| #VALUE error when referencing spreadsheet on sharepoint library | Excel Worksheet Functions | |||
Linear Mode
