| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked cells refer to source one row off.
I have several spreadsheets which share data among them. Frequently, the
"link to" spreadsheet cell indicates an address which is one row off, ie; the source date is in F24 but the formula reads F23. This results in the wrong data, of course. Seems to affect 2 items only... the rest are OK. I have not inserted rows in the source file. Running EXCEL 2000 under XP. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating linked cells within a workbook, from worksheet to workshe | Excel Discussion (Misc queries) | |||
| Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
| linked cells to workbooks in different folders | Excel Discussion (Misc queries) | |||
| linked values not displayed unless source file open | Excel Discussion (Misc queries) | |||
| To get a lot of charts that refer to different cells | Charts and Charting in Excel | |||
Threaded Mode
