REFERENCE Closed Workbooks on Mapped Drive

[agreen1344]

Our company manages its projects in individual notebooks, and we use a master workbook to show program summaries. All files are stored on an internal, mapped drive.

I'm having some trouble pulling data from the project notebooks to the master workbook using this reference format:

=('\\AAA.BBB.CCC.net\wce\Maytag\Maytag-common\management tools\PROGRAM\[Prog_Fcst[File-M123456-ABC123 XYZ.xlsm]Program Hrs'!A1)

My end goal is to have the references automatically update without opening the source files. Any suggestions?

Thank you!

[camerongray]

The \\server\path\to\file syntax may not work (never tried it TBH).  You may want to try mapping the drive to give it a drive letter on your machine, then use this path in Excel.