#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 |
All times are GMT +1. The time now is 03:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com