Linking to other excel files

JoshuaMars

New Member
Joined
Jul 13, 2006
Messages
46
Hi there Excel users.

Is it possible to do formulas with other excel files.

I was thinking it could be but only if the file is open at the same time.

Thanks
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
It all depends on what the formula is exactly? Some functions work on closed external books, other functions don't work, so without knowing what you want I can't really help.
 

JoshuaMars

New Member
Joined
Jul 13, 2006
Messages
46
I'll make it simple

I want to sum a1 to a5 in file titles 2006 and have the formula in a2 in file titled account.

thanks
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Have the 2 workbook open at the same time, and in the "account" book start typing the formula with a =SUM( and then switch to the "titles" book and select the 5 cells A1:A5 and type ) and press Enter.
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963

ADVERTISEMENT

Have the 2 workbook open at the same time, and in the "account" book start typing the formula with a =SUM( and then switch to the "titles" book and select the 5 cells A1:A5 and type ) and press Enter.

****, you beat me to it Glenn :biggrin:
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Have the 2 workbook open at the same time, and in the "account" book start typing the formula with a =SUM( and then switch to the "titles" book and select the 5 cells A1:A5 and type ) and press Enter.

****, you beat me to it Glenn :biggrin:
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963

ADVERTISEMENT

Have the 2 workbook open at the same time, and in the "account" book start typing the formula with a =SUM( and then switch to the "titles" book and select the 5 cells A1:A5 and type ) and press Enter.

****, you beat me to it Glenn :biggrin:
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Ha ha, your PC appears to be stammering a fair bit. Sounds like you had the same idea as me though, using the easy way to generate formulae.
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
This has causes problems for me tho (in the past), mainly with network mapping

If a user didn't have that network drive mapped to their profile, it wouldn't refresh the data (from the linked file)

So i ended up bypassing the cell link to the server name, which resolved the problem
 

Forum statistics

Threads
1,141,429
Messages
5,706,405
Members
421,447
Latest member
arthuro2021

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
Top