Hello
Sumproduct is now my favorite new tool in excel - however, I'm having trouble with the formula when it includes a reference to a table in a closed excel file. The formula works fine when the file is open, but as soon as I close the file and then click anywhere in my results file (or hit save) the formula results in #ref error. The other file has multiple tabs and is quite large. If I copy one of the tables to a new file and reference my formula to the new file it will work fine.
Any suggestions would be welcome!
Shandra
Bookmarks