Stop Linked Workbooks from Updating

[Guest]

Windows 2000, Office 200

Have several workbooks linked to a single workbook. Want the destination workbook to be updated when it opens even if source workbooks are closed

Installed the MoreFunc to use INDIRECT.EXT. Get #REF! or #VALUE! with this. The source and destination workbooks are located on a server

Sample of formula used
=INDIRECT.EXT("'\\servername\drive\folder\[CRO_1.xls]February ''04'!$AU$23"

Please advise.

 

[Frank Kabel]

Hi Cherryl
If the workbook is know before there is no need for INDIRECT.EXT. you
could use
=\\servername\drive\folder\[CRO_1.xls]February04'!$AU$23

or if for example the workbook is based on a cell reference try
=INDIRECT.EXT("\\servername\drive\folder\[" & cell_reference &
".xls]February04'!$AU$23")

In your original formula it seems you messed a little bit with the
apostrophes

Frank