I have a data connection to a load of XML files. We use this to collaborate deadlines and it updates automatically every 2 minutes. However if someone is in a sheet view, when the data refreshes, it defaults everyone’s sheet view back to default.
Is there anything we can do to prevent this?
