General Excel Gripe.....

[piginabush]

Just feel the need to vent my frustration.....

Why, Oh Why is it so difficult to create a worksheet then take a copy of this sheet and place it somewhere else so that the values update when the original changes?!?!?!?

I have been working for what seems like hours creating a table which each cell goes away and returns me the information I need using either SUMIF or SUMPRODUCT within the same workbook, works fine, when I do a copy of this one sheet to provide to other business users so that they can also see the same information without the need to see the background tables then boom.... #VALUE! errors all over the place, apparently SUMIFs dont "like" it between two different workbooks!!!

Aaaaaaaargh!!!

Rant Over

 

[BrianMH]

Before sending the workbooks to them save and CLOSE your source workbook. The formulas should update to links to the original workbook. The users need access to the location but it should work for you.