Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 24

External reference to a Column

Hi,

I have the following formula in wb1 that only works when referenced wb is
opened:

SUMPRODUCT(--(MONTH('[P&L Fixed Income_20090414.xls]HistÃ³rico
Productos'!$A$7:$A$160)=MONTH(today)),OFFSET('[P&L Fixed
Income_20090414.xls]HistÃ³rico Productos'!$A$7:$A$160,0,M27-1)/1000)

The thing is that I want it to work when the referenced workbook is closed.
Is there an alternative solution to get the same result?

Many Thanks in Advance!!

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
external Excel Add-In reference	excel newbie	Excel Worksheet Functions	3	March 8th 08 03:16 AM
External Reference in Vlookup	C Brandt	Excel Discussion (Misc queries)	4	July 3rd 07 04:45 AM
External Reference	Iain	Excel Discussion (Misc queries)	3	February 8th 05 06:53 PM
External reference as a condition	Ingeniero1	Excel Worksheet Functions	0	November 12th 04 09:42 PM
External reference as a condition	Ingeniero1	Excel Worksheet Functions	2	November 12th 04 07:10 PM

All times are GMT +1. The time now is 05:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us