Understand, however, I have no other solution and I do have the other spreadsheet open when I am updating but I do appreciate your input on that too.