Forum Discussion
moneerbarazi
Jan 22, 2020Copper Contributor
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 ...
KPU73
Nov 24, 2020Copper Contributor
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!
adlbrk
Feb 11, 2024Copper Contributor
I'm also flustered over the same problem. Google is constantly creating these updates from sheets that shouldn't be interfering with excel