[File Link] Problem with performance

R

Rodrigo Silveira

Hi all,

i have a perfomance problem when use the function IFSUM with link extern
Spreadsheet.


The scenario:

Spreadsheet Base File : SALES.XLS ~ 10MB
Spreadsheet: ABC.XLS

In the Spreadsheet [abc.xls] there is some calls to Spreadsheet [sales.xls]


The Code Example:

IFSUM('[SALES.xls]SALES.'!$E:$F;
CONCATENATE($B$1;$A5);'[SALES.xls]SALES.'!$F:$F)


The problem:

In Excel 97 it´s working, but when I have been working with Excel 2003
sp2/sp3 and opening the file [abc.xls] or same I change some value in the
cells, the Excel to stay Recalculate the cells for some minutes.


I could work differently in Excel 2003?



Thanks,

Rodrigo Silveira
[email protected]
 
Top