| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Error message #N/A appears in linked cells
Hello,
I'm using Excel 2003 and have files with lots of links. Cells are linked to an external workbook. The cells in the same column have inconsistent link results. Some cells display #N/A and some cells are fine. The formulas are the same, except they refer to a cell in a different row. When I open the supporting sheet the cells update fine and the #N/A disappears and I get the source data. When I close the supporting workbook the #N/A returns. The cells are linking text data. Would anyone know what is causing this and how I could fix it? Thanks, Jake |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error message help with linked worbook | Excel Discussion (Misc queries) | |||
| Error message: Too many different formats of cells | Setting up and Configuration of Excel | |||
| Formula too long error message to linked spreadsheet | Links and Linking in Excel | |||
| Too many formatted cells error message | Excel Discussion (Misc queries) | |||
| How to sum a row of cells containing an error message to overlook | Excel Worksheet Functions | |||
Threaded Mode
