| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linked formula
Hi,
I have a formula in a cell, '=COUNTIF ('G:\inter_pa\[pcolog28173.xls]log'!$M$10:$M$409,G1047). If the source file is not open and I edit|links update it returns #value!!! If I open the source it updates fine. If I set it to update when the target file is opened, I get #value. any ideas??? peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked spreadsheets failing to recognised that the linked file is | Excel Discussion (Misc queries) | |||
| How do I have a linked cell auto-size to fit the linked data? | Excel Discussion (Misc queries) | |||
| Displaying linked data in excel 2007 when linked file is not avail | Excel Discussion (Misc queries) | |||
| Changing a linked formula ... ... ... | Excel Worksheet Functions | |||
| Linked Names in a Formula | Excel Worksheet Functions | |||
Threaded Mode
