Excel 2010 - Function not updating (#value) in automatic calculation or otherwise

I have a UDF that has three inputs, the function works and calculates correctly. However, upon reopening the file, all I see are #value in all the cells that use this formula. If I double click the cell to edit it and just hit enter, the cell and only that cell updates correctly. If I then drag that cell over the rest of the cells using that function, they all update.

I then added application.volatile to the UDF and they all update after I double click and hit enter. However, once I change one of the referenced ranges, they all go back to #value until I double click on one of the cells and hit enter.

Please Login or Register  to view this content.

So apparently, don't try to reference ranges on multiple sheets