Linking Excel Files together

sice

New Member
Joined
Aug 17, 2010
Messages
18
Hello everyone,

I have a question about linking excel files together. I know there is a way to do an = and reference another excel document, so that whenever that other excel is updated it would update both documents.

I believe it is under data, connections then.... That is far as I can get. This is an example of one that works, but I am not sure how it was done.

'\\Usnt42\psf\Finance\Current Year - P, S & F Documents\Marketing Managers Input\Combined Sales Estimates, Geo Change\[LAA Sales Est - PS&F.xls]Volume'!CT67*1000*

In this work book it shows that it is connected/linked with the finance folder (Excel Document).

Any help on this would be greatly appreciated. Thank you for your time and support.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,224,597
Messages
6,179,813
Members
452,945
Latest member
Bib195

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top