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 ...
Thank you so much for replying. Unfortunately I don’t have as much knowledge on the subject as perhaps I should. I am learning. Do you know what steps I can take to check this? I suspect that this may indeed be the issue. This is part of a macro that runs every evening and when I checked the virtual machine that this was running on I noticed that it was asking me for my Google ID and password. It was trying to install Google Drive. I think something might’ve changed with Google? Anyway, how can I check these credentials? In Excel? Or do I do it somewhere on the Google sheet? I know how to get to the advanced properties of the query within excel, but where do I check the credentials?
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!
