C
Cresta
Hello
I have the following custom function which works when all linked files are
open in the same excel session.
=Sum2DProduct('V:\CompanyName\Accounts.09\Budgets\[Rolling
budget.xlsm]P&L'!$C$8:$BB$8,E$8,'V:\CompanyName\Accounts.09\Budgets\[Rolling
budget.xlsm]P&L'!$BD$10:$BD$75,$BD11,'V:\CompanyName\Accounts.09\Budgets\[Rolling budget.xlsm]P&L'!$C$10:$BB$75)
When the files are closed excel returns #VALUE and the function does not
run. I have replaced the mapped drive letter with the full path but no change.
Is there a way of writing the address below so that the linked file does not
have to be open for excel to be happy and the function to run?
'V:\CompanyName\Accounts.09\Budgets\[Rolling budget.xlsm]P&L'!$C$8:$BB$8
or with named range
'V:\CompanyName\Accounts.09\Budgets\[Rolling budget.xlsm]'!Profit
Hope this makes sence.
Thanks
I have the following custom function which works when all linked files are
open in the same excel session.
=Sum2DProduct('V:\CompanyName\Accounts.09\Budgets\[Rolling
budget.xlsm]P&L'!$C$8:$BB$8,E$8,'V:\CompanyName\Accounts.09\Budgets\[Rolling
budget.xlsm]P&L'!$BD$10:$BD$75,$BD11,'V:\CompanyName\Accounts.09\Budgets\[Rolling budget.xlsm]P&L'!$C$10:$BB$75)
When the files are closed excel returns #VALUE and the function does not
run. I have replaced the mapped drive letter with the full path but no change.
Is there a way of writing the address below so that the linked file does not
have to be open for excel to be happy and the function to run?
'V:\CompanyName\Accounts.09\Budgets\[Rolling budget.xlsm]P&L'!$C$8:$BB$8
or with named range
'V:\CompanyName\Accounts.09\Budgets\[Rolling budget.xlsm]'!Profit
Hope this makes sence.
Thanks