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
(e-mail address removed)
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
(e-mail address removed)