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
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
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,402
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,402
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
 

Watch MrExcel Video

Forum statistics

Threads
1,112,803
Messages
5,542,590
Members
410,561
Latest member
Sasha Lawrence
Top