Linking WorkBooks--What is the Best WAY?

[jacobpressures]

Below is some information about linking workbooks in Excel.

Currently I'm linking using a "physical" address. C:\...
I plan to move these to a different location once i finish them. They will be stored on a server.

Is it ok to link these tons of workbooks before moving them to the server on my computer?

What about using the "UNC" address mentioned below?

Guys, i don't want to have to rebuild 1,000 links after they've been created because the paths don't match anymore.

Thanks!

--------------
Consider where you'll store linked workbooks If you're using links to share data on your network, consider where the source and linking workbooks will be stored. Source workbooks stored on a network share are available to other network users, who can store their linking workbooks either on the network or on their own hard disks. Source workbooks on your hard disk, however, are only available to you, so if you put linking workbooks on a network share, other users won't be able to update links to source workbooks on your system.

Network drive letters in links When you click a cell containing a link and the source workbook is closed, you'll see the full path to the source workbook. The path uses the drive letter you have mapped to the share. The links continue to work correctly for other users who map different drive letters to the same share.

You can edit linking formulas to use UNC names, such as \\myserver\myshare, instead of drive letters. UNC names can make links easier to update when several people will use a linking workbook, because Excel can update links that use UNC names even if users don't have a drive letter mapped to the network share. For example, you can change ='G:\[source.xls]Prices'!B5 to ='\\myserver\myshare\[source.xls]Prices'!B5. However, using UNC names can also reduce calculation speed, especially if your workbooks use calculation-intensive features such as the Solver add-in program.

 

[SkipVought]

Hi,

You can use the Edit/Replace feature.

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}

 

[SkipVought]

OOPS...

I misread your post.

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}

 

[GlennUK]

Design the hierarchy of your data, so that supporting data is always in the same directory as the reporting workbook, or in a directory below that of the reporting workbook, and then copying the workbooks to a network drive will work fine.



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Gavona]

You can use the Edit/Replace feature"
Edit, Links, ChangeSource might also be helpful in case you are not aware of it.


Gavin

 

[jacobpressures]

thanks, I'll give these a try.

 

[jacobpressures]

everything seems to be working fine guys thanks!