The current file has multiple tabs with many lookup formulas and the
performance is slowing down considerably.

I have 4 main tabs which contain the source data name ranges. Can I move
these tabs to a separate file and have the lookup formulas in the original
file reference the ranges in this new file?

Any help would be appreciated.

Thanks, Joe

A lot of good info on efficiency he

http://www.decisionmodels.com/

--
Biff
Microsoft Excel MVP


"Joe" wrote in message
...
The current file has multiple tabs with many lookup formulas and the
performance is slowing down considerably.

I have 4 main tabs which contain the source data name ranges. Can I move
these tabs to a separate file and have the lookup formulas in the original
file reference the ranges in this new file?

Any help would be appreciated.

Thanks, Joe

Thanks for the useful link.

However can a vlookup formula reference a named range in another workbook?

"Joe" wrote:

The current file has multiple tabs with many lookup formulas and the
performance is slowing down considerably.

I have 4 main tabs which contain the source data name ranges. Can I move
these tabs to a separate file and have the lookup formulas in the original
file reference the ranges in this new file?

Any help would be appreciated.

Thanks, Joe

Yes. Use the workbook name and the range name for the table array:

=VLOOKUP(A2,'WorkbookName'!RangeName,2,FALSE)

This isn't going to improve performance though.

Cliff Edwards

can a vlookup formula reference a named range in another workbook?

Yes. You have to include the path if the source file will be closed:

Table = named range in XXX.xls
Refers to: Sheet1!A1:D4

=SUM('C:\TV\xxx.xls'!table)

I don't think this will help from an efficiency standpoint, though. The
formula still has to calculate and now it has to link to an external source.


--
Biff
Microsoft Excel MVP


"Joe" wrote in message
...
Thanks for the useful link.

However can a vlookup formula reference a named range in another workbook?

"Joe" wrote:

The current file has multiple tabs with many lookup formulas and the
performance is slowing down considerably.

I have 4 main tabs which contain the source data name ranges. Can I move
these tabs to a separate file and have the lookup formulas in the
original
file reference the ranges in this new file?

Any help would be appreciated.

Thanks, Joe

Hi Joe,

That is not going to improve efficiency, in fact its going to slow things
down in most cases.
--
Cheers,
Shane Devenshire


"Joe" wrote:

The current file has multiple tabs with many lookup formulas and the
performance is slowing down considerably.

I have 4 main tabs which contain the source data name ranges. Can I move
these tabs to a separate file and have the lookup formulas in the original
file reference the ranges in this new file?

Any help would be appreciated.

Thanks, Joe