I have an excel file that uses an ODBC connection to connect to Azure Databricks. My aim is to be able to open the excel file, click "Refresh All" on the data tab, and have the most recent data in my excel report on a separate page labelled "Data." When I refer to that "Data" sheet on occasion (and I cannot reproduce this mistake), I receive a #REF! error that does not go away even after refreshing the data.
Is anyone aware of what is causing this, and can you assist me in taking preventative measures?
In case it matters, the "Data" sheet has the same amount of rows and columns every time.
I've looked on YouTube and Google for solutions, but I haven't been able to discover one.