Forum Discussion
Expression error with data query
Hi, I have a table of data that is connected to my excel sheet through a query. When I try to refresh the table, I get this message: [expression error]. The column "calendar" of the table wasn't ...
I am encountering the exact same issue! Stock quotes that I have used for several years has now stopped working. I've done nothing myself to the spreadsheet over the past week. Not sure if it is Google Drive or Excel
millerboyz Most probably Google, please check my previous post here.
- While my Google file appears to update correctly each time it is accessed, the Excel file continues to produce the error message when I attempt to refresh with data from Google.
millerboyz I definitely think it had something to do with the link to the google sheet. Now it works for me too. Of course, I already crated a NEW google sheet and new spreadsheet to get it to work, but now when I go back to the old ones they work. How crazy is that. What gets me though is why it didn't just "say" that the problem was with some sort of connection/permissions issue, but instead gave the error alluding to a column issue. Anyway - thanks to all who helped with this one. As much as I'm a bit peeved at google right now, I couldn't do my job with out them, so will just have to chalk it up to a learning exprerience!
- I'm also flustered over the same problem. Google is constantly creating these updates from sheets that shouldn't be interfering with excel
