This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have an Excel sheet with database connections to a folder on my computer, and I just recently started receiving an Expression Error when I try to refresh the data in the sheet. The folder contains six Excel sheets that are refreshed/replaced periodically. I have read other forums saying that changes to the source data might be causing the issue, but the columns/headers of my data sheets have not changed at all.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Could you share a screenshot of that error?
The quickest way is to reimport the data. Then you can copy code from original query.
I tried to refresh the data in my sheet this morning, and I did not receive the Expression Error I previously mentioned, but now my data is incomplete. The first image shows the data that is loaded into my sheet with data connections. Once it reaches the 'Strain' column of the source labeled '250 INACTIVE', the columns are all blank. The second image is a screenshot of the source data in the file labeled '250 INACTIVE'. As you can see, those fields are not blank.
Is it possible to share both files to check your issue?
For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here. *Please make sure you have removed any sensitive or private information in the sample file before uploading.