Hello Everyone,
I'm hoping someone can help me out with a sumproduct issue. I am using sumproduct to compare sales figures between 2008 and 2009. I have been using the following formula:
=SUMPRODUCT(('[2008 Sales by Item YTD.xls]Sales Detail YTD 08-2008'!$B$6:$B$6496=B6)*('[2008 Sales by Item YTD.xls]Sales Detail YTD 08-2008'!$N$6:$N$6496))
Each month I increase the range and change tabs to include the latest month (In this case its august). Thus far it has worked perfectly, until now... I cannot save the sheet, it gives a message saying "Excel cannot complete this task with the avilable resources. Choose less data or close other applications." Then when you reopen the sheet and attempt the update the links it returns a #ref. Anyone have any clue? I am using Excel 2003 BTW...
Thank you all!!!
I'm hoping someone can help me out with a sumproduct issue. I am using sumproduct to compare sales figures between 2008 and 2009. I have been using the following formula:
=SUMPRODUCT(('[2008 Sales by Item YTD.xls]Sales Detail YTD 08-2008'!$B$6:$B$6496=B6)*('[2008 Sales by Item YTD.xls]Sales Detail YTD 08-2008'!$N$6:$N$6496))
Each month I increase the range and change tabs to include the latest month (In this case its august). Thus far it has worked perfectly, until now... I cannot save the sheet, it gives a message saying "Excel cannot complete this task with the avilable resources. Choose less data or close other applications." Then when you reopen the sheet and attempt the update the links it returns a #ref. Anyone have any clue? I am using Excel 2003 BTW...
Thank you all!!!
Last edited: