two files open, 1 read only, 1 non-read only version, vba & pivot is being impacted

is there any way i can prevent a sheet and its functionality being impacted if a non-read only version and a read-only version are open at the same time? under this scenario, the sheet won't update correctly.

i have code in there that will only make the sheet work if the name of the sheet meets a naming condition, it does work, but if a non-read only and read only are open at the same time, i run into some issues, i was hoping to prevent any odd things from happening under this scenario,