Linking to file, some formulas work only if file is open

ST Matt

Junior Member

Posts: 1

Linking to file, some formulas work only if file is open

I am in Excel ’07 and am linking to another file also in ’07. I have some v-lookup and sumif formulas on my data tab. The vlookup formulas work regardless of whether the file I am linking to is open or not. However, the sumif formulas only work if the file is open. Both are referencing the same tab of data. Not sure what is going on. Any ideas why the sumif will only work if the file is open? Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linking to another file using file reference typed cell	Steven	Excel Worksheet Functions	3	April 5th 08 03:15 AM
In Excel - Use Windows Explorer instead of File Open to open file	KymY	Excel Discussion (Misc queries)	1	August 5th 06 09:59 PM
Turning a text file name into a search and linking the file as a hyperlink	AlistairM	Excel Discussion (Misc queries)	1	January 26th 06 04:55 AM
trying to open a lotus file in excel, it won't work	cal	Excel Worksheet Functions	1	January 6th 06 09:57 PM
Does file need to be open for INDIRECT to another workbook to work	briancrosier	Excel Discussion (Misc queries)	2	December 15th 04 04:25 PM

All times are GMT +1. The time now is 07:06 PM.

Menu

About Us