Added a test to make sure that global named references that are referred to as sheet named references are correctly replaced