Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#REF on Links to Named Range in External Workbook
Hi there everyone,
I have a workbook which contains links to named ranges that are in external workbooks stored on the server. When the external workbook is open the cells show the correct values. When the external workbooks are closed the cells show #REF. The formulae are obviously correct so why can excel only read from files that are open? Can anyone explain this? Also - a small additional query - why is it that when excel links to an external file it drops the square brackets round the file name & path if the link is to a named range. The square brackets appear if the link is to a cell address? Thanks in Advance Stuart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range Name from Another Workbook conflicts with INDEX and INDIRECT | Excel Worksheet Functions | |||
Named range links to external workbook, help! | Charts and Charting in Excel | |||
Using a formula to create named range reference | Excel Worksheet Functions | |||
How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions |