Hello,
I have a question regarding links to external workbooks.
I have a formula that checks other workbooks to retrieve values based on a date and shift, this code works perfect in another workbook however in my new workbook it doesn't respond properly.
The formula is being triggered by date and shift and these cells are updated when I open the workbook, but the values are not being retrieved.
When I manually change both date and shift the formula shows me the values.
I have checked and made sure the calculations are set to automatically, the links are proper even used macro's to make sure all values are recalculated, nothing seems to help.
There are links to 5 workbooks in my excel sheet, I don't think that's the issue.
Any help would be appreciated
The formula that I am using, with small change to the location:
I have a question regarding links to external workbooks.
I have a formula that checks other workbooks to retrieve values based on a date and shift, this code works perfect in another workbook however in my new workbook it doesn't respond properly.
The formula is being triggered by date and shift and these cells are updated when I open the workbook, but the values are not being retrieved.
When I manually change both date and shift the formula shows me the values.
I have checked and made sure the calculations are set to automatically, the links are proper even used macro's to make sure all values are recalculated, nothing seems to help.
There are links to 5 workbooks in my excel sheet, I don't think that's the issue.
Any help would be appreciated
The formula that I am using, with small change to the location:
Code:
=IFERROR(INDEX('\\serverlocation\Shared_Folders\Production Reports\[Production Report.xlsm]Production Reports'!$D$1:$D$1596,LARGE(IF(C3&F3='\\serverlocation\Shared_Folders\Production Reports\[Production Report.xlsm]Production Reports'!$B$1:$B$1596&'\\serverlocation\Shared_Folders\Production Reports\[Production Report.xlsm]Production Reports'!$C$1:$C$1596,ROW('\\serverlocation\Shared_Folders\Production Reports\[Production Report.xlsm]Production Reports'!$C$1:$C$1596),0),SUM(('\\serverlocation\Shared_Folders\Production Reports\[Production Report.xlsm]Production Reports'!$B$1:$B$1596=C3)*('\\serverlocation\Shared_Folders\Production Reports\[Production Report.xlsm]Production Reports'!$C$1:$C$1596=F3))-B5+1)),"")