Computer Hope

Software => Computer programming => Topic started by: agreen1344 on January 31, 2017, 12:43:20 PM

Title: REFERENCE Closed Workbooks on Mapped Drive
Post by: agreen1344 on January 31, 2017, 12:43:20 PM

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!

Title: Re: REFERENCE Closed Workbooks on Mapped Drive
Post by: camerongray on February 01, 2017, 03:06:59 AM

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.